Рет қаралды 142,412
Visit stratascratch.... 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: learnsql.com/?....
[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: / discord
Please do subscribe and like this video if you found it useful.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq