Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Genpact - SQL Queries & Relational Database
Assignments
Assignment - 20th July 2021
Assignment - Session 3 - 22nd July 2021
Assignment - Session 4- 23rd July 2021
Assignment - Session 5 - 26th July 2021
Assignment - Session 7 - 28th July 2021
Assignment - Session 8 - 29th July 2021
Case Study
OLA Case Study
Harry Potter Case Study
Facility Services Case Study
Credit Card Case Study
Credit Case study questions
Accenture Case Study
Reference Materials
SQL - Session 5
SQL- Session 7 - 28-07-2021
SQL - Session - 29-07-2021
SQL- Session - 03-08-2021
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
Assignment - Session 4- 23rd July 2021
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock