SQL: Data Reporting and Analysis

2h 36mIntermediate2025-06-20

Authors

Emma Saunders

Data Consultant specializing in data visualization on the web

Course details

Do you rely on IT to get the data you need? Are you often stuck waiting in line for data, and wish you could just retrieve it yourself? In this course, learn how to get the data you want by writing a bit of SQL code. You won't just be able to pull data out of the database, you'll be able to manipulate it—merging it, grouping it, and relabeling it to get just the report you want. Join Emma Saunders as she shows how to write simple SQL queries for data reporting and analysis using a publicly accessible online database. Learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, she introduces views, procedures, functions, and variables.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentDeep Dive (X:Y)

Concepts

0. Introduction

01 - Don't let your reporting system hold you back
02 - Who this course is for
03 - What is SQL

1. Prepare to Code in SQL

04 - Get familiar with phpMyAdmin
05 - Understand the demo database
06 - Using ChatGPT to check SQL code

2. Use SQL to Report Data

07 - Retrieve data with SELECT
08 - Filter results with the WHERE clause
09 - Use LIKE, IN, and wildcards with WHERE
10 - Sort SQL results with ORDER BY
11 - Use string functions on your data
12 - More advanced string functions
13 - Change report headings with an alias
14 - Use date functions with WHERE
15 - Challenge - Query a table
16 - Solution - Query a table
17 - Challenge - Convert case
18 - Solution - Convert case

3. Group Your SQL Results

19 - Use GROUP BY with count
20 - Filter grouped results with HAVING
21 - Deduplicate with SELECT DISTINCT
22 - Merge rows with GROUP BY
23 - Challenge - Cost analysis
24 - Solution - Cost analysis

4. Merge Data from Multiple Tables

25 - Make your queries faster
26 - Understand SQL indexes and keys
27 - EDIT - Visualize your database
28 - Merge data across tables with JOIN
29 - Understand SQL JOINS
30 - Combine rows with SQL UNION
31 - Merge data across tables with IN
32 - Select from a selection with subqueries
33 - Challenge - Join tables
34 - Solution - Join tables

5. More Advanced SQL

35 - Save your queries using a VIEW
36 - Use variables
37 - Use functions
38 - Use procedures

Continuing Your SQL Learning Journey

39 - Next steps and additional resources