SQL Interview Cracker

Crack Your SQL Coding Interview with Parthiban Kannan (under development)

Course Instructor Parthiban Kannan

₹700.00 ₹2000.00 65% OFF

Course Overview

Schedule of Classes

Course Curriculum

2 Subjects

SQL Interview Cracker

56 Learning Materials

Introduction & Database Setup

Course Introduction

Video

1:14

DBSolver Database V1.0

ZIP

Setup Course Database

Video

6:39

Upload Database Command

Beginner

How many companies are available?

What is the range of Experience?

How many JOBs for Python Programming?

List out duplicate JOBS

List out cities of All Female Employees

Filter the male employees who gets salary more than...

Calculate the salary expenses of Female Employees

Find the most frequent city

Randomly collect 1000 rows of data

Randomly collect 30% of Data

List of employees from Same City

First and Last date of current month

What is the day of week 10 days ago

Day of Current, Previous and Next month start date.

Total Revenue Generated By Each Course

Add a column to display total fee collected based on course

Find total number of skills for each JOB

Employee Salary Lesser than Average Salary of theri City

Get Line Number from the SalesOrderLine

Maske Customer Key

Intermediate

How many data science positions available

Display duplicate count of rows in a new column

List out top 5 Position and their Percentage in overall Jobs

Recommend 5 Skills with Python

List out Genderwise Salary in Percentage

City which has maximum average salary expense

Top 5 cities based on median salary

Statistically Describe the Employees Salary

Find the % of Relationship and Direction

List of High Salaried Employees in Each Position

Display First name and Salary filled with $

Find the 1st Wednesday of the Current Month

Find the 3rd Friday of Next Month

Find the students inside training

List of Second Highest Salaried Person in Each City

Display all products with the revenue earned

Display the Products which never Sold

Find Percentage of Paid Amount over Total Paid Amount

List of employees belongs from same city and position

List out Lowest and Highest Salaried Employees from All Cities

Average Monthly Revenue By Each Course

Product Category with Maximum Average Sales

Total number of companies posted duplicate jobs

List out late payment students

Expert

Count Most Asked Skills

Top 5 Skills for Data Science Position

Find the Top 5 Skills and their Percentage on Data Science Position

Recommend Top 5 Skills for Top 5 Jobs

Top 2 Prouducts in Each Category Based on Sales Amount

Find the Percentage Variance of Sales from Previous Day

Find 3 months rolling average

List out the Second Highest Salaried Person Including

Coding Round from Industries

103 Learning Materials

Affine

Find Second Wednesday of the Current Month

Airbnb

Amazon

Find the Number of Employees Inside the Hospital

Highest Selling Product in Each Category

Find all the numbers appears consecutively

Find out minimum and maximum value for each id

Find latest order of each customers

American Express

Social Media Recommendation

Ameriprise LLC

Filtering Team Members with Some Criteria

Ascendion

Largest value among all columns

Bayer

Departmentwise Second Highest Salary

Bosch

Forward filling the categories

Capgemini

Find the Percentage Variance

Revenue generated by Each Products

Products not sold

Total cost of Each Products

Possible combination of people on Lift

Total members on Each Team

Lenght of each records

Data Semantics

Deloitte

Change in Employee Status

Performance Analysis

Top 3 Paid Employees in Each Department

Average Salary of Employee hired in last 5 years

Employees salary lesser than average salary

Forward filling department values

Find origin and destination of flights

Population density of each cities

Ecolab

Extract domain name from email id

EPAM Systems

Get all employees from the Same Department

3 months rolling average revenue/*Find the 3-month rolling average of total revenue from purchases g

EXL Analytics

Minimum and Maximum population of cities

EY

Average Monthly Revenue for Each Sector

Google

Second most recent activity of each user

Top 5 buyer-seller combination

Validate Triangles

HCL

Count Number of Rows using Joins

Hero Motocorp

Mask the 12 digits on Card number

Select All Employees with Same Salary

Hexaware

Find Max ID ignoring duplicates

Honeywell

Highest Average Rating Based on Genre

IBM

Maximum discount offered on Tour Packages based on Family Size

IKRUX

Department-wise Highest Salaried employees

Incedo

Add Grades Column

Indium

Find Consecutive Numbers

Infosys

Find origin and final destination of flights

Find ids of higher temperature from previous day

JLL

Employee Salary Higher Than Manager Salary

KPMG

Total marks of 2 subjects has high scores

Find running total

Total number of companies posted duplicate jobs

McKinsey

Find Net Present Value (NPV)

List of Pizzas with possible combinations of toppings with Price

Meesho

3 month moving average sales for each month

List out Retained Customers

Hierarchy of Employees

Month over Month Percentage Change

Microsoft

Hiring New Employees

Morgan Stanley

Vaccination does in recommended period

Movate

Combination of two tables with minimum salary

Mphasis

Department wise Maximum Score

NEC

Total IPL Matches, Batters and Bowlers

Netflix

Average Star Rating

Opensea

Find most expensive NFCs

Persistent systems

Find unique combinations

PWC

List out companies only has positive growth

Find the percentage of Genders

Find average temperature of each day

Compare source and target tables

R Systems

Find the currency exchange rate

Robinhood

Total available seats on all flights

Shopify

Find total active hours of each users

Spotify

List out Top 5 Artist based on song appeared

Exclude bad song title

Swiggy

Find Out of stock based on minimum stock on consecutive days

Find delayed order of each delivery partner

Find the date when 3rd highest sales of 4th Product

Target

List out sellers who did not make any sales

TCS

Find product wise total sales

List of records with minimum 3 consecutive ids

List of companies sales never decreased over years

Tech Mahindra

Find the person with living Grand Father

Tiger Analytics

Make a pair of parent and kid

Find origin and final destination of each fligh

Monthwise New Customers

Tredence

Find 3 or more consecutive events

Trelleborg

Find out monthly sales

Find 3 days rolling average tweets

Uber

Find highest number of uber rides per day

Find 3rd transaction of every users

Twitter

UST Global

List of seats available in sequence

Find missing order Id's

Walmart

Number of products purchased by each users

Total managers in each department

Comparing salaries of friends

Winwire

Display specific rows at top/bottom of the result

Wipro

Department wise employees who getting low and high salary

Zomato

Re-align the swapped items

Find average rating of each restaurant for each month

Find the eligibility of discounts

Course Instructor

Parthiban Kannan

106 Courses • 3443 Students

SQL Interview Cracker

Course Overview

Schedule of Classes

Course Curriculum

SQL Interview Cracker

Introduction & Database Setup

Course Introduction

DBSolver Database V1.0

Setup Course Database

Upload Database Command

Beginner

How many companies are available?

What is the range of Experience?

How many JOBs for Python Programming?

List out duplicate JOBS

List out cities of All Female Employees

Filter the male employees who gets salary more than...

Calculate the salary expenses of Female Employees

Find the most frequent city

Randomly collect 1000 rows of data

Randomly collect 30% of Data

List of employees from Same City

First and Last date of current month

What is the day of week 10 days ago

Day of Current, Previous and Next month start date.

Total Revenue Generated By Each Course

Add a column to display total fee collected based on course

Find total number of skills for each JOB

Employee Salary Lesser than Average Salary of theri City

Get Line Number from the SalesOrderLine

Maske Customer Key

Intermediate

How many data science positions available

Display duplicate count of rows in a new column

List out top 5 Position and their Percentage in overall Jobs

Recommend 5 Skills with Python

List out Genderwise Salary in Percentage

City which has maximum average salary expense

Top 5 cities based on median salary

Statistically Describe the Employees Salary

Find the % of Relationship and Direction

List of High Salaried Employees in Each Position

Display First name and Salary filled with $

Find the 1st Wednesday of the Current Month

Find the 3rd Friday of Next Month

Find the students inside training

List of Second Highest Salaried Person in Each City

Display all products with the revenue earned

Display the Products which never Sold

Find Percentage of Paid Amount over Total Paid Amount

List of employees belongs from same city and position

List out Lowest and Highest Salaried Employees from All Cities

Average Monthly Revenue By Each Course

Product Category with Maximum Average Sales

Total number of companies posted duplicate jobs

List out late payment students

Expert

Count Most Asked Skills

Top 5 Skills for Data Science Position

Find the Top 5 Skills and their Percentage on Data Science Position

Recommend Top 5 Skills for Top 5 Jobs

Top 2 Prouducts in Each Category Based on Sales Amount

Find the Percentage Variance of Sales from Previous Day

Find 3 months rolling average

List out the Second Highest Salaried Person Including

Coding Round from Industries

Affine

Find Second Wednesday of the Current Month

Airbnb

Most Popular Room Type

Amazon

Find the Number of Employees Inside the Hospital

Highest Selling Product in Each Category

Find all the numbers appears consecutively

Find out minimum and maximum value for each id

Find latest order of each customers

American Express

Social Media Recommendation

Ameriprise LLC

Filtering Team Members with Some Criteria