Curriculum
Guided Course : SQL for Data Analysis
Introduction
0/2
Installation and getting started
0/2
Case Study : Demo
0/4
Fundamental SQL statements
0/19
-
CREATE
11:40 min -
Exercise 1: Create DB and Table
01:25 min
-
Quiz
5 questions -
Solutions to all Exercises
00:05 min -
INSERT
09:07 min
-
Import data from File
04:59 minPreview
-
Exercise 2: Inserting and Importing
00:58 min
-
Quiz
5 questions
-
SELECT statement
03:40 min
-
SELECT DISTINCT
06:05 min
-
WHERE
04:02 min
-
Logical Operators
06:03 min
-
Exercise 3: SELECT & WHERE
01:16 min
-
Quiz
5 questions
-
UPDATE
05:25 min
-
DELETE
04:12 min
-
ALTER
17:21 min
-
Exercise 4: Updating Table
01:04 min
-
Quiz
5 questions
Restore and Back-up
0/7
Selection commands: Filtering
0/5
Selection commands: Ordering
0/5
Alias
0/1
Aggregate Commands
0/7
Group By Commands
0/4
Conditional Statement
0/3
JOINS
0/18
-
Introduction to Joins
02:26 min
-
Concepts of Joining and Comb
11:59 min
-
Preparing the data
02:01 min
-
Quiz
5 questions
-
Inner Join
08:06 min
-
Exercise 10 : Inner join
15:00 min
-
Left Join
07:32 min
-
Right Join
06:27 min
-
Exercise 11: Joins
01:18 min
-
Full Outer Join
04:59 min
-
Exercise 12 : Outer Join
02:00 min
-
Cross Join
04:21 min
-
Quiz
5 questions
-
Intersect and Intersect ALL
07:07 min
-
Except
03:01 min
-
Union
03:13 min
-
Exercise 13
01:26 min
-
Quiz
5 questions
Fun way to practice SQL
0/1
Views and Indexes
0/6
String Functions
0/11
Mathematical Functions
0/8
Date-Time Functions
0/5
PATTERN (STRING) MATCHING
0/5
Window Functions
0/15
-
Introduction to Window function
09:57 min
-
Introduction to Row number
06:04 min
-
Implementing Row number in S
19:19 min
-
Quiz
5 questions
-
RANK and DENSERANK
07:19 min
-
NTILE function
07:20 min
-
Quiz
5 questions
-
AVERAGE function
08:22 min
-
COUNT
03:55 min
-
SUM TOTAL
11:14 min
-
Quiz
5 questions
-
RUNNING TOTAL
06:58 min
-
LAG and LEAD
08:17 min
-
Exercise : Window Functions
01:18 min
-
Quiz
5 questions
COALESCE function
0/1
Data Type conversion functions
0/3
User Access Control Functions
0/3
Nail that Interview!
0/7
Performance tuning tips
0/11
Final Section : Database Basics
0/5
Video lesson
Google