Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Atlas Data Manipulation Using SQL
Class Recordings
26-05-2022 S1: Introduction to SQL and CRUD Operations (80:38)
28-05-2022 CRUD Operations-2 (120:30)
30-05-2022 Relationships, Constraints and ER Diagram (73:21)
31-05-2022 DML and DDL Statements (74:02)
01-06-2022 Importing Data in MySQL (69:23)
02-06-2022 Importing Data using GUI and Data Cleaning Essentials (65:24)
03-06-2022 Cast and Replace Functions (61:59)
04-06-2022 Connecting to AWS, Select Statements (134:41)
06-06-2022 Order By Clause, Date-Time Function, Aliases (79:12)
07-06-2022 IN, NOT IN, Joins, Multiple Joins (64:12)
08-06-2022 Joins and Unions (66:31)
09-06-2022 Outer Join, Inner Joins, Use of Unions (83:02)
10-06-2022 Left Anti, Right Anti, Group By, Having Clause, Pattern Matching (83:23)
S1 01-09-2022 Recap of Basic SQL,Group By,Order By Clause (66:00)
S2 02-09-2022 Reference - Views & Common Table Expression Queries,Pattern Matching - School_db (76:26)
S3 03-09-2022 Case,When Function,If Function,Like,Not Like Function (112:58)
S4 05-09-2022 Date Functions,Joins,Like,Not like,Regular Expressions (66:27)
S5 06-09-2022 Box Office Case Study (53:15)
S6 07-09-2022 Regular Expressions,User Defined Variables,Floor and Ceil Functions (62:29)
S7 08-09-2022 Median Value,User Defined Variables,CTE,Windows Function (58:14)
S8 10-09-2022 Window Functions Contd. (91:42)
S9 12-09-2022 Window Functions Contd. (69:20)
S10 13-09-2022 Window Functions: Range Functions; Text Functions (59:33)
S11 14-09-2022 Text Functions- Locate, Like, Not Like, Exist, Not Exist (59:00)
S12 15-09-2022 Exists, Not Exists, Sub-Queries (62:49)
S13 16-09-2022 Co-related sub-queries (62:15)
S14 17-09-2022 Case Study-Zomato (91:54)
S15 19-09-2022 Zomato Case Study Discussion (70:22)
S16 20-09-2022 Stored Procedures (61:08)
S17 21-09-2022 Harry Potter Case Study Discussion, Doubt Clearing (51:55)
S18 23-09-2022 Google Big Query (67:44)
Assignments
26-05-2022 CRUD Operations
28-05-2022 Books Database
30-05-2022 Write SQL script to create Books Database ERD
01-06-22 Import Loans_Dataset CSV files as tables
02-Jun-2022 Import Credit_Card_Db data into MySQL using Import Wizard
03-Jun-2022 Import School_db data tables into MySQL
04-Jun-2022 Select Statement Intro Practice Queries on Loans Dataset
06 -Jun-22 Select Statements Intro Practice on School_database
07-Jun-2022 IN, Not In, Union Scripts - Working with Multiple Tables - Loans Dataset
07-Jun-2022 IN Practice Exercises on School_database
08-Jun-2022 Joins Exercises using School_db
09-Jun-2022 Case Study - In, Not In, Joins
10-Jun-2022 & 01 Sep 2022 Exercises on Group By Having Order By Limit - School_database
03-09-2022 Olacabs Case
03-Sep-2022 Like Not Like Pattern Matching Exercises (Use School_db)
05-Sep-2022 Regular Expressions Exercise (Use School_db)
08-Sep-2022 Window Functions - Exercises (Use School_db)
10-Sep-22 Case Study by Accenture
13-Sep-22 Text Functions - Exercises & Reference Scripts (School_db)
14-Sep-22 Exists / Not Exists - Basic Exercises & Reference Scripts (School_db)
15-Sep-22 Co-related Subquery - Exercises & Reference Scripts (School_db)
16-Sep-22 Harry Potter Case
17-Sep-22 Name Rank Case
17-Sep-22 Zomato Case
20-Sep-22 Stored Procedure Reference Scripts and Exercise
Solution - Accenture
21-Sep-22 - Steps to Import Data using Command Line Interface - (Non GUI Client)
Class Files & Materials
30-05-2022 SQL Intro Deck, DDL Scripts, Class running notes Excel file
31-05-22 DML Scripts
01-06-22 How to Import Data Files from External Source
02-Jun-2022 How to convert date stored as text to date types
08-Jun-2022 Reference Joins Scripts using Loans_Dataset
09-Jun-2022 Reference Union, Outer Join (Left, Right, Full) Scripts - Loans Dataset
10-Jun-2022 Reference Group By Having Queries on Credit_Card Database
02-Sep-2022 Reference - Views & Common Table Expression Queries - School_db
05-Sep-2022 Reference - Like, Not Like, Regular Expressions - Pattern Matching using School_db
06-09-2022 Box Office Case Study
07-09-22 User Defined Variable Reference Scripts
10-09-22 Window Functions - Complete Reference Scripts
Assessments
Assessment 1-09-06-2022
Re-Assessment 1- 10-06-2022
Final Assessment 11-06-2022
Final Re-Assessment 18-06-2022
Assessment 10-09-2022
Solution to Assessment held on 10-09-2022
Assessment 17-09-2022
Re-Assessment 18-09-2022
Solution to Assessment held on 17-09-2022
Solution to Assessment held on 18-09-2022
Assessment 24-09-2022
SQL Final Assessment 30-09-2022
09-Jun-2022 Reference Union, Outer Join (Left, Right, Full) Scripts - Loans Dataset
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock