Grow Data SKills | Most Affordable Courses | Become Top Data Professional

Light
Dark

SQL Mastery Bootcamp - Basic To Advance

AWS Services For Data Engineering With Projects

By Shashank In Grow Data Skills

Self Paced
English
Completion Certificate

Demo Class Video

AWS Services For Data Engineering With Projects

1 Year

Validity (From the date of Enrollment)

40 Hours

Duration

11

Sessions

1

Projects

INR 3500

This course includes

Content Duration40 Hours
Total Sessions11
Total Industry Projects1
Real-world SQL project & 60 Easy-Hard SQL questions with solution discussion
Quality Assignments & quizzes after each module
Interview preparation guide
Dedicated placement assistance
Resume & Linkedin profile making
Offline doubt support on private discord group
Certificate of completion

Show More

Course Content

✅ Class - 1

What is Database?
What is DBMS?
What is RDBMS?
Different Types of Databases?
How data is stored in Transactional Databases?
ACID Properties
What is SQL?
Why do we use SQL?
Types of commands in SQL?
Setup PostgreSQL database in local
Setup DBeaver to perform queries on Postgres

✅ Class - 2

Different Data Types in Postgres
CREATE Database
CREATE Table
INSERT Data in Table
TRUNCATE Table
DROP Table
DELETE from Table
SELECT Command
LIMIT (TOP)
ALTER Command
UPDATE Command
WHERE Clause
UPDATE Command Selective
GRANT Command
REVOKE Command
COMMIT Command
ROLLBACK Command
SAVEPOINT Command
Primary Key & Foreign Key
Integrity Constraint
Unique
NOT NULL
Check
Default
Primary Key
Foreign Key
ALTER Command to create & update Integrity Constraints

✅ Class - 1

DISTINCT Function
COUNT Function
Arithmetic Operators ( + , - , / , * , % )
Logical Operators ( AND , OR , NOT)
Comparison Operators ( = , <> , ! = , < , > , < = , > = )
WHERE Clause
LIKE Operation
ORDER BY Clause
UNION , UNION ALL Operation
GROUP By
HAVING Clause
Aggregate Functions - MIN , MAX , SUM , AVG
Date & String In-built Functions

✅ Class - 2

STRING AGG
GROUP By ROLL UP
LEFT Join
RIGHT Join
Full Join
Cross Join
NATURAL Join
SELF Join
Sub-Queries
Scalar Subquery
Multi-row subquery
Correlated subquery
IN , NOT IN Operation

✅ Class - 1

ANY , ALL Operation
EXISTS , NOT EXISTS Operation
Window functions
RANK
DENSE_RANK
ROW_NUMBER
LEAD
LAG
FIRST_VALUE
LAST_VALUE
NTH_VALUE
NTILE
FRAME Clause in Window functions
ROWS Between
RANGE Between

✅ Class - 2

UNION
UNION ALL Operation
CASE Statement
Views
Common Table Expressions (WITH Clause)
Iterative CTE
Recursive CTE
Materialized Views

✅ Class - 3

PIVOT table, CROSSTAB function
User Defined functions
Stored Procedure

✅ Class - 1

FedEx-Style Parcel Logistics SQL Project

✅ Class - 2

Practical Solving & Explanation of SQL Problems

📌 Level - Easy

Employee Sales Variation (Asked in Amazon)
Top Active Customers (Asked in Walmart)
Final Loyalty Points Balance (Asked in Amazon)
Store Staff Strength Analysis (Asked in HSBC)

📌 Level - Medium

Grab Rider – Third Completed Ride (Asked in Grab)
International Shipment Percentage (Asked in Google)
Immediate Subscription Activation Percentage (Asked in Uber)
Time Spent on Learning Activities (Asked in Microsoft)
Customers Who Never Purchased a Specific Clothing Brand (Asked in Meta)

📌 Level - Hard

Tree Node Classification (Asked in Uber)
Paytm Repeated Payments Detection (Asked in Paytm)
Daily Trip Cancellation Rate for Valid Users (Asked in Expedia)
Second Sold Item Matches Favorite Brand (Asked in salesforce)
Month-over-Month Growth in Long Data Sessions (Asked in Airtel)

✅ Class - 3

Practical Solving & Explanation of SQL Problems

📌 Level - Medium

Second Most Recent Activity (Asked in Accenture)
Find Companies With at Least 2 Bilingual Users (English + German) (Asked in McKinsey)
App Analytics: Next-Day Purchase After Install (Asked in Zomato)
A hotel booking platform wants to track demand trends by city. (Asked in Airbnb)
E-commerce: Customers with Consecutive Month Purchases (Asked in Flipkart)
Social Media: Users Who Never Interacted (Asked in LinkedIn)

📌 Level - Hard

Finance: Stock Price Recovery After Decline Streak (Asked in Goldman Sachs)
Healthcare: Patients with Multiple Prescriptions from Different Doctors (Asked in UHG)

✅ Class - 4

Practical Solving & Explanation of SQL Problems

📌 Level - Medium

Banking: Account Balance Tracking with Transaction Types (Asked in JP Morgan)
Healthcare: Appointment Scheduling Conflicts Detection (Asked in Epic Systems)
Transportation: Delivery Performance Analysis by Time Windows (Asked in Uber)
Education: Course Enrollment Pattern Analysis (Asked in Coursera)
Food Delivery: Restaurant Performance During Peak Hours (Asked in DoorDash)
Employee Compensation: Cumulative Earnings Over Time (Asked in Microsoft)
Customer Transaction Analysis: Valid Transactions After Invalid Ones (Asked in PayPal)

📌 Level - Hard

E-commerce: Customers with Maximum Purchase Gap Analysis (Asked in Apple)
E-commerce: Customers Who Purchased Same Product in Consecutive Months (Asked in Amazon)

Course Schedule

Mode of the Course:

Self Paced

Course Duration:

40 Hours

Total Sessions:

11

Total Project:

1

Course Validity:

1 year (Starting From Day Of Enrollment)

Class Recording Provided:

Yes

Prerequisite:

Passion And Willingness To Learn

⚠️ Important Notice :

The video may not work on Linux due to DRM restrictions. It is only accessible on Chrome when using Windows or macOS.

Workaround: To access the video on Linux, you can create a Windows virtual machine (VM) and watch the video through the VM. Alternatively, you can use our Android or iOS application to view the video on your mobile device.

Instructor

Data Engineering With AWS

Shashank Mishra

Staff Data Engineer @ Prophecy Ex - Expedia, Amazon, PayTM, and McKinsey & Company

Shashank Mishra is a Staff Data Engineer at Prophecy, bringing 8+ years of experience building large-scale data systems across Expedia, Amazon, PayTM, and McKinsey & Company. An MCA graduate from NIT Allahabad, he specializes in architecting modern data pipelines, cloud-native platforms, and real-time analytics at enterprise scale. Beyond industry leadership, Shashank is a prominent educator — running the YouTube channel E-Learning Bridge (183K+ subscribers) and a LinkedIn community of 186K+ professionals. Over 20,000 students have been personally mentored by him, many securing offers from top global tech companies. Known for his project-driven teaching style, he simplifies complex data engineering concepts into actionable, real-world learning. His mission: empower the next wave of data talent to master tools, build production-grade solutions, and turn data into catalyst for career-defining outcomes.

SQL Mastery Bootcamp - Basic To Advance (Self Paced)

INR 3500

Copyright © 2026 Regex Data Learning Pvt Ltd. All Rights Reserved.