Learn SQL Using PostgreSQL: From Zero to Hero

Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE

Created by: Will Bunker
Cofounder of bootstrapped company that became Match.com

What Will I Learn?

• Perform sophisticated queries
• Join tables together
• Use Group By to answer questions on aggregated date
• Create and modifying tables
• Create indexes to improve search speed
• Put in constraints to keep data clean
• Use pgAdmin tool
• Learn recursive queries
• How views make accessing data simpler
• Subqueries
• Sequences to auto increment fields
• Common Table Expressions
• Conditional Expressions
• Window Functions
• How to handle date and time data
• SQL Functions
• Transactions and Concurrency Control
• PL/pgSQL Functions
• Triggers
• Composite Data Types
• Array Data Types

Requirements

• Basic computer skills.
• Ability to install software on system.
• Computer that can run PostgreSQL ( I will show you how to install ).

Target audience

• Someone wanting to master PostgreSQL and SQL query language
• Anyone wanting to learn advanced query expressions