Database Series: The Definitive Guide to PostgreSQL

Introducing PostgreSQL. This first topic in the PostgreSQL video series introduces you to the world of relational databases and PostgreSQL. Follow along with Victor in this hands-on session to download, install, setup, and configure PostgreSQL, both the Graphical User Interface (GUI) and the console. Also get PGAdmin and the command line tool psql up and running.
Creating and Modifying Tables in PostgreSQL. This second topic in the PostgreSQL video series focuses on PostgreSQL tables. Learn about tables, rows, columns, and referential integrity. Follow along with Victor and practice creating and modifying tables in PostgreSQL.
Assigning Data Types in PostgreSQL. This third topic in the PostgreSQL video series focuses on PostgreSQL data types. Follow along with Victor and practice creating and modifying numeric, string, Boolean, Enumerated, Date, and Time data types in PostgreSQL. Numeric data types include Smallint, Integer, Bigint, Decimal, Numeric, Real, Double precision, Smallserial, Serial, and Bigserial. String data types include Character, Varchar, and Text.
Creating Domains in PostgreSQL. This fourth topic in the PostgreSQL video series focuses on PostgreSQL domains. Follow along with Victor and practice creating and using domains to expand the set of data types in PostgreSQL. Also create constraints during this session.
Inserting Data in PostgreSQL. This fifth topic in the PostgreSQL video series focuses on inserting data in PostgreSQL. Follow along with Victor and practice inserting data into tables in PostgreSQL. Also apply PostgreSQL constraints.
Querying Data in PostgreSQL. This sixth topic in the PostgreSQL video series focuses on querying data from tables in PostgreSQL. Follow along with Victor and practice querying data in PostgreSQL using the SELECT statement. Apply both queries and subqueries in this session.
Joining Data in PostgreSQL. This seventh topic in the PostgreSQL video series focuses on joins across tables in PostgreSQL. Follow along with Victor and practice creating inner joins, left joins, right joins, and full outer joins in PostgreSQL.
Creating Views in PostgreSQL. This eighth topic in the PostgreSQL video series focuses on PostgreSQL views. Follow along with Victor and practice creating and modifying virtual tables in PostgreSQL.
Creating and Running Functions in PostgreSQL. This ninth topic in the PostgreSQL video series goes into detail on functions in PostgreSQL. Follow along with Victor and practice creating and running functions (stored procedures) in PostgreSQL.
Creating and Running Triggers in PostgreSQL. This tenth topic in the PostgreSQL video series focuses on PostgreSQL triggers. Follow along with Victor and practice creating and running triggers in PostgreSQL.
Optimizing in PostgreSQL. This 11th topic in the PostgreSQL video series covers optimizing PostgreSQL. Follow along with Victor and practice optimizing table structures, query structures, max_connections, autovacuum, and Work_mem in PostgreSQL. Also create indexes in this session.
Backing Up Data in PostgreSQL. This 12th topic in the PostgreSQL video series focuses on backups in PostgreSQL. Follow along with Victor and practice backing up data through Continuous Archiving and Point-In-Time Recovery (PITR), File System Level Backup, and SQL Dump.