SQL & Administration
SQL Fundamentals, Advanced Queries & Data Administration
Build fluency in relational querying and day-to-day database administration through structured lab workshops.
SQL Fundamentals
Designed for beginners and analysts transitioning to direct database work: SELECT projections, WHERE predicates, INNER and LEFT JOINs, GROUP BY aggregations, and transaction-safe INSERT/UPDATE/DELETE statements.
Advanced Database Queries
Covers common table expressions (CTEs), window functions, correlated subqueries, views, stored procedures, and reading EXPLAIN output to understand index usage.
Data Administration Workshops
Hands-on labs focused on user account creation, host-based privilege scoping, logical backup generation, and verifying data restores in test environments.
