Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analytics using SQL
1. SQL reference materials
Important readings and notes
2. Database Designing Fundamentals
Introduction to SQL - Video (95:56)
SQL Introduction - Notes
Database Designing - Video (112:05)
Database Designing Basics - Notes
Assignment : Cakes and Fudges & Music School
Quiz
3. DDL (Data Defining Language) Statements
SQL DDL Statement Introduction
DDL Statement queries
Books Database (Class Example)
Create and Alter - the Books Database
Quiz
4. SQL basics - WHERE clause, DATE() function, Aggregate functions
Class examples (MS Access)
Converting DOB COLUMN into DATE, TIME datatype column
Assignment: SQL SELECT Exercises
Assignment: Basic Questions
Quiz
5. IN, BETWEEN & LIKE queries
DISTINCT, IN, BETWEEN, NOT IN queries
In, Between and Like - Video (85:12)
Assignment: IN, NOT IN, Between, Not Between Like, Not Like queries
Quiz
6. GROUP BY, ORDER BY, RANK, TOP queries
Order by, Group By, Rank, Top Function - Video (108:33)
Assignment: GROUP BY, ORDER BY queries
Quiz
7. Conditional Statements in SQL
If, Case WHEN Statement - Video (106:41)
Quiz
8. Text Function, UNION and EXIST queries
Text Functions - Video
UNION, EXISTS, NOT EXISTS - Video (101:14)
Class Scripts
Assignment: Text, Union, Exists, Not Exists queries
Quiz
9. SQL JOINS, Views and co-related subqueries
SQL JOINS - Video (69:26)
Views, Co-related subqueries, Renaming a column - Video (91:34)
Assignment: SQL JOINS
Assignment : Correlated Subquery
Quiz
10. SQL Exercises and Case Studies
SQL Case Study - 1
SQL Case Study 2
Case Study : Accenture Written SQL Case
Case Study : Taxi for sure
Case Study : Harry Potter
Case Study : Swiggy
Case Study : Accenture Written SQL Case
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock