STEM / applied
SQL · Graduate · CS / Programming
Topics
Analytics and reporting
- Pivoting and conditional aggregation for dashboards
- Date/time handling and fiscal period reporting
- Cohort and funnel queries for product analytics
- Exporting results for Excel, R, or Python pipelines
- Performance tuning: indexes and selective filters
Platform specifics
- PostgreSQL vs MySQL vs SQL Server dialect differences
- Stored procedures and parameterized queries
- Role-based access and row-level security (intro)
- Integrating SQL with BI tools (Tableau, Power BI intro)
- Data quality checks with constraint queries
Analytics engineering
- Dimensional modeling intro (facts/dimensions)
- dbt-style transformation layers (survey)
- Data contracts between producers and consumers
- Scheduling SQL jobs and idempotent loads
- Explaining plans to non-DBA teammates
- Capstone: analytics mart with documented assumptions
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.