- Getting started with PostgreSQL
- Setting up the development environment
- Basics of SELECT queries
- Sorting and limits
- 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 handling
- Numeric and text types
- Special data types
- Creating tables
- Altering tables
- Foreign keys
- Relationships between tables
- Inserting data
- Transactions
- Importing from CSV
- Bulk data loading
- Basics of normalization
- Database design
- JSON and JSONB
- Advanced JSON handling
- Array basics
- Advanced array handling
- Introduction to indexes
- Specialized indexes
- Transaction basics
- Transaction isolation
- Performance analysis
- Query optimization
- Backup
- 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
- Debugging PL/pgSQL
- Nested transactions
- Complex procedures
- Analytical functions
- Report automation
- Diagnostics and debugging
- Final optimization
300+
Lectures
400+
Tasks
60
Tests
Also:
- Instant grading
- AI mentor
- IDE plugin
- WebIDE
- Gamification
- Motivational lectures