← Back to courses
Data Science and AI
SQL with PostgreSQL
Design tables, write queries and make them fast
A classroom course in the SQL language, taught on PostgreSQL. The modules follow Part II of the PostgreSQL 18 documentation, "The SQL Language": syntax, data definition, data manipulation, queries, data types, functions and operators, indexes, full text search, concurrency control and performance tips. This course prepares for no exam.
10Modules
BeginnerLevel
2 monthsDuration
COURSE THUMBNAIL
What you will be able to do
Design tables with the right types and constraints
Write queries with joins, grouping and subqueries
Use window functions for running totals and rankings
Choose indexes that make a query faster
Keep data consistent with transactions
Read a query plan to find why a query is slow
Course outline
01
SQL syntax and a first database
02
Data definition: tables, constraints and schemas
03
Data manipulation: insert, update and delete
04
Queries: joins, grouping and subqueries
05
Window functions and common table expressions
06
Data types, functions and operators
07
Indexes
08
Full text search
09
Transactions and concurrency control
10
Performance tips: reading a query plan
Tools you will use
PostgreSQLpsqlpgAdminSQL
What you need
General computer skills
No database or programming experience needed
