SQL SELF

Never worked with databases? No problem! This 60-level quest will take you from zero to pro. You will learn the basics of SQL, learn how to create and modify tables, master complex queries with JOIN and subqueries. Then dive into advanced topics: window functions, CTE, working with JSON and arrays. Learn how to design databases, configure indexes and optimize performance. And also master transactions, triggers and writing procedures in PL/pgSQL. You will master pgAdmin and psql, learn how to write code like a real database specialist.

Level 1
Unavailable
Introduction to Databases
Level 2
Unavailable
Learning the SELECT statement
Level 3
Unavailable
Filtering, sorting, and pagination
Level 4
Unavailable
Installing the IDE and plugin
Level 5
Unavailable
Formatting rows
Level 6
Unavailable
Complex selections and sorting
Level 7
Unavailable
Grouping and aggregates
Level 8
Unavailable
Advanced work with aggregates
Level 9
Unavailable
Working with NULL and conditions
Level 10
Unavailable
Advanced conditions and comparisons
Level 11
Unavailable
Introduction to joins (JOIN)
Level 12
Unavailable
Multiple and complex JOIN
Level 13
Unavailable
Nested SELECTs and subqueries
Level 14
Unavailable
Advanced work with subqueries
Level 15
Unavailable
Data types in PostgreSQL
Level 16
Unavailable
Getting to know about arrays and JSON
Level 17
Unavailable
Creating and modifying tables
Level 18
Unavailable
Constraints and data integrity
Level 19
Unavailable
Foreign keys and relationships
Level 20
Unavailable
Modeling relationships
Level 21
Unavailable
Inserting, updating, and deleting data
Level 22
Unavailable
Getting to know about transactions
Level 23
Unavailable
Bulk data loading
Level 24
Unavailable
Working with CSV and import
Level 25
Unavailable
Normalization and DB structure
Level 26
Unavailable
Modeling and ER diagrams
Level 27
Unavailable
Common Table Expressions (CTE)
Level 28
Unavailable
Recursive CTEs and complex queries
Level 29
Unavailable
Introduction to window functions
Level 30
Unavailable
Advanced work with window functions
Level 31
Unavailable
Working with dates and times
Level 32
Unavailable
Working with time zones and time series
Level 33
Unavailable
Introduction to JSONB
Level 34
Unavailable
Advanced work with JSONB
Level 35
Unavailable
Working with arrays
Level 36
Unavailable
Advanced work with arrays
Level 37
Unavailable
Indexes and optimization
Level 38
Unavailable
Indexing arrays and JSON
Level 39
Unavailable
Transactions and isolation
Level 40
Unavailable
Isolation levels and anomalies
Level 41
Unavailable
Query execution plan
Level 42
Unavailable
Monitoring and pg_stat_statements
Level 43
Unavailable
Backups and restore
Level 44
Unavailable
Bulk restore and backup
Level 45
Unavailable
Monitoring PostgreSQL operation
Level 46
Unavailable
PostgreSQL system metrics
Level 47
Unavailable
Security and access
Level 48
Unavailable
Encrypting columns and tables
Level 49
Unavailable
Introduction to PL/pgSQL
Level 50
Unavailable
PL/pgSQL: functions and procedures
Level 51
Unavailable
PL/pgSQL: working with errors and logs
Level 52
Unavailable
PL/pgSQL: loops and control structures
Level 53
Unavailable
Nested procedures and nested transactions in PL/pgSQL
Level 54
Unavailable
Problems with working with transactions: LOCK and DEADLOCK
Level 55
Unavailable
Final debugging of scripts in PL/pgSQL
Level 56
Unavailable
Comprehensive debugging and optimization
Level 57
Unavailable
Introduction to triggers
Level 58
Unavailable
Using triggers in PostgreSQL
Level 59
Unavailable
Basic window functions
Level 60
Unavailable
Automatic generation of reports
Level 61
Unavailable
Final project