Practice Writing SQL Queries on StrataScratch | How to Solve SQL Queries
Visit https://stratascratch.com/?via=techTFQ and use the discount code “ss15” to get 15% off on any StrataScratch subscription.
In this video, I will be solving some SQL Interview queries on StrataScratch. StrataScratch is an online platform where you can find hundreds of interview questions related to SQL and Python. You can solve these SQL Interview Questions on the StrataScratch platform itself without the need to install any database or any other software.
There are hundreds of different SQL Interview problem which have been asked by big tech companies. You would find SQL questions for beginner, for intermediate level and for expert level programmers. So no matter what your level of expertise is in SQL, you would find several different SQL questions to solve depending on your skill level.
In this video, I will solve 2 different SQL questions,
First we shall solve the “Users By Avg Session time” question. Now I will be providing 2 different solutions to this problem. One solution using subqueries and the second solution using JOINS. Hopefully this gives you an idea of how to solve a problem using different approaches.
Secondly, we shall solve the “Seat Availability” question. We shall solve this problem using self JOIN and UNION operator.
I will explain in detail my thinking behind solving these problems and also the reasoning behind using certain logic.
My recommended SQL Course: https://learnsql.com/?ref=thoufiqmoha...
[All the scripts and SQL queries used in this video is shared in my Discord server. You can join my discord by clicking on the below link. It's FREE]
Join my Discord Server: https://discord.gg/8aRSbygbdu
Please do subscribe and like this video if you found it useful.
🔴 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
THANK YOU,
Thoufiq
Видео Practice Writing SQL Queries on StrataScratch | How to Solve SQL Queries канала techTFQ
In this video, I will be solving some SQL Interview queries on StrataScratch. StrataScratch is an online platform where you can find hundreds of interview questions related to SQL and Python. You can solve these SQL Interview Questions on the StrataScratch platform itself without the need to install any database or any other software.
There are hundreds of different SQL Interview problem which have been asked by big tech companies. You would find SQL questions for beginner, for intermediate level and for expert level programmers. So no matter what your level of expertise is in SQL, you would find several different SQL questions to solve depending on your skill level.
In this video, I will solve 2 different SQL questions,
First we shall solve the “Users By Avg Session time” question. Now I will be providing 2 different solutions to this problem. One solution using subqueries and the second solution using JOINS. Hopefully this gives you an idea of how to solve a problem using different approaches.
Secondly, we shall solve the “Seat Availability” question. We shall solve this problem using self JOIN and UNION operator.
I will explain in detail my thinking behind solving these problems and also the reasoning behind using certain logic.
My recommended SQL Course: https://learnsql.com/?ref=thoufiqmoha...
[All the scripts and SQL queries used in this video is shared in my Discord server. You can join my discord by clicking on the below link. It's FREE]
Join my Discord Server: https://discord.gg/8aRSbygbdu
Please do subscribe and like this video if you found it useful.
🔴 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
THANK YOU,
Thoufiq
Видео Practice Writing SQL Queries on StrataScratch | How to Solve SQL Queries канала techTFQ
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to clear Job Interviews? Job Interview TipsJob Interview Tips | Follow these steps to clear JOB INTERVIEWS | How to clear Job Interviews?Solving SQL Interview Problem with MULTIPLE solutions | Practice SQL QueriesSQL Project | SQL Case Study to SOLVE and PRACTICE SQL Queries | 20+ SQL ProblemsTop 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 QueriesREAL SQL Interview Problem | Hierarchical data in SQLComplete 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 SQL