Databases
Undergraduate · CS / Programming
Syllabus focus
Standard syllabus · STEM / applied
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.
Topics typically covered
Standard syllabus
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)
STEM / applied
Application integration
- Connecting applications to databases (ODBC/JDBC/ORM intro)
- Designing schemas for web and mobile backends
- Migration scripts and schema evolution
- Backup, restore, and replication basics
- NoSQL overview: document, key-value, column stores
Performance and analytics
- Query optimization and EXPLAIN plans
- Denormalization tradeoffs for read-heavy workloads
- ETL pipelines into a warehouse (intro)
- Connection pooling and transaction boundaries in apps
- Security: SQL injection prevention and least privilege
Notes
SQL depth varies; some courses emphasize theory, others project-based web backends.