What will you learn in Databases: OLAP and Recursion course
- Introduction to the relational model and concepts in relational databases and relational database management systems
- Comprehensive coverage of SQL, the long-accepted standard query language for relational database management systems
- Creating indexes for increased query performance
- Using transactions for concurrency control and failure recovery
- Database constraints: key, referential integrity, and "check" constraints
- Database triggers
- How views are created, used, and updated in relational databases
- Authorization in relational databases
Program Overview
Module 1: On-Line Analytical Processing (OLAP)
1-2 weeks
- Analyzing multidimensional data using OLAP operations
- Implementing cube and rollup functions in SQL
- Optimizing queries for analytical workloads
Module 2: Recursive Query Processing
1-2 weeks
- Writing recursive common table expressions in SQL
- Modeling hierarchical data with recursive queries
- Processing transitive closure using recursion
Module 3: Advanced SQL Programming
1-2 weeks
- Creating and managing database views
- Enforcing data integrity with check constraints
- Implementing referential actions in foreign key constraints
Module 4: Database Triggers and Automation
1-2 weeks
- Designing row-level and statement-level triggers
- Using triggers for audit logging and validation
- Managing trigger execution order and side effects
Module 5: Indexing and Query Optimization
1-2 weeks
- Building B-tree and hash-based indexes
- Improving query performance with index selection
- Understanding index trade-offs in update-heavy workloads
Get certificate
Job Outlook
- High demand for SQL and database skills in data roles
- Relevant for data engineering and analytics positions
- Valuable for backend and full-stack software development
