SQL Basics: Querying Relational Databases
Master the fundamentals of SQL by learning how to extract and manipulate data from a relational database. This beginner-friendly course focuses on writing single-table queries using SELECT, FROM, WHERE, and ORDER BY.
Retrieving Data with SELECT and FROM Identify the basic structure and syntax of an SQL SELECT statement. Write SQL queries to retrieve specific columns from a database table. Use the asterisk (*) wildcard to retrieve all columns from a table. Filtering Data with the WHERE Clause Understand the purpose of the WHERE clause for row-level filtering. Filter data based on numeric conditions (e.g., greater than, less than). Filter data based on exact text matches. Expanding Filters with AND and OR Combine multiple filtering conditions using the AND operator. Expand filtering conditions using the OR operator. Exclude specific rows using inequality symbols (!= or <>). Sorting Results with ORDER BY Sort query results in ascending order using the ORDER BY clause. Sort query results in descending order using the DESC keyword. Apply sorting to both numeric and text columns.