100 Days Of Sql : Ace The Sql Interviews Like A Pro!!

SQL For Data Analytics

What you'll learn

SQL interview questions from companies like Amazon, Google, Uber, and Microsoft

Problem Solving Mindset for Complex SQLs

Tricks to crack SQL interviews with ease

Multiple ways to solve a SQL problem

How to think through problems like a hiring manager wants you to

Clean and optimized SQL writing - beyond just passing test cases

Real-world tips for cracking online SQL assessments and technical interviews

Pattern recognition to quickly solve similar questions in interviews

Requirements

SQL Basics

Description

Struggling to crack SQL interviews? Want to master real-world SQL problems one step at a time?Welcome to 100 Days of SQL : Ace The SQL Interviews Like a PRO!! -  a hands-on, structured, and practical course designed to make you interview-ready with just one question a day!In this course, you'll solve 100 carefully curated SQL problems that are frequently asked in top tech and data companies. Each day brings you a short, focused video where we break down a new SQL question from scratch.Why This Course?Bite-sized lessons: Learn by solving 1 question a day - just 15-20 mins dailyReal company questions: Questions sourced from actual interviews and platforms.Progressive difficulty: Questions range from beginner to advanced, building your confidence over timeCode-along style: No theory overload - just practical, hands-on SQL with clear explanationsLearn Advanced Concepts: Techniques to handle aggregation, window functions, CTEs, subqueries, joins, and moreTaught by a creator with 200K+ followers: Learn from someone who's helped thousands crack SQL interviews through YouTube , LinkedIn and NamasteSQL Platform .Community + guidance: Ask doubts anytime and get support as you goWhether you’re stuck in SQL interviews or just starting your data journey, this course is your daily SQL gym - show up for 100 days and walk away job-ready.

Overview

Section 1: How to Make Most out of this course

Lecture 1 How to Make Most out of this course

Lecture 2 ICC Points Table

Section 2: Self Join Simplified and Interview Question

Lecture 3 Self Join Explanation

Section 3: New and Repeat Customers

Lecture 4 New and Repeat Customers

Section 4: Most Visited Floor

Lecture 5 Most Visited Floor

Section 5: Pivot and Unpivot

Lecture 6 Pivot and Unpivot

Section 6: Amazon Interview Question

Lecture 7 Amazon Interview Question

Section 7: Pareto Principle

Lecture 8 Pareto Principle

Section 8: Friends Score

Lecture 9 Friends Score

Section 9: Where vs Having

Lecture 10 Where vs Having

Section 10: Trips and Users

Lecture 11 Trips and Users

Section 11: Median Salary (2 Methods)

Lecture 12 Median Salary

Section 12: Tournament Winners

Lecture 13 Tournament Winners

Section 13: Market Data Analysis

Lecture 14 Market Analysis

Section 14: User Purchase Platform

Lecture 15 User Purchase Platform

Section 15: Recursive CTE

Lecture 16 Recursive CTE

Section 16: Amazon Prime Subscription Rate

Lecture 17 Amazon Prime Subscription Rate

Section 17: Data Science SQL Interview Question

Lecture 18 Data Science SQL Interview Question

Section 18: Customer Retention and Churn Analysis (Part 1)

Lecture 19 Customer Retention and Churn Analysis (Part 1)

Section 19: Customer Retention and Churn Analysis (Part 2)

Lecture 20 Customer Retention and Churn Analysis (Part 2)

Section 20: Leetcode Hard SQL Problem

Lecture 21 Leetcode Hard SQL Problem

Section 21: Scenario Based SQL Question

Lecture 22 Scenario Based SQL Question

Section 22: Spotify Case Study

Lecture 23 Spotify Case Study

Section 23: Consecutive Empty Seats

Lecture 24 Consecutive Empty Seats

Section 24: Missing Quarter Using 3 Methods

Lecture 25 Missing Quarter Using 3 Methods

Section 25: Deadly Combination of Group By and Having Clause

Lecture 26 Deadly Combination of Group By and Having Clause

Section 26: Beauty of SQL RANK Function

Lecture 27 Beauty of SQL RANK Function

Section 27: Google SQL Interview Question

Lecture 28 Google SQL Interview Question

Section 28: Meesho HackerRank SQL Question

Lecture 29 Meesho HackerRank SQL Question

Section 29: Horizontal Sorting in SQL

Lecture 30 Horizontal Sorting in SQL

Section 30: 4 Tricky SQL Problems

Lecture 31 4 Tricky SQL Problems

Section 31: Brilliant SQL Interview Question

Lecture 32 Brilliant SQL Interview Question

Section 32: SQL ON OFF Problem

Lecture 33 SQL ON OFF Problem

Section 33: LeetCode - Student Reports

Lecture 34 Student Reports

Section 34: LeetCode - Employee Median Salary

Lecture 35 Employee Median Salary

Section 35: Amazon SQL Interview Question

Lecture 36 Amazon SQL Interview Question

Section 36: Leetcode - Human Traffic of Stadium

Lecture 37 Human Traffic of Stadium

Section 37: Udaan Power of Self Join

Lecture 38 Udaan Power of Self Join

Section 38: PharmEasy SQL Interview Question

Lecture 39 PharmEasy SQL Interview Question

Section 39: Bosch Scenario Based SQL Interview Question

Lecture 40 Bosch Scenario Based SQL Interview Question

Section 40: Deloitte SQL Interview Question

Lecture 41 Deloitte SQL Interview Question

Section 41: Leetcode - Find the Quiet Students in All Exams

Lecture 42 Find the Quiet Students in All Exams

Section 42: Walmart Labs SQL Interview Question

Lecture 43 Walmart Labs SQL Interview Question

Section 43: Microsoft SQL Interview Question

Lecture 44 Microsoft SQL Interview Question

Section 44: Double Self Join in SQL

Lecture 45 Double Self Join in SQL

Section 45: SQL Pre-Screening Test

Lecture 46 SQL Pre-Screening Test

Section 46: Uber SQL Interview Problem

Lecture 47 Uber Very Interesting SQL Interview Problem

Section 47: Amazon SQL Interview Problem

Lecture 48 Tricky SQL Interview Problem Asked in Amazon

Section 48: Marketing Campaign Success SQL Problem

Lecture 49 Marketing Campaign Success SQL Advanced Problem

Section 49: Fintech Startup SQL Interview Question

Lecture 50 Fintech Startup SQL Interview Question

Section 50: Data Analyst Case Study

Lecture 51 Data Analyst Case Study

Section 51: Amazon Data Engineer SQL Interview Problem

Lecture 52 Amazon Data Engineer SQL Interview Problem

Section 52: PayPal SQL Interview Problem (Level Hard)

Lecture 53 PayPal SQL Interview Problem

Section 53: PayPal Data Engineer SQL Interview Question (and a secret time saving trick)

Lecture 54 PayPal Data Engineer SQL Interview Question (and a secret time saving trick)

Section 54: Uplers SQL Interview Problem (Senior Data Analyst)

Lecture 55 Uplers SQL Interview Problem (Senior Data Analyst)

Section 55: Namaste SQL Assignment Question

Lecture 56 Solving a Namaste SQL Assignment Question

Section 56: Solving a Leetcode DSA Problem with SQL

Lecture 57 Solving a Leetcode DSA Problem with SQL

Section 57: ITC Infotech SQL Interview Question

Lecture 58 ITC Infotech SQL Interview Question

Section 58: Famous SQL Interview Question

Lecture 59 Famous SQL Interview Question

Section 59: Ludo King SQL Question

Lecture 60 Ludo King SQL Question

Section 60: Swiggy SQL Interview Question

Lecture 61 Swiggy Data Analyst SQL Interview Question and Answer

Section 61: 15 Days of Learning SQL

Lecture 62 15 Days of Learning SQL _ Advanced SQL for Data Analytics

Section 62: Fractal SQL Interview Question

Lecture 63 Fractal Analytics SQL Interview Question

Section 63: Tredence Analytics

Lecture 64 SQL Interview Question Asked in Tredence Analytics

Section 64: American Express SQL Interview Question

Lecture 65 American Express SQL Interview Question

Section 65: Amazon SQL Interview Question on Notepad

Lecture 66 Solving an Amazon SQL Interview Question on Notepad

Section 66: Zepto SQL Interview Question

Lecture 67 Zepto Product Analyst SQL Interview Question

Section 67: Probo SQL Interview Question

Lecture 68 Probo Very Interesting SQL Interview Question

Section 68: Top Data Analyst SQL Interview Question

Lecture 69 Top Data Analyst SQL Interview Question by A Startup

Section 69: EPAM SQL Interview Questions

Lecture 70 EPAM SQL Coding Test Interview Questions

Section 70: FAANG SQL Interview Question

Lecture 71 REAL SQL Interview Question by a FAANG Company

Section 71: SQL Project for Data Analytics (Level - Advanced)

Lecture 72 SQL Project for Data Analytics (Level - Advanced)

Section 72: Microsoft SQL Interview Question

Lecture 73 Microsoft SQL Interview Question _ Possible Flight Routes

Section 73: Olympic Gold Medals Problem

Lecture 74 Olympic Gold Medals Problem

Section 74: Solving a REAL Business Use Case Using SQL

Lecture 75 Solving a REAL Business Use Case Using SQL

Section 75: Amazon SQL Interview Question

Lecture 76 Amazon SQL Interview Question for Data Analyst Position [2-3 Year Of Experience

Section 76: Airbnb SQL Interview Question

Lecture 77 Airbnb SQL Interview Question _ Convert Comma Separated Values into Rows

Section 77: SQL Interview Question

Lecture 78 SQL Interview Question for Senior Data Engineer Position in Poland

Section 78: L&T SQL Interview Problem

Lecture 79 L&T SQL Interview Problem _ Print Highest and Lowest Salary Employees

Section 79: Data Analyst SQL Interview Question

Lecture 80 Data Analyst SQL Interview Question Asked in a Startup _ Data Analytics

Section 80: Infosys SQL Interview Question

Lecture 81 Solving a SQL Puzzle _ Infosys SQL Interview Question

Section 81: Ameriprise LLC Company SQL Interview Problem

Lecture 82 Ameriprise LLC Company SQL Interview Problem _ Data Analytics

Section 82: Tiger Analytics SQL Interview Question

Lecture 83 Tiger Analytics SQL Interview Question for Data Engineering Position

Section 83: PWC SQL Interview Question

Lecture 84 PWC SQL Interview Question _ BIG 4 _Normal vs Mentos Life ?

Section 84: Data Analyst SQL Interview Question

Lecture 85 Data Analyst SQL Interview Question

Section 85: ICC Cricket World Cup 2023 Points Table

Lecture 86 ICC Cricket World Cup 2023 Points Table

Section 86: PWC SQL Interview Question

Lecture 87 PWC SQL Interview Question for a Data Analyst Position _ SQL For Analytics

Section 87: Google SQL Interview Question

Lecture 88 SQL Interview Question Asked in Google for Data Analyst Position _ Data Analytic

Section 88: SQL Interview Question Asked in Google for Data Analyst Position

Lecture 89 SQL Interview Question Asked in Google for Data Analyst Position

Section 89: Angel One SQL Interview Question

Lecture 90 Angel One Easy-Peasy SQL Interview Question for a Data Science Position

Section 90: Accenture SQL Interview Question

Lecture 91 Accenture SQL Interview Question

Section 91: EXL Analytics SQL Interview Question

Lecture 92 EXL Analytics SQL Interview Question

Section 92: Exchange Seats

Lecture 93 Exchange Seats

Section 93: Market Analysis 2

Lecture 94 Market Analysis 2

Section 94: Game Play Analysis (Set of 4 Questions)

Lecture 95 Game Play Analysis (Set of 4 Questions)

Data Analyst,Data Engineer,Data Scientist,Business Intelligence Engineers,Business Analyst,SQL Developer,ETL Developer