Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
16 Hour(s) 13 Minute(s)
Language
English
Taught by
Will Bunker
Rating
Course Overview
Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE
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 Content
- 35 section(s)
- 182 lecture(s)
- Section 1 Introduction
- Section 2 Installing PostgreSQL and pgAdmin
- Section 3 Simple Selection of All Records
- Section 4 Using WHERE to Select Records
- Section 5 Schemas
- Section 6 Using psql To Connect To Postgres
- Section 7 Intermediate SELECT Statements
- Section 8 Joining multiple tables together
- Section 9 Grouping and Aggregation Functions
- Section 10 Combining Queries
- Section 11 Subqueries
- Section 12 Modifying Data In Tables: INSERT, UPDATE and DELETE
- Section 13 Indexes and Performance Tuning
- Section 14 Database Design and Normalization
- Section 15 Creating and Modifying Tables
- Section 16 Table Constraints
- Section 17 Sequences
- Section 18 CTE - Common Table Expressions
- Section 19 Views
- Section 20 Conditional Expressions
- Section 21 Using Date/Time In PostgreSQL
- Section 22 Window Functions
- Section 23 Composite Types
- Section 24 SQL Functions and Procedures
- Section 25 Transactions And Concurrency Control
- Section 26 Array Data Type
- Section 27 PL/pgSQL - SQL Procedural Language
- Section 28 Triggers
- Section 29 Importing CSV
- Section 30 JSON and JSONB Data Types
- Section 31 Managing Databases
- Section 32 Backups and Recovery
- Section 33 Security Using Roles, Users and Permissions
- Section 34 Introduction To PostGIS
- Section 35 Thanks and Good Luck
What You’ll 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
Skills covered in this course
Reviews
-
SSaikumar Kompelli
The PostgreSQL course provided a strong and practical foundation in database management. It covered essential concepts such as schema design, data types, constraints, joins, indexing, and advanced features like views, triggers, and functions. The inclusion of real-time scenarios and hands-on exercises made it easier to understand how PostgreSQL works in practical environments. One of the most valuable aspects of the course was learning about performance optimization techniques, including indexing strategies and query tuning. Topics like backup and restore using pg_dump and pg_restore were especially useful for real-world applications. Additionally, exposure to advanced concepts such as Row-Level Security (RLS), roles, and permissions helped in understanding how to secure databases effectively. The course structure was clear and progressive, starting from basic SQL queries and gradually moving towards more advanced topics. The practical assignments and problem-solving sessions enhanced confidence in writing queries and debugging errors. Overall, the PostgreSQL course was highly informative and practical, making it suitable for both beginners and intermediate learners. It significantly improved my confidence in working with databases and handling real-time use cases.
-
MMahesh Warekar
Excellent course with very good explanations.
-
AAnonymized User
Simple analogy and functional db for explanation
-
JJeanne Lane
I had some database experience, but I want to learn more concepts and with postgres. This class covered indexing, explain, window functions like rank(), and PostGIS--concepts I wanted to learn more about. Instructor is clear and gives examples of how different concepts were used in his business.
