PostgreSQL
Standalone PostgreSQL course — from database basics to complex queries and final project.
Foundations + DDL
(7 lessons)Introduction to Databases
Introduction to databases, RDBMS concepts, and PostgreSQL overview.
Database Components & Normalization
Database components, tables, relationships, and normalization principles.
Database Modeling
Entity-relationship modeling and database design fundamentals.
CREATE & DROP
Creating and dropping databases, schemas, and tables with DDL.
INSERT Basics
Inserting data into tables with basic INSERT INTO statements.
ALTER & Constraints
Altering table structure and working with constraints.
Foreign Keys
Creating foreign key constraints and managing table relationships.
SELECT Queries
(7 lessons)SELECT Basics
Basic SELECT queries, WHERE clause, and result filtering.
JOINs
INNER JOIN, LEFT JOIN, RIGHT JOIN, and multi-table queries.
WHERE Advanced
Advanced filtering with LIKE, IN, BETWEEN, IS NULL, and compound conditions.
Aggregation
Aggregate functions, GROUP BY, HAVING, and summary statistics.
Subqueries Theory
Subqueries in WHERE, FROM, and SELECT clauses.
Subqueries Practice
Practice exercises with subqueries and complex queries.
SELECT Exam & INSERT Intro
SELECT query examination and introduction to advanced INSERT.
DML + Final
(4 lessons)INSERT Advanced
Advanced INSERT techniques: subqueries, ON CONFLICT, and bulk inserts.
UPDATE & DELETE
Updating and deleting data with UPDATE and DELETE statements.
Final Project Assignment
Final project requirements and in-class work session.
Final Project Defense
Final project defense and course evaluation.