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)
Pricing calculator
Choose materials, tutoring, or both — or book a single session as needed. Customize your plan on the subscribe page.
Billed in 15-minute increments (15-minute minimum, up to 4 hours). No subscription required.
$60.00 · 60 min · Undergraduate · Online ($60/hr)
Book through intake or schedule a session.