Hands-On SQL: 40+ SQL Queries & Solutions for Data Mastery
Hands-On SQL: 40+ SQL Queries & Solutions for Data Mastery
Published 10/2025
Duration: 4h 23m | .MP4 1920x1080 30 fps(r) | AAC, 44100 Hz, 2ch | 1.97 GB
Genre: eLearning | Language: English
Published 10/2025
Duration: 4h 23m | .MP4 1920x1080 30 fps(r) | AAC, 44100 Hz, 2ch | 1.97 GB
Genre: eLearning | Language: English
Easy - Medium - level - SQL Problems Solved using PostgreSQL
What you'll learn
- 90 + Diverse SQL Problems asked in various Companies
- Problem-Solving Strategies
- How to write SQL Queries asked in Interviews - step by step approach
- Various SQL/Database Concepts
- Hands-on Practice
Requirements
- Basic SQL Knowledge
Description
Solve 40+ SQL Queries asked in product based MNCs with the use of PostgreSQL.
All the Queries explained with problems statements , expected output and step-by-step approach to solve the Query.
Downloadable resources are provided for all the queries used in this course - with solution.
These solutions will be useful for multiple relation databases as well with some minor changes in the syntax and functions.
40 + Queries with Step-by-Step Solutions (Course content)
EASY LEVEL :
1 Percentage of Students Scoring Over 90
2 Find Customers Who Have Never Ordered
3 Find Departments With No Employees
4 Find Duplicate Emails
5 Find Users Active Every Month
6 Finding Matched and Mismatched Records
7 Find Employees Earning More Than Their Manager
8 Find Employee's Manager Name
9 Find the Manager with the Most Reports
10 Find the Nth Highest Salary
11 Find the Number of Employees Reporting to Each Manager
12 Find Top 3 Highest Paid Employees per Department
13 Swap Gender Values in a Single Update
14 Categorize Products into Price Brackets
15 Find Products Never Sold using EXCEPT
16 List All Employees in Each Department
17 Extract User Domain firom Email
18 Count Medal Types per Country (Advanced Pivot)
19 Find Employees Who Joined Befiore Their Manager
20 Delete Orders of Inactive Customers
21 Find Products Sold in January but Not in February
22 Calculate Basic Customer Lifietime Value (LTV)
23 Find Mutual Friends
24 Find Team Size for Each Employee
25 Immediate Food Delivery Percentage
26 Find Managers with Exactly 5 Direct Reports
27 Find Movies with Ratings Above Genre Average
28 Game Play Analysis
29 Actor and Director Cooperation
30 Find Second Most Recent Activity
2.MEDIUM LEVEL :
31 Students Scoring Above Average in Each Subject
32 Second Highest and Lowest Marks per Subject
33 Calculate Running Total of Sales
34 Delete Duplicate Rows
35 Group User Activity into Sessions (Sessionization)
36 Find the Mode (Most Frequent Value)
37 Calculate Each Employee''s Salary as Percentage of Department Total
38 Calculate Time to Next User Action
39 User Purchase Platform Analysis
40 Find the Quiet Students in an Exam
Solved together using PostgreSQL.
Who this course is for:
- SQL Enthusiasts
- Data Engineers
- Data Analysts
- Data Scientists
More Info