Standard syllabus
SQL · Undergraduate · CS / Programming
Topics
Query fundamentals
- SELECT projections, filtering with WHERE, and sorting
- Arithmetic and string functions in SQL
- Inner and outer joins; self-joins
- Set operations: UNION, INTERSECT, EXCEPT
- Subqueries: scalar, correlated, and EXISTS
Modification and schema
- INSERT, UPDATE, DELETE with conditions
- CREATE and ALTER TABLE; constraints and defaults
- Primary keys, foreign keys, and referential actions
- Views and common table expressions (CTEs)
- Window functions: ROW_NUMBER, RANK, LAG/LEAD (intro)
Advanced querying
- Complex joins and anti-join patterns
- Window frames and running calculations
- Recursive CTEs for hierarchies
- Transactions and isolation anomalies (intro)
- Constraints as data quality rules
- Query readability and style conventions
Pricing calculator
Choose materials, tutoring, or both — or book a single session as needed. Customize your plan on the subscribe page.
$1,162 · SQL · 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.