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
60 min total
19 Lessons
0 Completed
Module Content
WHERE CLAUSE
Understand `WHERE` Clause Basic Filtering and Logical Operators.
13 minVideo
Start
THE IN OPERATOR
A quick-reference reading on using IN and NOT IN to match a column against a list of values.
5 minArticle
Start
QUIZ: WHERE CLAUSE
WHERE CLAUSE and LOGICAL OPERATORS
15 minTutorial
Start
CODING: WHERE CLAUSE - 1
10 minAssignment
Start
CODING: WHERE CLAUSE - 2
10 minAssignment
Start
CODING: WHERE CLAUSE - 3
10 minAssignment
Start
CASE WHEN
Understand `CASE WHEN` for data manipulation
9 minVideo
Start
QUIZ: CASE WHEN
CASE WHEN
15 minTutorial
Start
CODING: CASE WHEN
10 minAssignment
Start
STRING FUNCTIONS
Understand `STRING` manipulation functions
12 minVideo
Start
QUIZ: STRING FUNCTIONS
STRING FUNCTIONS
15 minTutorial
Start
CODING: STRING FUNCTIONS
10 minAssignment
Start
DATE FUNCTIONS
Understand different `DATE` manipulation functions
5 minVideo
Start
QUIZ: DATE FUNCTIONS
DATE FUNCTIONS
15 minTutorial
Start
CODING: DATE FUNCTIONS
15 minAssignment
Start
SELECT DISTINCT
Understand `DISTINCT` Clause
2 minVideo
Start
QUIZ: MODULE 2
WHERE, SELECT, CASE WHEN, STRING and DATE FUNCTIONS
20 minTutorial
Start
CODING: MODULE 2 - 1
15 minAssignment
Start
CODING: MODULE 2 - 2
15 minAssignment
Start