SQL for Everyone: From Basics to Advanced Queries

Categories: Databases
Wishlist Share

About Course

Write SQL confidently: queries, joins, aggregations, window functions and performance basics.

Who this training is for

  • Analysts, testers and developers
  • Business users working with data

Syllabus

  1. Module 1: Basics — SELECT, WHERE, ORDER BY
  2. Module 2: Joins — Inner, outer, self joins
  3. Module 3: Aggregation — GROUP BY, HAVING
  4. Module 4: Advanced — Subqueries, CTEs, window functions
  5. Module 5: Performance — Indexes, explain plans

🏢 Training your team?

This course is available as live online batches, onsite workshops at your office, or self-paced access for your employees with progress reports for HR. The syllabus can be tailored to your systems and projects.

🎁 Book a free demo for your team Corporate plans

Show More

What Will You Learn?

  • Write SELECT queries with filters and joins
  • Aggregate and group data
  • Use subqueries and window functions
  • Understand indexes and query plans

Course Content

Module 1: Basics
SELECT, WHERE, ORDER BY

Module 2: Joins
Inner, outer, self joins

Module 3: Aggregation
GROUP BY, HAVING

Module 4: Advanced
Subqueries, CTEs, window functions

Module 5: Performance
Indexes, explain plans

Student Ratings & Reviews

No Review Yet
No Review Yet
Scroll to Top