Practice Writing SQL Queries on StrataScratch | How to Solve SQL Queries
techTFQ techTFQ
289K subscribers
139,025 views
0

 Published On Feb 8, 2022

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:   / discord  

Please do subscribe and like this video if you found it useful.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:
   • SQL Tutorial - Basic concepts  

✅ SQL Tutorial - Intermediate concepts:
   • SQL Tutorial - Intermediate concepts  

✅ SQL Tutorial - Advance concepts:
   • SQL Tutorial - Advance concepts  

✅ Practice Solving Basic SQL Queries:
   • Practice Solving BASIC SQL Queries  

✅ Practice Solving Intermediate SQL Queries:
   • Practice Solving INTERMEDIATE SQL Que...  

✅ Practice Solving Complex SQL Queries:
   • Practice Solving COMPLEX SQL Queries  

✅ Data Analytics Career guidance:
   • Data Analytics career and more  

✅ SQL Course, SQL Training Platform Recommendations:
   • SQL Course / Training  

✅ Python Tutorial:
   • Python Tutorial  

THANK YOU,
Thoufiq

show more

Share/Embed