Examius
🌍 Worldwide · Data & AI
SQL & Databases Syllabus
A comprehensive, hands-on path from relational fundamentals and SQL querying to data modeling, indexing, query optimization, transactions, administration, and modern scaling and analytics platforms.. The complete SQL & Databases outline — 7 subjects, 37 chapters and 153 topics — laid out so you can see exactly what has to be covered and tick each item off as you go.
SQL & Databases subjects
Each subject below has its own page with the full chapter → topic → sub-topic tree and a set of real exam-style flashcards.
4 chapters · 16 topics
Querying Data with SQL6 chapters · 28 topics
Advanced SQL and Programmability7 chapters · 26 topics
Data Modeling and Database Design6 chapters · 23 topics
Indexing and Query Optimization4 chapters · 19 topics
Transactions, Concurrency, and Administration5 chapters · 21 topics
Modern Data Platforms and Scaling5 chapters · 20 topics
SQL & Databases flashcard decks
365 question-and-answer cards across 7 decks, written against this syllabus. Preview any deck free.
- Relational Database Fundamentals — 51 cards
- Querying Data with SQL — 51 cards
- Advanced SQL and Programmability — 50 cards
- Data Modeling and Database Design — 51 cards
- Indexing and Query Optimization — 50 cards
- Transactions, Concurrency, and Administration — 51 cards
- Modern Data Platforms and Scaling — 61 cards
How to work through the SQL & Databases syllabus
The outline on this page is arranged the way the syllabus itself is: subject, then chapter, then topic, then sub-topic. That last level is what most study plans skip, and it is where coverage actually goes wrong — a chapter marked "done" often has three sub-topics inside it that were never touched.
Weight your plan accordingly: Querying Data with SQL carries 28 topics while Relational Database Fundamentals carries 16. Giving both the same number of weeks is the most common planning mistake for SQL & Databases.
The ~115 hour estimate above is a first pass only: roughly 45 minutes per topic plus 12 minutes per sub-topic. Revision cycles, past papers and mocks sit on top of that number.
SQL & Databases syllabus FAQ
What subjects are in the SQL & Databases syllabus?
SQL & Databases covers 7 subjects: Relational Database Fundamentals, Querying Data with SQL, Advanced SQL and Programmability, Data Modeling and Database Design, Indexing and Query Optimization, Transactions, Concurrency, and Administration and Modern Data Platforms and Scaling. Together they contain 37 chapters and 153 named topics.
How much do you have to study for SQL & Databases?
The full SQL & Databases outline breaks down into 37 chapters, 153 topics and 0 sub-topics. Querying Data with SQL is the largest single subject with 28 topics across 6 chapters.
How long does it take to cover the whole SQL & Databases syllabus?
Roughly 115 hours for one full pass. That estimate allows about 45 minutes per topic plus 12 minutes per sub-topic, so it is first-pass coverage — revision, past papers and mock tests sit on top of it. At 3 hours a day that is about 5 weeks.
Are there SQL & Databases flashcards?
Yes — 365 question-and-answer flashcards across 7 decks, one per subject, written against this syllabus. A sample of every deck is readable on this site for free, and the complete decks are in the Examius app.
Is this SQL & Databases syllabus free to use?
Yes. Every page here is free to read, and importing the SQL & Databases syllabus into the Examius app to tick off topics as you finish them is free too. No account is needed to start.
Related Data & AI syllabuses
Foundations of artificial intelligence covering intelligent agents, search, knowledge representation, reasoning, machine learning, and AI applications.
Data Analytics syllabusAnalyze and visualize data to support decision-making using analytical tools and techniques across the full analytics lifecycle.
Deep Learning syllabusA comprehensive study of neural networks and modern deep learning, spanning foundations, CNNs, sequence models, transformers, generative models, and production frameworks.
Google Data Analytics Professional Certificate syllabusGoogle's career certificate teaching entry-level data analytics through spreadsheets, SQL, R programming, and Tableau across the full analysis workflow.