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 full SQL & Databases syllabus: 7 subjects, 37 chapters and 153 topics, with 365 flashcards written against it.
SQL & Databases subjects
SQL & Databases has 7 subjects. Each one is listed below with its chapters in syllabus order; open a subject for every topic and sub-topic inside them.
Relational Database Fundamentals
- Database Concepts and Architecture · 4 topics
- Keys and Integrity Constraints · 4 topics
- Data Types and Schema Definition · 4 topics
- SQL Sublanguages Overview · 4 topics
Querying Data with SQL
- Single-Table Queries · 5 topics
- Joining Tables · 6 topics
- Aggregation and Grouping · 4 topics
- Subqueries · 5 topics
- Set Operations · 3 topics
- Functions and Expressions · 5 topics
Advanced SQL and Programmability
- Window Functions · 5 topics
- Common Table Expressions · 3 topics
- Modifying Data · 5 topics
- Views and Materialized Views · 3 topics
- Stored Procedures and Functions · 4 topics
- Triggers and Automation · 3 topics
- Pivoting and Advanced Patterns · 3 topics
Data Modeling and Database Design
- Conceptual and Logical Modeling · 4 topics
- Normalization · 5 topics
- Denormalization and Trade-offs · 3 topics
- Physical Database Design · 4 topics
- Schema Patterns and Anti-Patterns · 4 topics
- Schema Evolution and Migrations · 3 topics
Indexing and Query Optimization
- Index Fundamentals · 4 topics
- Specialized Index Types · 5 topics
- Query Execution and Planning · 5 topics
- Performance Tuning · 5 topics
Transactions, Concurrency, and Administration
- Transactions and ACID · 3 topics
- Concurrency Control · 5 topics
- Security and Access Control · 5 topics
- Backup, Recovery, and Reliability · 4 topics
- Monitoring and Maintenance · 4 topics
Modern Data Platforms and Scaling
- SQL vs NoSQL · 4 topics
- Scaling Relational Databases · 4 topics
- Data Warehousing and Analytics · 5 topics
- SQL in the Data Engineering Workflow · 4 topics
- Cloud and Managed Databases · 3 topics
SQL & Databases flashcards
365 question-and-answer cards across 7 subject decks, each shown in full on its subject page.
- 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
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.
How many chapters and topics are in the SQL & Databases syllabus?
37 chapters and 153 topics, across 7 subjects. Querying Data with SQL is the largest subject, with 28 topics in 6 chapters.
Are there SQL & Databases flashcards?
Yes — 365 question-and-answer flashcards in 7 subject decks. Each deck is printed in full on its subject page here, and the same cards are in the Examius app with spaced repetition. The free plan covers one exam of your choice, including its flashcards; Examius Pro, a one-time purchase, unlocks every other exam and deck.
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.