Atlas Data Manipulation Using SQL
Your Instructor
Course Curriculum
Class Recordings
Available in
days
days
after you enroll
-
Start26-05-2022 S1: Introduction to SQL and CRUD Operations (80:38)
-
Start28-05-2022 CRUD Operations-2 (120:30)
-
Start30-05-2022 Relationships, Constraints and ER Diagram (73:21)
-
Start31-05-2022 DML and DDL Statements (74:02)
-
Start01-06-2022 Importing Data in MySQL (69:23)
-
Start02-06-2022 Importing Data using GUI and Data Cleaning Essentials (65:24)
-
Start03-06-2022 Cast and Replace Functions (61:59)
-
Start04-06-2022 Connecting to AWS, Select Statements (134:41)
-
Start06-06-2022 Order By Clause, Date-Time Function, Aliases (79:12)
-
Start07-06-2022 IN, NOT IN, Joins, Multiple Joins (64:12)
-
Start08-06-2022 Joins and Unions (66:31)
-
Start09-06-2022 Outer Join, Inner Joins, Use of Unions (83:02)
-
Start10-06-2022 Left Anti, Right Anti, Group By, Having Clause, Pattern Matching (83:23)
-
StartS1 01-09-2022 Recap of Basic SQL,Group By,Order By Clause (66:00)
-
StartS2 02-09-2022 Reference - Views & Common Table Expression Queries,Pattern Matching - School_db (76:26)
-
StartS3 03-09-2022 Case,When Function,If Function,Like,Not Like Function (112:58)
-
StartS4 05-09-2022 Date Functions,Joins,Like,Not like,Regular Expressions (66:27)
-
StartS5 06-09-2022 Box Office Case Study (53:15)
-
StartS6 07-09-2022 Regular Expressions,User Defined Variables,Floor and Ceil Functions (62:29)
-
StartS7 08-09-2022 Median Value,User Defined Variables,CTE,Windows Function (58:14)
-
StartS8 10-09-2022 Window Functions Contd. (91:42)
-
StartS9 12-09-2022 Window Functions Contd. (69:20)
-
StartS10 13-09-2022 Window Functions: Range Functions; Text Functions (59:33)
-
StartS11 14-09-2022 Text Functions- Locate, Like, Not Like, Exist, Not Exist (59:00)
-
StartS12 15-09-2022 Exists, Not Exists, Sub-Queries (62:49)
-
StartS13 16-09-2022 Co-related sub-queries (62:15)
-
StartS14 17-09-2022 Case Study-Zomato (91:54)
-
StartS15 19-09-2022 Zomato Case Study Discussion (70:22)
-
StartS16 20-09-2022 Stored Procedures (61:08)
-
StartS17 21-09-2022 Harry Potter Case Study Discussion, Doubt Clearing (51:55)
-
StartS18 23-09-2022 Google Big Query (67:44)
Assignments
Available in
days
days
after you enroll
-
Start26-05-2022 CRUD Operations
-
Start28-05-2022 Books Database
-
Start30-05-2022 Write SQL script to create Books Database ERD
-
Start01-06-22 Import Loans_Dataset CSV files as tables
-
Start02-Jun-2022 Import Credit_Card_Db data into MySQL using Import Wizard
-
Start03-Jun-2022 Import School_db data tables into MySQL
-
Start04-Jun-2022 Select Statement Intro Practice Queries on Loans Dataset
-
Start06 -Jun-22 Select Statements Intro Practice on School_database
-
Start07-Jun-2022 IN, Not In, Union Scripts - Working with Multiple Tables - Loans Dataset
-
Start07-Jun-2022 IN Practice Exercises on School_database
-
Start08-Jun-2022 Joins Exercises using School_db
-
Start09-Jun-2022 Case Study - In, Not In, Joins
-
Start10-Jun-2022 & 01 Sep 2022 Exercises on Group By Having Order By Limit - School_database
-
Start03-09-2022 Olacabs Case
-
Start03-Sep-2022 Like Not Like Pattern Matching Exercises (Use School_db)
-
Start05-Sep-2022 Regular Expressions Exercise (Use School_db)
-
Start08-Sep-2022 Window Functions - Exercises (Use School_db)
-
Start10-Sep-22 Case Study by Accenture
-
Start13-Sep-22 Text Functions - Exercises & Reference Scripts (School_db)
-
Start14-Sep-22 Exists / Not Exists - Basic Exercises & Reference Scripts (School_db)
-
Start15-Sep-22 Co-related Subquery - Exercises & Reference Scripts (School_db)
-
Start16-Sep-22 Harry Potter Case
-
Start17-Sep-22 Name Rank Case
-
Start17-Sep-22 Zomato Case
-
Start20-Sep-22 Stored Procedure Reference Scripts and Exercise
-
StartSolution - Accenture
-
Start21-Sep-22 - Steps to Import Data using Command Line Interface - (Non GUI Client)
Class Files & Materials
Available in
days
days
after you enroll
-
Start30-05-2022 SQL Intro Deck, DDL Scripts, Class running notes Excel file
-
Start31-05-22 DML Scripts
-
Start01-06-22 How to Import Data Files from External Source
-
Start02-Jun-2022 How to convert date stored as text to date types
-
Start08-Jun-2022 Reference Joins Scripts using Loans_Dataset
-
Start09-Jun-2022 Reference Union, Outer Join (Left, Right, Full) Scripts - Loans Dataset
-
Start10-Jun-2022 Reference Group By Having Queries on Credit_Card Database
-
Start02-Sep-2022 Reference - Views & Common Table Expression Queries - School_db
-
Start05-Sep-2022 Reference - Like, Not Like, Regular Expressions - Pattern Matching using School_db
-
Start06-09-2022 Box Office Case Study
-
Start07-09-22 User Defined Variable Reference Scripts
-
Start10-09-22 Window Functions - Complete Reference Scripts
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.