SQL Fundamentals
Start your database journey with essential SQL skills. This 6-week course covers data retrieval, filtering, joins, aggregations, and basic data manipulation. Includes hands-on exercises with sample databases and weekly assignments reviewed by instructors. Ideal for analysts, developers, and anyone working with data.
Advanced Query Writing
Take your SQL beyond basics. Learn window functions, recursive queries, common table expressions, and advanced join patterns. You will tackle complex reporting requirements and build queries that handle real business logic. Prerequisites: SQL Fundamentals or equivalent experience.
Database Design Principles
Learn to design databases that scale. Cover normalization theory, entity-relationship modeling, indexing strategies, and schema design patterns. Work through case studies from e-commerce, healthcare, and financial systems. Build a complete database design as your capstone project.
Performance Optimization
Make slow databases fast. Learn query plan analysis, index optimization, partitioning strategies, and caching techniques. Diagnose bottlenecks using execution plans and monitoring tools. Work with datasets large enough to demonstrate real performance challenges. Our most popular course for working DBAs.
PostgreSQL Administration
Master PostgreSQL from installation to production management. Cover configuration tuning, backup and recovery, replication setup, security hardening, and monitoring. Each participant receives a cloud-based PostgreSQL instance for practice. Prepares you for PostgreSQL certification exams.
Data Warehousing Concepts
Understand how analytical databases differ from operational ones. Learn dimensional modeling, star and snowflake schemas, ETL pipeline design, and data quality practices. Explore modern data warehouse platforms and when to use each. Great preparation for data engineering roles.
