Postgres Tutorial Curriculum

  • Overview, History and What you will learn
  • Data Types
  • Basic PostgreSQL Commands
    • Create
    • Delete
    • Insert
    • Update
    • Alter
  • Advanced Queries
  • Aggregates
  • Functions and Operators
  • Constrains
  • Joins
  • Numbering Rows
  • Advanced SELECT Statements
  • PL/pgSQL
  • Subqueries
  • Views
  • Transactions and Locks
  • LIMIT and Cursor
  • Enhancing Performance
  • Managing Tables
  • Import and Export Data
  • Tools – psql, pgaccess and phpPgAdmin