Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
2
DATA RETRIEVAL & FILTERING
SELECT in detail, WHERE with AND/OR/IN/BETWEEN/LIKE, DATE and STRING functions
Module Progress0% Complete
149 min total
19 Lessons
0 Completed
Module Content
WHERE CLAUSE
Understand `WHERE` Clause Basic Filtering and Logical Operators.
12 minVideo
Start
THE IN OPERATOR
A quick-reference reading on using IN and NOT IN to match a column against a list of values.
7 minArticle
Start
QUIZ: WHERE CLAUSE
WHERE CLAUSE and LOGICAL OPERATORS
13 minTutorial
Start
CODING: WHERE CLAUSE - 1
5 minAssignment
Start
CODING: WHERE CLAUSE - 2
5 minAssignment
Start
CODING: WHERE CLAUSE - 3
5 minAssignment
Start
CASE WHEN
Understand `CASE WHEN` for data manipulation
9 minVideo
Start
QUIZ: CASE WHEN
CASE WHEN
11 minTutorial
Start
CODING: CASE WHEN
6 minAssignment
Start
STRING FUNCTIONS
Understand `STRING` manipulation functions
12 minVideo
Start
QUIZ: STRING FUNCTIONS
STRING FUNCTIONS
12 minTutorial
Start
CODING: STRING FUNCTIONS
5 minAssignment
Start
DATE FUNCTIONS
Understand different `DATE` manipulation functions
4 minVideo
Start
QUIZ: DATE FUNCTIONS
DATE FUNCTIONS
10 minTutorial
Start
CODING: DATE FUNCTIONS
6 minAssignment
Start
SELECT DISTINCT
Understand `DISTINCT` Clause
2 minVideo
Start
QUIZ: MODULE 2
WHERE, SELECT, CASE WHEN, STRING and DATE FUNCTIONS
12 minTutorial
Start
CODING: MODULE 2 - 1
6 minAssignment
Start
CODING: MODULE 2 - 2
7 minAssignment
Start