STEM / applied
Databases · Undergraduate · CS / Programming
Topics
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
Product and data engineering
- Modeling multi-tenant schemas safely
- Online schema changes and zero-downtime migrations
- Caching layers and cache invalidation patterns
- Read replicas and eventual consistency effects on apps
- Observing slow queries in production
- Capstone: schema + API for a CRUD domain with constraints
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.