CodeGym/Courses/SQL Course

SQL Course

Want to master SQL and become a database specialist? Take the journey from simple queries to expert-level PostgreSQL work. 60 levels and hundreds of tasks with instant verification. Modern SQL capabilities, JSON handling, performance optimisation — all through hands-on practice. No fluff, only what you need for work.

4.9

250+ reviews

5K graduates became SQL experts

Learn More

First Steps with PostgreSQL
Setting Up Your Environment
SELECT Query Fundamentals
Sorting and Limiting
Data Formatting
Advanced Sorting
Introduction to Aggregation
Grouping and Filtering
Understanding NULL
Working with NULL in Practice
JOIN Basics
Advanced JOINs

Introduction to Subqueries
Advanced Subqueries
CTE Basics
Advanced CTEs
Introduction to Window Functions
Advanced Window Functions
Date and Time Types
Advanced Date Operations

Numeric and Text Types
Special Data Types
Creating Tables
Altering Tables
Foreign Keys
Table Relationships
Data Insertion
Transactions
CSV Import
Bulk Data Loading
Normalization Basics
Database Design

JSON and JSONB
Advanced JSON Operations
Array Basics
Advanced Array Operations
Introduction to Indexes
Specialized Indexes
Transaction Basics
Transaction Isolation

Performance Analysis
Query Optimization
Backup Strategies
Data Recovery
Monitoring Basics
Advanced Monitoring
User Management
Security and Encryption
PL/pgSQL Basics
PL/pgSQL Functions
Introduction to Triggers
Automation with Triggers

Control Structures
PL/pgSQL Debugging
Nested Transactions
Complex Procedures
Analytical Functions
Report Automation
Diagnostics and Debugging
Final Optimisation

300+

Lessons

400+

Tasks

Tests

And also:

Instant task verification
AI mentor
IDE plugin
WebIDE
Gamification
Motivational lectures