SQL Select Statements

Description

SELECT is the core of SQL, and seven PDF lessons are devoted to it. The first explains the basics, and the next shows how to filter data with the WHERE clause and sort results with ORDER BY.

You then learn to work with multiple columns and aliases, use DISTINCT for unique results, do basic calculations and expressions and combine multiple conditions. After reading, you will be able to write queries that retrieve exactly the rows and columns you need. Exercises and tables appear in every lesson. Each lesson adds one clause or feature to the basic query, so the examples grow in small steps.

Who it is for: absolute beginners who want to start querying databases with SQL.

What’s included
7 PDF lessons · 48 pages · about 12,500 words
One ZIP download that is yours to keep — read on any device, no subscription or app needed.

Course programme

1. Understanding the SELECT Statement Basics
2. Filtering Data with WHERE Clause
3. Sorting Results with ORDER BY
4. Working with Multiple Columns and Aliases
5. Using DISTINCT for Unique Results
6. Basic Calculations and Expressions
7. Combining Multiple Conditions