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