Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL for Data Analytics
Introduction
Course Overview (4:38)
Course Resources
Installation and getting started
Installation (6:24)
Case Study : Demo
Case Study Part 1 (4:27)
Case Study Part 2 (6:17)
Fundamental SQL statements
CREATE (11:46)
Exercise 1: Create DB and Table (1:24)
Solutions to all Exercises
INSERT (9:07)
Import data from File (4:59)
Exercise 2: Inserting and Importing (0:57)
SELECT statement (3:45)
SELECT DISTINCT (6:05)
WHERE (4:02)
Logical Operators (6:10)
Exercise 3: SELECT & WHERE (1:16)
UPDATE (5:25)
DELETE (4:11)
ALTER (17:21)
Exercise 4: Updating Table (1:03)
Restore and Back-up
Exercise 5: Restore and Back-up (0:51)
Restore and Back-up (7:38)
Selection commands: Filtering
IN (4:24)
BETWEEN (5:40)
LIKE (8:52)
Exercise 6: In, Like & Between (0:51)
Selection commands: Ordering
Side Lecture: Commenting in SQL (1:20)
ORDER BY (7:42)
LIMIT (3:38)
Exercise 7: Sorting (0:47)
Alias
AS (3:33)
Aggregate Commands
SUM (3:24)
COUNT (5:13)
AVERAGE (2:53)
MIN & MAX (4:17)
Exercise 8: Aggregate functions (1:19)
Group By Commands
GROUP BY (11:52)
Exercise 9: Group By (1:13)
HAVING (5:04)
Conditional Statement
CASE WHEN (5:18)
JOINS
Introduction to Joins (2:25)
Inner Join (8:05)
Left Join (7:32)
Right Join (6:27)
Full Outer Join (4:59)
Cross Join (4:21)
Except (3:00)
Union (3:13)
Exercise 10: Joins (1:18)
Subqueries
Subqueries (14:35)
Exercise 11: Subqueries (1:21)
Views and Indexes
VIEWS (7:21)
INDEX (6:39)
Exercise 12: Views (0:47)
String Functions
LENGTH (3:31)
UPPER LOWER (2:10)
REPLACE (4:13)
TRIM, LTRIM, RTRIM (6:56)
CONCATENATION (2:56)
SUBSTRING (6:01)
LIST AGGREGATION (5:01)
Exercise 13: String Functions (2:27)
Mathematical Functions
CEIL & FLOOR (3:34)
RANDOM (5:06)
SETSEED (4:11)
ROUND (2:27)
POWER (2:25)
Exercise 14: Mathematical Functions (1:33)
Date-Time Functions
CURRENT DATE & TIME (4:31)
AGE (3:50)
EXTRACT (8:17)
Exercise 15: Date-time functions (1:23)
PATTERN (STRING) MATCHING
PATTERN MATCHING BASICS (7:44)
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) (15:21)
Exercise 16: Pattern Matching (1:42)
Data Type conversion functions
Converting Numbers/ Date to String (10:52)
Converting String to Numbers/ Date (5:53)
User Access Control Functions
User Access Control (13:41)
Bonus Section: Nail that Interview!
Tablespace (5:44)
PRIMARY KEY & FOREIGN KEY (5:09)
ACID compliance (5:57)
Truncate (3:54)
Performance tuning tips
TIP 1 (EXPLAIN) (11:26)
Tip 2 (1:17)
Tip 3 (2:32)
Tip 4 (0:34)
Tip 5 (1:59)
Tip 6 (2:20)
Tip 7 (1:57)
Tip 8 (4:51)
Bonus Section : Database Basics
What is SQL (1:56)
Tables and DBMS (3:10)
Types of SQL commands (4:44)
PostgreSQL (2:30)
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock