Standard syllabus
Databases · Undergraduate · CS / Programming
Topics
Relational foundations
- Relational model: relations, tuples, keys, and constraints
- SQL DDL: CREATE TABLE, keys, foreign keys, CHECK
- SQL DML: SELECT, INSERT, UPDATE, DELETE
- Joins: inner, outer, cross; join algorithms (intro)
- Aggregation, GROUP BY, HAVING, and subqueries
Design and integrity
- Entity–relationship modeling and ER-to-relational mapping
- Functional dependencies and normalization (1NF–BCNF)
- Transactions: ACID properties and isolation levels (intro)
- Indexes: B-trees and query planning (intro)
- Views, triggers, and stored procedures (survey)
Systems internals survey
- Storage engines and page layouts (intro)
- Buffer pools and write-ahead logging intuition
- Concurrency control: locks vs MVCC (intro)
- Crash recovery and checkpoints (survey)
- Distributed databases and CAP tradeoffs (intro)
- Choosing indexes for realistic workloads
Pricing calculator
Choose materials, tutoring, or both — or book a single session as needed. Customize your plan on the subscribe page.
$1,162 · Databases · 18 tutoring hrs
Study guides, worksheets, reviews, practice tests, and answer keys for 1 class. 18 tutoring hours (1 hr / week · semester). Bundle discount applied vs buying separately. Pay in full via Zelle.