Hands-On SQL: 40+ SQL Queries & Solutions for Data Mastery

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