Query Optimization
Intermediate
Optimize slow database queries
Optimize slow SQL queries for a high-traffic e-commerce application. Identify performance bottlenecks and implement solutions.
15-20 minIntermediate
Schema Design
Intermediate
Design an efficient database schema
Design a database schema for a social media application. Ensure it's normalized, efficient, and can handle the required queries.
20-25 minIntermediate
Data Analysis
Advanced
Analyze complex datasets with SQL
Use SQL to analyze a complex dataset and extract meaningful insights. Implement window functions, aggregations, and complex joins.
25-30 minAdvanced