Master relational databases and SQL querying for business intelligence, data science, and research. From basic SELECT statements to advanced window functions and database design.
Install SQLite and DBeaver, create your first database, and run your first queries.
CoreRetrieve and filter data with WHERE, LIKE, IN, BETWEEN, ORDER BY, and LIMIT.
CoreCombine tables with INNER, LEFT, RIGHT, FULL, CROSS, and self-joins.
QuerySummarize data with COUNT, SUM, AVG, MIN, MAX, GROUP BY, and HAVING.
QueryNest queries, use WITH (Common Table Expressions), and write recursive CTEs.
QueryROW_NUMBER, RANK, LAG, LEAD, running totals, and moving averages.
QueryINSERT, UPDATE, DELETE, MERGE, transactions, and data loading workflows.
DesignNormalization, ER diagrams, constraints, data types, and schema planning.
DesignIndexes, EXPLAIN plans, query tuning, views, and performance best practices.
DesignBuild a complete analytics pipeline: schema design, data loading, analysis queries, and reporting.
CapstoneOfficial docs for the most widely deployed database engine.
Comprehensive documentation for the most advanced open-source RDBMS.
Interactive SQL lessons with real-world datasets for data analysts.
Free interactive SQL exercises with instant feedback.