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.
Learn SQL
·
Module 1
Module 1: Retrieving and Filtering Data
1
Retrieving Specific Columns with SELECT
Write SELECT statements to retrieve specific columns from a users table
2
Filtering Data with Comparison Operators
Filter rows using WHERE clauses with comparison operators (=, >, <, >=, <=, !=)
3
Advanced User Segmentation with Boolean Logic
Segment users by combining criteria (e.g., active status and subscription plan) using AND, OR, and NOT operators
4
Filtering with IN and NOT IN
Filter for specific cohorts or features using IN and NOT IN operators
Filtering Text with LIKE and Wildcards
Filter text-based product data (e.g., user emails, event names) using pattern matching with LIKE and wildcards
6
Filtering Missing Data with IS NULL
Handle missing data by filtering with IS NULL and IS NOT NULL
Next module isn't ready yet,
Back to course
Previous module
Next module