Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Genpact - SQL Queries & Relational Database - Advanced Analytics - Oct 2021
Final Assessment - 8 Nov 2021
Final Case Study
Assignments
Assignment - 11 Oct 2021
Assignment - 13 Oct 2021
Reference Materials
SQL Session 1 - 11-Oct-2021
SQL Session 3 - 13-Oct-2021
SQL Session 4 - 14-Oct-2021
Case Study
Loans Case Study
Bank Credit Card Profiling Case Study
Facility Services Case Study
Solution - Facility Services Case
OLA Case Study
Solution - Ola Case
Exam Results Analysis Case Study by Accenture
Solution - Exam Results Analysis Case by Accenture
Harry Potter Case Study
Solution Harry Potter Case
Bank Customer Churn Modelling Case Study
1. SQL reference materials
Important readings and notes
2. Database Designing Fundamentals
SQL Introduction - Notes
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
Quiz
Assignment: IN, NOT IN, Between, Not Between Like, Not Like queries
6. GROUP BY, ORDER BY, RANK, TOP queries
Assignment: GROUP BY, ORDER BY queries
Quiz
7. Conditional Statements in SQL
Quiz
8. Text Function, UNION and EXIST queries
Class Scripts
Assignment: Text, Union, Exists, Not Exists queries
Quiz
9. SQL JOINS, Views and co-related subqueries
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
Create and Alter - the Books Database
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock