Course Description

Learning SQL was one of the most valuable skills I learned while building Match.  We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running.  The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.  

I want to teach you how to use PostgreSQL.  We will walk through

  • Basic selection statements

Joining multiple tables together

  • Grouping records to get aggregate data

Inserting, updating and deleting records

  • Creating tables and indexes

Subqueries to create sophisticated reports

  • Table constraints to keep data clean

Sequences to create auto incrementing fields

  • CTE - common table expressions that include recursive queries

Views to simply accessing complex queries

  • Conditional Expressions for queries

Window functions to combine regular queries with aggregate data

  • How to work with date, time and intervals

Create SQL Functions to capture complex statements

  • Create PL/pgSQL Functions that allow programming with if/then and loops

Triggers

  • Array data types

Composite data types

  • Transactions and concurrency control

Course Details
en
en
Will Bunker
Self-paced
Beginner
17 hours
Course Details
en
en
Will Bunker
Self-paced
Beginner
17 hours
Course Description

Learning SQL was one of the most valuable skills I learned while building Match.  We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running.  The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.  

I want to teach you how to use PostgreSQL.  We will walk through

  • Basic selection statements

Joining multiple tables together

  • Grouping records to get aggregate data

Inserting, updating and deleting records

  • Creating tables and indexes

Subqueries to create sophisticated reports

  • Table constraints to keep data clean

Sequences to create auto incrementing fields

  • CTE - common table expressions that include recursive queries

Views to simply accessing complex queries

  • Conditional Expressions for queries

Window functions to combine regular queries with aggregate data

  • How to work with date, time and intervals

Create SQL Functions to capture complex statements

  • Create PL/pgSQL Functions that allow programming with if/then and loops

Triggers

  • Array data types

Composite data types

  • Transactions and concurrency control