REAL SQL Interview Problem | Hierarchical data in SQL
In this video let us solve a real SQL interview problem. This problem is to find the hierarchy of employees.
We shall first understand the problem statement and the given data before solving the problem.
During the video, we shall also see how to debug a recursive SQL query. We shall try to come up with the different queries SQL generates during each iteration of the recursive SQL query. This will hopefully give you a complete understanding of how recursive SQL query works.
🔴 My Recommended courses 👇
✅ Learn complete SQL: https://learnsql.com/?ref=thoufiqmohammed
✅ Practice SQL Queries: https://www.stratascratch.com/?via=techTFQ
✅ Learn Python: https://codebasics.io/courses/python-for-beginner-and-intermediate-learners?refId=70170e4c-7511-4c83-b769-c5cc8339c731
✅ Learn Power BI: https://codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project?refId=4b1e1886-3252-4bf1-86f4-7d603dab692f
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
✅ Git and GitHub Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b
✅ Data Analytics Projects:
https://www.youtube.com/playlist?list=PLavw5C92dz9HwT_uStsDdJbuBOt_XD0ch
THANK YOU,
Thoufiq
Видео REAL SQL Interview Problem | Hierarchical data in SQL канала techTFQ
We shall first understand the problem statement and the given data before solving the problem.
During the video, we shall also see how to debug a recursive SQL query. We shall try to come up with the different queries SQL generates during each iteration of the recursive SQL query. This will hopefully give you a complete understanding of how recursive SQL query works.
🔴 My Recommended courses 👇
✅ Learn complete SQL: https://learnsql.com/?ref=thoufiqmohammed
✅ Practice SQL Queries: https://www.stratascratch.com/?via=techTFQ
✅ Learn Python: https://codebasics.io/courses/python-for-beginner-and-intermediate-learners?refId=70170e4c-7511-4c83-b769-c5cc8339c731
✅ Learn Power BI: https://codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project?refId=4b1e1886-3252-4bf1-86f4-7d603dab692f
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
✅ Git and GitHub Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b
✅ Data Analytics Projects:
https://www.youtube.com/playlist?list=PLavw5C92dz9HwT_uStsDdJbuBOt_XD0ch
THANK YOU,
Thoufiq
Видео REAL SQL Interview Problem | Hierarchical data in SQL канала techTFQ
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Top 10 SQL Interview Queries | Popular SQL Queries for SQL InterviewSQL Cricket Match Problem | Solving SQL Interview ProblemFrom 16 years of CAREER GAP To becoming a Software Engineer | How to get a JOB after a career gap3 SQL Queries Asked in Interview for Business Analyst - SolvedCourses You Can Take To Get Into Data AnalyticsSolving a Real SQL Interview Problem | Job Vacancies SQL QueryPython Bootcamp for Beginners | Python Course | Live TrainingSQL Data Analytics Project (PART 3) | Data Analyst Portfolio ProjectSQL Data Analytics Project (PART 2) | Data Analyst Portfolio ProjectSQL Data Analytics Project (PART 1) | Data Analyst Portfolio ProjectLearn SQL from me | Live SQL Training | SQL BootcampLearn Python here | Learn Python Programming hereSolving a Complex SQL Interview problem | Practice SQL QueriesComplete guide to Database Normalization in SQLSQL Live class on Lighthall | Learn SQL from Basic to Advance in SQL BootcampHow to learn SQL for free | Roadmap to learning SQLSolving an SQL Interview ProblemSolving SQL Interview Query | Find Tree Node type using SQLSolving SQL Interview Query for Data Analyst asked by a Product based companySolving a tricky SQL Interview Query