Data Engineering
Get Job-Ready with SQL Server in 30 Days
From your first SELECT to the window functions and optimisation work a data engineering job actually asks for.
From your first SELECT to the window functions and optimisation work a data engineering job actually asks for.
Part of Data Engineering: The Complete, Job-Ready Program
Taught by Sharuk Shaik
Enterprise data engineering trainer with 10+ years of experience and 3000+ students trained
- Lessons
- 16
- Length
- 5h 42m
- Live classes
- 2
- Level
- Beginner
₹7,999
New here? Create an account
- 16 recorded lessons, yours for the life of the enrollment
- 2 live classes with your instructor
- 2 downloadable resources
- Verifiable certificate on completion
What you will be able to do
- Write joins, subqueries and CTEs without reaching for documentation
- Use window functions for running totals, rankings and comparisons across rows
- Read an execution plan and know where a slow query is losing time
- Solve the kind of messy, ambiguous SQL problem an interview or a real job actually gives you
About this course
Every data role starts with SQL, and most SQL teaching stops well short of what a job needs. This course does not.
We go from fundamentals through joins, subqueries and CTEs, then into the part most courses skip: window functions, reading an execution plan, and optimising a query that is slow for a reason you cannot see yet. The last module is entirely real-world problems — deduplicating messy data, sessionizing event logs — worked the way you would actually encounter them, not as isolated syntax drills.
By the end you will be able to open an unfamiliar schema and answer a real question with it, quickly and correctly.
Who it is for
- Anyone starting a data analyst or data engineer path from zero
- Developers who write SQL occasionally and want to stop guessing
- Analysts who know basic SELECT statements and want to go further
What you need
- No prior SQL experience required
- A computer that can run a free database (setup is covered in Module 1)
Curriculum
4 modules · 16 lessons · 5h 42m
Lessons marked Preview are free to watch.
- What this course covers, and how to practise it Preview 8m
- SELECT, WHERE and ORDER BY in practice Preview 19m
- Aggregations and GROUP BY 24m
- Data types and working with NULL 16m
- Inner, outer and cross joins in practice 27m
- Subqueries: correlated vs uncorrelated 22m
- Common table expressions for readable logic 20m
- Recursive CTEs for hierarchical data 23m
- Window functions: ROW_NUMBER, RANK and LAG/LEAD 29m
- Running totals and moving averages 21m
- Reading an execution plan 26m
- Indexing and query optimisation basics 24m
- Turning a business question into SQL 18m
- Real-world problem: deduplicating messy data 25m
- Real-world problem: sessionizing event logs 28m
- Writing SQL a teammate can read in six months 12m
Your instructor
Sharuk Shaik
Enterprise data engineering trainer with 10+ years of experience and 3000+ students trained
Sharukh Sir is a seasoned data engineering professional with over a decade of experience building and managing enterprise data platforms across multiple industries including banking, insurance, retail, and healthcare.
Having worked with organizations ranging from fast-growing startups to Fortune 500 companies, he brings a unique perspective that blends deep technical knowledge with practical business understanding.
His teaching philosophy is simple: theory without practice is incomplete. Every concept is taught with real-world context, every module ends with hands-on exercises, and every student graduates with production-grade project experience.
His mission is to make every student industry-ready from day one — not just in tools and technology, but in mindset, problem-solving, and professional communication.
Student reviews
Exactly what I needed to go from writing one-off scripts to a proper, idempotent ETL job I would actually trust in production.
Jude Mensah · 10 Sep 2026
Common questions
Anything else, just ask.
Get Job-Ready with SQL Server in 30 Days
16 lessons, 5h 42m of instruction , plus 2 live sessions.
₹7,999
Sign in to enroll