Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Understand business needs
·
Module 5
SQL for Data Interrogation
1
Filtering Data with WHERE Clauses
Write SELECT statements with WHERE clauses to query and filter data from single tables.
2
Ordering and Limiting Query Results
Sort and limit query results using ORDER BY and LIMIT.
3
Summarizing Data with Aggregate Functions and GROUP BY
Apply aggregate functions (COUNT, SUM, AVG) with GROUP BY to summarize data.
4
Filtering Grouped Data with HAVING
Filter grouped data using the HAVING clause.
5
INNER JOIN: Combining Data from Multiple Tables
Write queries using INNER JOIN to combine data from multiple tables.
6
LEFT JOIN for Matching Records
Use LEFT JOIN to retrieve all records from a primary table with matching secondary records.
7
SQL UNION and UNION ALL Operators
Combine query results using UNION and UNION ALL.
Previous module
Business Process and System Modeling
Next module
Advanced SQL for Business Analytics