Oracle Database topics
12 short topics in SQL and Relational Databases. Each one is a single focused exercise with a clear piece of evidence at the end.
12 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
Schema objects and data types
Demonstrate schema objects and data types in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 02
Keys constraints and referential integrity
Demonstrate keys constraints and referential integrity in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 03
Query planning and execution
Demonstrate query planning and execution in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 04
Index selection and maintenance
Demonstrate index selection and maintenance in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 05
Transaction boundaries
Demonstrate transaction boundaries in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 06
Locking and isolation behavior
Demonstrate locking and isolation behavior in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 07
Connection and workload management
Demonstrate connection and workload management in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 08
Migration and compatibility strategy
Demonstrate migration and compatibility strategy in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 09
Backup and restore workflows
Demonstrate backup and restore workflows in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 10
Access control and credentials
Demonstrate access control and credentials in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 11
Replication or availability design choices
Demonstrate replication or availability design choices in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 12
Database diagnostics and capacity planning
Demonstrate database diagnostics and capacity planning in a focused Oracle Database example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course →
Learn the same ideas beyond Oracle Database.
These courses share topics with this one, so you can compare how each language or tool handles the same concept.
More in Relational databases.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.