SQL Reporting Queries
Write SQL reports with grouping, date ranges, CASE and window functions.
What you'll learn
- Group data by date periods
- Use CASE for categories
- Rank and total with window functions
About this course
In two weeks you answer business questions with SQL. You build monthly reports, rankings and running totals on a sample sales database.
Course curriculum
3 modules and 9 lessons over 2 weeks. Plan for about 6 learning hours.
01GroupingWeek 1 · 3 lessons
- Date truncation
- GROUP BY periods
- HAVING
02CategoriesWeek 1 · 3 lessons
- CASE
- Pivot-style reports
- NULL handling
03Window functionsWeek 2 · 3 lessons
- ROW_NUMBER and RANK
- Running totals
- Report set
Project
Sales reports. Eight SQL reports on a sample sales database, from monthly totals to rankings.
Who this course is for
Developers who need to pull reports from a database.
Prerequisites
You write SELECT, WHERE and GROUP BY queries.
What's included
- 90-day course access
- Guided lessons
- Coding exercises
- Starter files
- Solution examples
- A digital completion certificate
Learning format
Self-paced mini-course, part of our self-paced courses. Guided lessons, exercises and student support.
Access and delivery
- Digital access is activated within 15 minutes after successful payment.
- Student support replies are targeted within 2 business days.
- The completion certificate is issued within 2 business days after the final exercise is submitted.
Certificate
You receive a digital completion certificate. The completion certificate is issued within 2 business days after the final exercise is submitted.
Frequently asked questions
When does access start?
Digital access is activated within 15 minutes after successful payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for self-paced mini-course programs.
