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.
Job-ready SQL and database skills
·
Module 2
The Relational Model and SQL Fundamentals
1
Understanding the Relational Model: Tables, Rows, and Columns
Explain how the relational model organizes data into tables, rows, and columns.
2
Retrieving Specific Columns with SELECT
Write `SELECT` statements to retrieve specific columns from a single table.
3
Filtering Data with WHERE and Comparison Operators
Filter rows using the `WHERE` clause with comparison operators (`=`, `!=`, `>`, `<`).
4
Combining Conditions with AND and OR
Combine multiple conditions in a `WHERE` clause using `AND` and `OR` operators.
5
Filtering Data with IN, BETWEEN, and LIKE
Filter data using `IN`, `BETWEEN`, and the `LIKE` operator for pattern matching.
6
NULL Value Handling with IS NULL and IS NOT NULL
Handle `NULL` values in queries using `IS NULL` and `IS NOT NULL`.
7
Sorting Query Results with ORDER BY
Sort query results using `ORDER BY` on single or multiple columns.
8
Paginating Query Results with LIMIT and OFFSET
Use `LIMIT` and `OFFSET` to paginate query results.
Previous module
Database Fundamentals and Architecture
Next module
Joining Multiple Tables