SQL and Relational Databases topics
10 short topics in SQL and Relational Databases. Each one is a single focused exercise with a clear piece of evidence at the end.
10 topics, one exercise each.
Work through them in order, or jump to the one you need.
These are draft topic outlines (draft; instructor review pending). Full lessons follow after review; ask Ajay if you need a topic sooner.
- 01
Entities and relationships
Implement a focused example of Entities and relationships within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 02
Normalization and denormalization
Implement a focused example of Normalization and denormalization within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 03
SQL joins
Implement a focused example of SQL joins within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 04
Aggregation and window functions
Implement a focused example of Aggregation and window functions within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 05
Database indexes
Implement a focused example of Database indexes within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 06
Query execution plans
Implement a focused example of Query execution plans within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 07
ACID transactions
Implement a focused example of ACID transactions within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 08
Isolation levels and locking
Implement a focused example of Isolation levels and locking within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 09
Schema migrations
Implement a focused example of Schema migrations within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course → - 10
Backup and restore validation
Implement a focused example of Backup and restore validation within a small part of Transactional order and inventory database; demonstrate a normal and an edge or failure case.
Open micro-course →
More in Core IT concepts.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.