SQL Basics (14 videos)
SQL Fundamentals, CRUD Operations & Setting Environment – Primary Key vs Unique Key, Auto Increment Values – DDL vs DML, Truncate vs Delete – Foreign Key Constraint – Distinct, Order By, Limit, Like Keyword – Order of execution in SQL – Aggregate Functions in SQL – Datatypes in SQL – Logical Operators in SQL – Joins in SQL – Difference between where and having in mysql – Over Clause & Partition By Clause – Row Number Function in MySQL – Rank & Dense Rank – SQL Advanced (2 videos) CTE in SQL – SQL internals –SQL Leetcode (8 problems)
LeetCode 175 – combine 2 tables Leetcode 176 – Second highest salary (3 approaches) Leetcode 178,180,181 – Rank Scores, Consecutive Numbers, Employees Earning More Than Their Managers Leetcode 182,183 – Duplicate Emails, Customers Who Never Order
