arrow_back
Introduction to SQL and installation of SQL server/client.
Welcome to Namaste SQL
Introduction to SQL and installation of SQL server/client.
Day1_Notes
ALTER commands, Constraints , Delete and Update
ALTER commands, Constraints , Delete and Update
DAY2_Notes
Select and Where
SELECT and WHERE Filter
Day3 Material
Day3_assignment_solution
orders_table_create_inserts
returns_table_create_inserts
SQL Filters Continue and aggregation
SQL Filters Continue and aggregation
Day4 material
day4_assignment_solution
Data Aggregation Continue + SQL Joins
Data Aggregation Continue + SQL Joins
Day 5 material
No of records by join type.
SQL Cross Join use cases
day5_assignment_solution
SQL functions : date functions, string functions, case when
SQL functions : date functions, string functions, case when
Day6 material
day6_assignment_solution
Set operation: Union, union all, minus, intersect
Set operation: Union, union all, minus, intersect
day 7 material
day7_assignment_solutions
SQL Interview Questions
SQL Interview Questions
day8_material
Sub queries and CTEs
Sub queries and CTEs
day9_notes
day9_assignment
day9_assignment_solution
Recursive CTE
Window Analytical functions: RANK, ROW_NUMBER, LEAD, LAG etc.
Window Analytical functions: RANK, ROW_NUMBER, LEAD, LAG etc.
day10_notes and assigment
day10_assignment_solution
Aggregation with window functions
Aggregation with window functions
day11 material
day11_assignment_solution
Procedures and functions
Procedures and functions
day12_material
advance insert/update, exists / not exists
day13 notes
SQL performance : Index and query optimization techniques.
SQL performance : Index and query optimization techniques and derived tables
day14 notes
Introduction to Tableau and path ahead
Introduction to Tableau and path ahead
SQL case study/Project 1
SQL portfolio project description
dataset
project1_solution
SQL case study/Project video solution
SQL case study/project 2 and 5000 Bonus
Project 2 olympic history and bonus worth Rs 5000
OLYMPICS_INSERT_SCRIPTS
Bonus - Data Modelling
Dimensional Modelling and ER Diagram
SQL Doubts Session - 1
SQL Doubts Session - 2
SQL Doubts Session (20 May 2023)