Master SQL from basics to advanced optimization. Design schemas, write complex queries, optimize performance, and build data pipelines.
Student builds a basic database schema for an e-commerce platform using PostgreSQL, demonstrating understanding of database design principles and data types.
Student optimizes queries for a user login system using MySQL, proving ability to analyze and improve query performance.
Student designs and implements a data warehouse for sales analytics using dbt, demonstrating skills in data transformation and loading.
Student implements indexing on a sample database in PostgreSQL, showcasing understanding of indexing concepts and their impact on query performance.
Student builds a Redis cache layer for frequently accessed data, demonstrating ability to integrate caching mechanisms into a database system.
+15 more projects available after enrollment
Build a real project in 4 weeks