Lesson 1

#### Filtering Numerical Data

Filter numerical records using operators.

Start Now

Lesson 2

#### Filtering String-Text Data

Learn how to filter for string-text records.

Start Now

Lesson 3

#### Dividing with Integer, Decimal and Float

Learn how to divide integers correctly in SQL.

Start Now

Lesson 4

#### Aggregate Functions

Learn commonly used aggregate functions such as COUNT(), SUM(), AVG(), MIN() and MAX().

Start Now

Lesson 20

#### Filtering with LIKE and Pattern Matching

Use LIKE and NOT LIKE to filter records with wildcards.

Start Now

Lesson 21

#### Manipulating with CASE

Shape, transform, and manipulate data using the CASE statement.

Start Now

Lesson 22

#### Transforming with String-Text Functions

Use string-text functions to transform and clean data.

Start Now

Lesson 23

#### [Drafting] Handle NULL Values

Use IFNULL(), ISNULL() and COALESCE() to tackle NULL values.

Start Now