Beginning Databases with PostgreSQL
Although this book is concerned with PostgreSQL version 8 and its database design is questionable, it's still a pretty good source for learning Postgres and SQL in general.
- pg. 55 - Creating Users (using the
createuser.exe) - pg. 66 - Creating Databases (using the
createdb.exe) - pg. 67 - Creating Tables
- pg. 68 - Deleting Tables When a table is dropped, its sequence relations are also deleted so there's no need to delete them manually.
- pg. 69 - Populating Tables
This entire chapter is devoted to the SELECT statement.
- pg. 74 - Connecting to PostgreSQL using
psql.exe - pg. 75 - Connecting to a remote server.
- pg. 78 - Essential
psqlcommands list - pg. 87 - Standard comparison operators
- pg. 94 - PostgreSQL Date/Time formatting (ISO-8601, YYYY-MM-DD hh:mm:ss.ssTZD)
- pg. 99 - Extracting parts of a date (year, month, day, hour, minute, second)
- pg. 103 - Relating two tables
- pg. 105-106 - Aliasing table names
- pg. 106 - Relating three or more tables.
- pg. 111 - SQL92 JOIN syntax
- pg. 118 -
psqlCommand-Line Quick Reference - pg. 119 -
psqlInternal Commands Quick Reference
- pg. 153 - INSERTing data
- pg. 155 - Caution Avoid providing values for
serialdata columns when inserting data - pg. 155 - Manipulating the
serialvalue - pg. 160 - Copying data from flat files (CSV or files using other delimiters)
- pg. 166 - Updating data (the UPDATE statement)
- pg. 169 - The DELETE statement
- pg. 170 - TRUNCATE (deletes all the rows from the specified table)
- pg. 174 - Aggregate functions list
- pg. 176 - GROUP BY clause
- pg. 178 - HAVING clause
- pg. 185 - Subqueries
*pg. 2
Reading plan: Monday - Chapters 8, 9, 10 Tuesday - Chapters 11, 12 Wednesday - Appendixes A to F