SUBJECT / DBMS
DBMS
How databases store, protect, and retrieve data.
217 topics / 50 articles ready / 2 course paths
DBMS
217 headingsGetting Started5 topics
DBMS Foundations and Architecture5 topics
- File Systems vs Database Management SystemsPlanned
- Data Abstraction, Schemas, Instances, and Data IndependencePlanned
- DBMS Components and End-to-End Query FlowPlanned
- Database Users, Roles, and Deployment ArchitecturesPlanned
- Data Models and Database FamiliesPlanned
Core Foundations12 topics
Conceptual Data Modeling4 topics
- Entities, Entity Sets, and AttributesPlanned
- Relationships and Structural ConstraintsPlanned
- Weak Entities and Enhanced ER ModelingPlanned
- ER/EER-to-Relational MappingPlanned
Database Design9 topics
- Database Design FundamentalsPlanned
- Importance, Raw Data and PainPlanned
- Core Concepts (Overview)Planned
- Mental Model (First Principle)Planned
- Schema DesignPlanned
- Entity and AttributesPlanned
- Relationships, Cardinality and OptionalityPlanned
- Everything About KeysPlanned
- Normalisation and their FormsPlanned
Relational Model and Formal Query Languages6 topics
- Formal Relational Model and Integrity ConstraintsPlanned
- Fundamental Relational AlgebraPlanned
- Joins and Extended Relational AlgebraPlanned
- Tuple and Domain Relational CalculusPlanned
- Views and Materialized ViewsPlanned
- Triggers, Stored Routines, and Database-Side LogicPlanned
Functional Dependencies and Database Design6 topics
- Redundancy and Update AnomaliesPlanned
- Functional Dependencies and KeysPlanned
- Armstrong’s Axioms, Attribute Closure, and Minimal CoverPlanned
- First, Second, Third, and Boyce–Codd Normal FormsPlanned
- Decomposition Quality and Normalization AlgorithmsPlanned
- Multivalued Dependencies, 4NF, Join Dependencies, and 5NFPlanned
Querying Essentials19 topics
- Query FundamentalsRead
- SELECT AND FROMRead
- WHERERead
- Comparison OperatorsRead
- Logical OperatorsRead
- Arithmetic OperatorsRead
- ORDER BY and LIMITRead
- DISTINCT and AS (Aliases)Read
- Big CountriesRead
- Profitable Customers in 2021Read
- Odd Non-Boring MoviesRead
- Filtering EssentialsRead
- IS NULL vs. IS NOT NULL, IN, and NOT INRead
- BETWEEN and NOT BETWEENRead
- LIKE and NOT LIKERead
- Filter Records Excluding a Specific PatternRead
- Find Records Excluding a Given Set of ValuesRead
- Find Salaries Outside the Expected RangeRead
- Non-Referred CustomersRead
Aggregation and Analysis14 topics
- Data SummarizationRead
- Fundamentals of GROUP BYRead
- Basic Aggregate Functions (MIN, MAX, SUM, AVG)Read
- COUNT FunctionsRead
- HAVING Clause (Basics, HAVING with COUNT)Read
- First Login AnalysisRead
- Employee Work Time SummaryRead
- Unique Subjects per TeacherRead
- User Follower CountRead
- CRM Automotive Sales AnalysisRead
- Highest Order Placing CustomerRead
- Frequent Actor-Director DuosRead
- Large ClassesRead
- Email DuplicatesRead
Set Operations9 topics
- Merging Query ResultsPlanned
- UNIONPlanned
- UNION ALLPlanned
- Difference Between UNION and UNION ALLPlanned
- IntersectionPlanned
- Combine Active and Archived UsersPlanned
- Merge Recent Orders from Multiple SourcesPlanned
- Combine Sales Records Without DeduplicationPlanned
- Reshape Products DataPlanned
SQL Joins35 topics
- Joins Deep DivePlanned
- RIGHT JOINPlanned
- ON vs. WHEREPlanned
- LEFT JOINPlanned
- INNER JOINPlanned
- FULL OUTER JOINPlanned
- CROSS JOINPlanned
- IMPLICIT JOINPlanned
- SELF JOINPlanned
- NATURAL JOINPlanned
- Employees and Their DepartmentsPlanned
- Customer Orders OverviewPlanned
- Employees With Confirmed Salary RecordsPlanned
- Generate All Possible User-Category PairsPlanned
- Employees With or Without Salary RecordsPlanned
- Match Employees With Their SalariesPlanned
- Employees Earning More Than Their ManagerPlanned
- Students Enrolled in CoursesPlanned
- Sales AnalysisPlanned
- Minimum Distance Between PointsPlanned
- Suspended AccountsPlanned
- Find Team Size for Each EmployeePlanned
- Average Experience by ProjectPlanned
- Warehouse Stock ManagerPlanned
- Table Join OperationPlanned
- Inactive CustomersPlanned
- Students Enrolled in Non-Existent DepartmentsPlanned
- Low Bonus EmployeesPlanned
- Available Seat StreaksPlanned
- Visitors Without TransactionsPlanned
- A & B Buyers Without CPlanned
- Product Selling Price ReportPlanned
- Updated Bank BalancesPlanned
- Most Frequent TravellersPlanned
- Suggested PagesPlanned
Subqueries25 topics
- Everything about SubqueriesPlanned
- Introduction to Subqueries (IN)Planned
- EXISTS and NOT EXISTSPlanned
- Contest Participation RatePlanned
- High-Report ManagersPlanned
- All-Product BuyersPlanned
- Highest Non-Repeating NumberPlanned
- Find the First Device Logged In by Each PlayerPlanned
- Salespersons Without RED OrdersPlanned
- Employees with the Highest Salary in Each DepartmentPlanned
- Find the Most Recent Order for Each ProductPlanned
- Find Transactions with Maximum Amount Per DayPlanned
- Incomplete Employee RecordsPlanned
- Find Quiet Students in All ExamsPlanned
- Top Grade per StudentPlanned
- Swap Consecutive SeatsPlanned
- Safe Investment CountriesPlanned
- Tennis Grand Slam WinnersPlanned
- Football Team ScoresPlanned
- Order Count per CustomerPlanned
- Boolean Expression EvaluatorPlanned
- Immediate First Orders PercentagePlanned
- Find All Employees Reporting to the Head of the CompanyPlanned
- Orphan EmployeesPlanned
Data Modification and Schema Evolution10 topics
- Editing Data and TablesPlanned
- INSERTPlanned
- UPSERTPlanned
- UPDATEPlanned
- DELETEPlanned
- ALTERPlanned
- TRUNCATEPlanned
- DELETE vs. TRUNCATE vs. DROPPlanned
- System SettingsPlanned
- Employee SalaryPlanned
Physical Storage, Indexing, and Hashing5 topics
- Storage Hierarchy, Pages, Records, and BuffersPlanned
- File OrganizationPlanned
- Index Classification and DesignPlanned
- B-Trees and B+ TreesPlanned
- Static and Dynamic HashingPlanned
Data Storage, Keys, and Query Optimization5 topics
- Storage, Keys and Query PerformancePlanned
- Where Rows Actually LivePlanned
- How a B+ Tree Is Built with DataPlanned
- Why the Wrong Primary Key Can Quietly Destroy YouPlanned
- Index Strategy at ScalePlanned
Query Processing and Optimization4 topics
- From SQL to an Executable PlanPlanned
- Algorithms for Selection, Projection, Sorting, and AggregationPlanned
- Join Processing AlgorithmsPlanned
- Cost-Based Query OptimizationPlanned
Query Performance5 topics
- Performance & DebuggingPlanned
- Raw Data Setup and Stored ProceduresPlanned
- Debugging Queries with EXPLAINPlanned
- Query PerformancePlanned
- Debugging CorrectnessPlanned
Transactions and Access Control11 topics
- Permissions and Transactions Part-1Planned
- Privileges and RolesPlanned
- GRANTSPlanned
- GRANT ALL and WITH GRANT OPTIONPlanned
- ALTER USERPlanned
- REVOKEPlanned
- Permissions and Transactions Part-2Planned
- Connection, Connection Pool and CommitPlanned
- RollbackPlanned
- SavepointPlanned
- Internal Working of Transactions, Timeout and DeadlockPlanned
Transactions and Concurrency Control8 topics
- Transaction Concepts, ACID, and StatesPlanned
- Schedules and Concurrency AnomaliesPlanned
- Conflict and View SerializabilityPlanned
- Recoverable, Cascadeless, and Strict SchedulesPlanned
- Lock-Based Protocols and Two-Phase LockingPlanned
- Deadlock HandlingPlanned
- Timestamp Ordering, Optimistic Control, and MVCCPlanned
- SQL Isolation LevelsPlanned
Database Recovery and Durability4 topics
- Failures, Storage, and Recovery GoalsPlanned
- Log-Based Recovery and Write-Ahead LoggingPlanned
- Checkpoints and ARIES IntuitionPlanned
- Shadow Paging, Backup, and Point-in-Time RecoveryPlanned
Integrity, Security, and Database Operations4 topics
- Declarative Integrity Beyond KeysPlanned
- Database Security Threats and ProtectionPlanned
- Metadata, Statistics, Maintenance, and ObservabilityPlanned
Distributed Databases, NoSQL, and Analytical Systems6 topics
- Distributed Database FoundationsPlanned
- Partitioning, Sharding, and Distributed IDsPlanned
- Replication, Consistency, and CAP/PACELCPlanned
- Distributed Transactions and CoordinationPlanned
- NoSQL Data Models and SQL-vs-NoSQL DecisionsPlanned
- OLTP, OLAP, Warehousing, and Columnar StoragePlanned
Applied Learning and Preparation6 topics
- Schema-Design CapstonePlanned
- Storage and Query-Plan LabPlanned
- Concurrency and Recovery LabPlanned
- GATE and Semester Problem TrackPlanned
- Interview Depth by Candidate LevelPlanned
- Final Coverage and Source AlignmentPlanned
DBMS Interview prep
210 headingsGetting Started5 topics
- Introduction to SQLFoundational Overview of SQLRead
- Why SQL ExistsTheoretical Breakdown of DatabasesRead
- How Databases WorkTheoretical Breakdown of DatabasesRead
- Database SystemsTheoretical Breakdown of DatabasesRead
- Installation and ToolsSQL Setup GuideRead
DBMS Foundations and Architecture5 topics
- File Systems vs Database Management SystemsPlanned
- Data Abstraction, Schemas, Instances, and Data IndependencePlanned
- DBMS Components and End-to-End Query FlowPlanned
- Database Users, Roles, and Deployment ArchitecturesPlanned
- Data Models and Database FamiliesPlanned
Core Foundations12 topics
- Database & Table BasicsDatabase FundamentalsRead
- SQL Basics and CommandsBreakdown of Table BasicsRead
- Working with Databases in SQLBreakdown of Table BasicsRead
- SQL Data TypesBreakdown of Table BasicsRead
- Creating and Managing Tables in SQLBreakdown of Table BasicsRead
- Primary KeyBreakdown of Table BasicsRead
- Foreign KeyBreakdown of Table BasicsRead
- Constraints in SQLBreakdown of Table BasicsRead
- NULL vs 0 vs Empty StringBreakdown of Table BasicsRead
- DDL vs DMLBreakdown of Table BasicsRead
- Query LifecycleBreakdown of Table BasicsRead
- Indexing in SQLBreakdown of Table BasicsRead
Conceptual Data Modeling4 topics
- Entities, Entity Sets, and AttributesPlanned
- Relationships and Structural ConstraintsPlanned
- Weak Entities and Enhanced ER ModelingPlanned
- ER/EER-to-Relational MappingPlanned
Database Design9 topics
- Database Design FundamentalsPrinciples of Data Modeling & Database DesignPlanned
- Importance, Raw Data and PainConceptual Breakdown of DB DesignPlanned
- Core Concepts (Overview)Conceptual Breakdown of DB DesignPlanned
- Mental Model (First Principle)Conceptual Breakdown of DB DesignPlanned
- Schema DesignConceptual Breakdown of DB DesignPlanned
- Entity and AttributesConceptual Breakdown of DB DesignPlanned
- Relationships, Cardinality and OptionalityConceptual Breakdown of DB DesignPlanned
- Everything About KeysConceptual Breakdown of DB DesignPlanned
- Normalisation and their FormsConceptual Breakdown of DB DesignPlanned
Relational Model and Formal Query Languages5 topics
- Formal Relational Model and Integrity ConstraintsPlanned
- Fundamental Relational AlgebraPlanned
- Joins and Extended Relational AlgebraPlanned
- Views and Materialized ViewsPlanned
- Triggers, Stored Routines, and Database-Side LogicPlanned
Functional Dependencies and Database Design4 topics
- Redundancy and Update AnomaliesPlanned
- Functional Dependencies and KeysPlanned
- First, Second, Third, and Boyce–Codd Normal FormsPlanned
- Decomposition Quality and Normalization AlgorithmsPlanned
Querying Essentials19 topics
- Query FundamentalsData Retrieval FundamentalsRead
- SELECT AND FROMData Selection ProtocolsRead
- WHEREData Selection ProtocolsRead
- Comparison OperatorsData Selection ProtocolsRead
- Logical OperatorsData Selection ProtocolsRead
- Arithmetic OperatorsData Selection ProtocolsRead
- ORDER BY and LIMITData Selection ProtocolsRead
- DISTINCT and AS (Aliases)Data Selection ProtocolsRead
- Big CountriesProblems Level 1 (Query Fundamentals)Read
- Profitable Customers in 2021Problems Level 1 (Query Fundamentals)Read
- Odd Non-Boring MoviesProblems Level 1 (Query Fundamentals)Read
- Filtering EssentialsAdvanced Filtering TechniquesRead
- IS NULL vs. IS NOT NULL, IN, and NOT INConceptual Breakdown of FiltersRead
- BETWEEN and NOT BETWEENConceptual Breakdown of FiltersRead
- LIKE and NOT LIKEConceptual Breakdown of FiltersRead
- Filter Records Excluding a Specific PatternProblem Level 1 (Filtering Essentials)Read
- Find Records Excluding a Given Set of ValuesProblem Level 1 (Filtering Essentials)Read
- Find Salaries Outside the Expected RangeProblem Level 1 (Filtering Essentials)Read
- Non-Referred CustomersProblem Level 1 (Filtering Essentials)Read
Aggregation and Analysis14 topics
- Data SummarizationData Aggregation & SummarizationRead
- Fundamentals of GROUP BYConceptual Breakdown of AggregatesRead
- Basic Aggregate Functions (MIN, MAX, SUM, AVG)Conceptual Breakdown of AggregatesRead
- COUNT FunctionsConceptual Breakdown of AggregatesRead
- HAVING Clause (Basics, HAVING with COUNT)Conceptual Breakdown of AggregatesRead
- First Login AnalysisProblems Level 1 (Data Summarization)Read
- Employee Work Time SummaryProblems Level 1 (Data Summarization)Read
- Unique Subjects per TeacherProblems Level 1 (Data Summarization)Read
- User Follower CountProblems Level 1 (Data Summarization)Read
- CRM Automotive Sales AnalysisProblems Level 1 (Data Summarization)Read
- Highest Order Placing CustomerProblems Level 1 (Data Summarization)Read
- Frequent Actor-Director DuosProblems Level 2 (Data Summarization)Read
- Large ClassesProblems Level 2 (Data Summarization)Read
- Email DuplicatesProblems Level 2 (Data Summarization)Read
Set Operations9 topics
- Merging Query ResultsSet Theory & Result MergingPlanned
- UNIONConceptual Breakdown of UnionsPlanned
- UNION ALLConceptual Breakdown of UnionsPlanned
- Difference Between UNION and UNION ALLConceptual Breakdown of UnionsPlanned
- IntersectionConceptual Breakdown of UnionsPlanned
- Combine Active and Archived UsersProblems Level 1 (Merging Query Results)Planned
- Merge Recent Orders from Multiple SourcesProblems Level 1 (Merging Query Results)Planned
- Combine Sales Records Without DeduplicationProblems Level 1 (Merging Query Results)Planned
- Reshape Products DataProblems Level 1 (Merging Query Results)Planned
SQL Joins35 topics
- Joins Deep DiveJoin FundamentalsPlanned
- RIGHT JOINConceptual breakdown of JoinsPlanned
- ON vs. WHEREConceptual breakdown of JoinsPlanned
- LEFT JOINConceptual breakdown of JoinsPlanned
- INNER JOINConceptual breakdown of JoinsPlanned
- FULL OUTER JOINConceptual breakdown of JoinsPlanned
- CROSS JOINConceptual breakdown of JoinsPlanned
- IMPLICIT JOINConceptual breakdown of JoinsPlanned
- SELF JOINConceptual breakdown of JoinsPlanned
- NATURAL JOINConceptual breakdown of JoinsPlanned
- Employees and Their DepartmentsProblems Level 1 (Joins Deep Dive)Planned
- Customer Orders OverviewProblems Level 1 (Joins Deep Dive)Planned
- Employees With Confirmed Salary RecordsProblems Level 1 (Joins Deep Dive)Planned
- Generate All Possible User-Category PairsProblems Level 1 (Joins Deep Dive)Planned
- Employees With or Without Salary RecordsProblems Level 1 (Joins Deep Dive)Planned
- Match Employees With Their SalariesProblems Level 1 (Joins Deep Dive)Planned
- Employees Earning More Than Their ManagerProblems Level 1 (Joins Deep Dive)Planned
- Students Enrolled in CoursesProblems Level 1 (Joins Deep Dive)Planned
- Sales AnalysisProblems Level 2 (Joins Deep Dive)Planned
- Minimum Distance Between PointsProblems Level 2 (Joins Deep Dive)Planned
- Suspended AccountsProblems Level 2 (Joins Deep Dive)Planned
- Find Team Size for Each EmployeeProblems Level 2 (Joins Deep Dive)Planned
- Average Experience by ProjectProblems Level 2 (Joins Deep Dive)Planned
- Warehouse Stock ManagerProblems Level 2 (Joins Deep Dive)Planned
- Table Join OperationProblems Level 3 (Joins Deep Dive)Planned
- Inactive CustomersProblems Level 3 (Joins Deep Dive)Planned
- Students Enrolled in Non-Existent DepartmentsProblems Level 3 (Joins Deep Dive)Planned
- Low Bonus EmployeesProblems Level 3 (Joins Deep Dive)Planned
- Available Seat StreaksProblems Level 3 (Joins Deep Dive)Planned
- Visitors Without TransactionsProblems Level 3 (Joins Deep Dive)Planned
- A & B Buyers Without CProblems Level 3 (Joins Deep Dive)Planned
- Product Selling Price ReportProblems Level 3 (Joins Deep Dive)Planned
- Updated Bank BalancesProblems Level 3 (Joins Deep Dive)Planned
- Most Frequent TravellersProblems Level 3 (Joins Deep Dive)Planned
- Suggested PagesProblems Level 3 (Joins Deep Dive)Planned
Subqueries25 topics
- Everything about SubqueriesMastering SubqueriesPlanned
- Introduction to Subqueries (IN)Conceptual Breakdown of Nested LogicPlanned
- EXISTS and NOT EXISTSConceptual Breakdown of Nested LogicPlanned
- Correlated SubqueriesConceptual Breakdown of Nested LogicPlanned
- Contest Participation RateProblems Level 1 (Everything about Subqueries)Planned
- High-Report ManagersProblems Level 1 (Everything about Subqueries)Planned
- All-Product BuyersProblems Level 1 (Everything about Subqueries)Planned
- Highest Non-Repeating NumberProblems Level 1 (Everything about Subqueries)Planned
- Find the First Device Logged In by Each PlayerProblems Level 1 (Everything about Subqueries)Planned
- Salespersons Without RED OrdersProblems Level 1 (Everything about Subqueries)Planned
- Employees with the Highest Salary in Each DepartmentProblems Level 2 (Everything about Subqueries)Planned
- Find the Most Recent Order for Each ProductProblems Level 2 (Everything about Subqueries)Planned
- Find Transactions with Maximum Amount Per DayProblems Level 2 (Everything about Subqueries)Planned
- Incomplete Employee RecordsProblems Level 2 (Everything about Subqueries)Planned
- Find Quiet Students in All ExamsProblems Level 2 (Everything about Subqueries)Planned
- Top Grade per StudentProblems Level 2 (Everything about Subqueries)Planned
- Swap Consecutive SeatsProblems Level 3 (Everything about Subqueries)Planned
- Safe Investment CountriesProblems Level 3 (Everything about Subqueries)Planned
- Tennis Grand Slam WinnersProblems Level 3 (Everything about Subqueries)Planned
- Football Team ScoresProblems Level 3 (Everything about Subqueries)Planned
- Order Count per CustomerProblems Level 3 (Everything about Subqueries)Planned
- Boolean Expression EvaluatorProblems Level 3 (Everything about Subqueries)Planned
- Immediate First Orders PercentageProblems Level 3 (Everything about Subqueries)Planned
- Find All Employees Reporting to the Head of the CompanyProblems Level 3 (Everything about Subqueries)Planned
- Orphan EmployeesProblems Level 3 (Everything about Subqueries)Planned
Data Modification and Schema Evolution10 topics
- Editing Data and TablesData ManipulationPlanned
- INSERTTable Alteration CommandsPlanned
- UPSERTTable Alteration CommandsPlanned
- UPDATETable Alteration CommandsPlanned
- DELETETable Alteration CommandsPlanned
- ALTERTable Alteration CommandsPlanned
- TRUNCATETable Alteration CommandsPlanned
- DELETE vs. TRUNCATE vs. DROPTable Alteration CommandsPlanned
- System SettingsProblems Level 1 (Editing Data and Tables)Planned
- Employee SalaryProblems Level 1 (Editing Data and Tables)Planned
Physical Storage, Indexing, and Hashing4 topics
- Storage Hierarchy, Pages, Records, and BuffersPlanned
- File OrganizationPlanned
- Index Classification and DesignPlanned
- B-Trees and B+ TreesPlanned
Data Storage, Keys, and Query Optimization5 topics
- Storage, Keys and Query PerformanceHow Storage and Keys Impact QueriesPlanned
- Where Rows Actually LiveBreakdown of Storage, Keys, and Query PerformancePlanned
- How a B+ Tree Is Built with DataBreakdown of Storage, Keys, and Query PerformancePlanned
- Why the Wrong Primary Key Can Quietly Destroy YouBreakdown of Storage, Keys, and Query PerformancePlanned
- Index Strategy at ScaleBreakdown of Storage, Keys, and Query PerformancePlanned
Query Processing and Optimization4 topics
- From SQL to an Executable PlanPlanned
- Algorithms for Selection, Projection, Sorting, and AggregationPlanned
- Join Processing AlgorithmsPlanned
- Cost-Based Query OptimizationPlanned
Query Performance5 topics
- Performance & DebuggingPerformance EngineeringPlanned
- Raw Data Setup and Stored ProceduresBreakdown of Performance & DebuggingPlanned
- Debugging Queries with EXPLAINBreakdown of Performance & DebuggingPlanned
- Query PerformanceBreakdown of Performance & DebuggingPlanned
- Debugging CorrectnessBreakdown of Performance & DebuggingPlanned
Transactions and Access Control11 topics
- Permissions and Transactions Part-1Access Control Part 1Planned
- Privileges and RolesBreakdown of Transactions and Access Part 1Planned
- GRANTSBreakdown of Transactions and Access Part 1Planned
- GRANT ALL and WITH GRANT OPTIONBreakdown of Transactions and Access Part 1Planned
- ALTER USERBreakdown of Transactions and Access Part 1Planned
- REVOKEBreakdown of Transactions and Access Part 1Planned
- Permissions and Transactions Part-2Access Control Part 2Planned
- Connection, Connection Pool and CommitBreakdown of Transactions and Access Part 2Planned
- RollbackBreakdown of Transactions and Access Part 2Planned
- SavepointBreakdown of Transactions and Access Part 2Planned
- Internal Working of Transactions, Timeout and DeadlockBreakdown of Transactions and Access Part 2Planned
Transactions and Concurrency Control7 topics
- Transaction Concepts, ACID, and StatesPlanned
- Schedules and Concurrency AnomaliesPlanned
- Conflict and View SerializabilityPlanned
- Lock-Based Protocols and Two-Phase LockingPlanned
- Deadlock HandlingPlanned
- Timestamp Ordering, Optimistic Control, and MVCCPlanned
- SQL Isolation LevelsPlanned
Database Recovery and Durability4 topics
- Failures, Storage, and Recovery GoalsPlanned
- Log-Based Recovery and Write-Ahead LoggingPlanned
- Checkpoints and ARIES IntuitionPlanned
- Shadow Paging, Backup, and Point-in-Time RecoveryPlanned
Integrity, Security, and Database Operations4 topics
- Declarative Integrity Beyond KeysPlanned
- Authorization, Views, and AuditingPlanned
- Database Security Threats and ProtectionPlanned
- Metadata, Statistics, Maintenance, and ObservabilityPlanned
Distributed Databases, NoSQL, and Analytical Systems6 topics
- Distributed Database FoundationsPlanned
- Partitioning, Sharding, and Distributed IDsPlanned
- Replication, Consistency, and CAP/PACELCPlanned
- Distributed Transactions and CoordinationPlanned
- NoSQL Data Models and SQL-vs-NoSQL DecisionsPlanned
- OLTP, OLAP, Warehousing, and Columnar StoragePlanned
Applied Learning and Preparation4 topics
- Schema-Design CapstonePlanned
- Storage and Query-Plan LabPlanned
- Concurrency and Recovery LabPlanned
- Interview Depth by Candidate LevelPlanned