Ratings & reviews

4.8637 ratings

Ariana S.

4 days ago

Great quality, easy to follow, and good amount of repetition to ensure retention

Louis M.

5 days ago

Would like to see some more advanced courses. Intermediate is not very intermediate

David D.

5 days ago

It gives small visual rewards just like a freemium game on my phone. This really helps me learn and stay focused - even with severe ADHD

85%
11%
4%
1%
0%
info

Complete all chapters to get certificate

0%

Retrieving Data

chevron

In this section, we will learn how to use the SQL SELECT statement to get a single table column, multiple table columns, and all table columns. We will also find out how to return unique values.

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Retrieving Distinct Rows

Limiting Results

Challenge: Find the Population of the Countries

Challenge: Find All Countries

Challenge: Find All Countries With Their IDs

Challenge: Find Country Capitals

Challenge: Find the Regions in Which All Countries Are Located

Sorting Retrieved Data

chevron

In this section, we will learn how to sort retrieved data using the ORDER BY clause. This clause, which must be the last in the SELECT statement, can be used to sort data on one or more columns as needed.\n

Sorting Data

Challenge

Sorting by Multiple Columns

Challenge

Specifying Sort Direction

Challenge: Sort the Countries by Region and Capital

Challenge: Sort Capitals in Descending Order

Challenge: Sort Countries in Ascending Order

Challenge: Find Countries, Their IDs, and Their Populations

Challenge: Find Countries, IDs, Populations, Regions, and Sort Them

Challenge: Find All Continents and Sort Them in Ascending Order

Filtering Data

chevron

In this section, we will learn how to filter returned data using the SELECT statement’s WHERE clause. We will learn how to test for equality, inequality, more and less significant than value ranges, and NULL values.

Using the WHERE Clause

Challenge

The WHERE Clause Operators

Challenge

Checking for a Range of Values

Checking for NO Value

Advanced Data Filtering

chevron

In this section, we will learn how to combine WHERE clauses with the AND and OR operators. We will also find out how the NOT operator works.\n\n\n

Using the AND Operator

Challenge

Using the OR operator

Challenge

Using the NOT Operator

Challenge

Aggregate Functions

chevron

In this section, we will learn what the SQL aggregate functions are and how to use them to summarize table data.

The AVG() Function

Challenge

The COUNT() Function

Challenge

The MAX() Function

The MIN() Function

Challenge

The SUM() Function