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
Pricing
Graduate-level rates are set on consultation. See the pricing page for K–12 and undergraduate rates.