SQL Server 2022: SQL Query Course
Complete working professional SQL course: from SELECT and joins to window functions, CTE, stored procedures, ETL and reports, with a project every week.
Course highlights
Sujeet Sir
Excel | VBA | Power BI | SQL | Python
Founder and Trainer, IPT Excel School
- MIS Executive and VBA Developer in 10+ companies
- Report consultant for 40+ organizations
- Real workplace examples in every class
What you will learn
SELECT, WHERE, GROUP BY, ORDER BY, functions, subqueries.
All joins, set operators, views, indexes, procedures, triggers.
Window functions, CTE, string and date functions, pivot, tuning.
Import CSV and Excel, cleaning, ETL, data modeling, reports.
Week 5 advanced queries and automation.
Query report, joins analysis, advanced report and data pipeline.
BENEFITS
- Write SQL queries from basic to advanced level
- Join, analyse and clean data from many tables
- Use window functions, CTE, procedures and triggers
- Certificate, real projects and lifetime support
YOUR GOAL
Build an end-to-end data pipeline and reports using SQL Server.
WHO SHOULD LEARN
Students, MIS and Excel users, analysts and career switchers who want to work with databases.
COURSE OUTLINE
⬇ Download PDFWeek 1 - SQL basics and setup (Days 1-5)
- Day 1 : Introduction and environment
- Day 2 : SELECT, WHERE, GROUP BY
- Day 3 : ORDER BY, LIMIT
- Day 4 : Functions (string, numeric)
- Day 5 : Subqueries
- Project 1 : Basic query report
Week 2 - Joins and data analysis (Days 6-10)
- Day 6 : INNER, LEFT, RIGHT, FULL JOIN
- Day 7 : UNION, INTERSECT, EXCEPT
- Day 8 : Views and indexes
- Day 9 : Stored procedures
- Day 10 : Functions and triggers
- Project 2 : Data analysis with joins
Week 3 - Advanced SQL (Days 11-15)
- Day 11 : Window functions
- Day 12 : CTE (Common Table Expressions)
- Day 13 : String and date functions
- Day 14 : Pivot and unpivot
- Day 15 : Performance tuning
- Project 3 : Advanced query report
Week 4 - Analytics and integration (Days 16-20)
- Day 16 : Import data (CSV, Excel)
- Day 17 : Data cleaning and transformation
- Day 18 : SQL Server and ETL concepts
- Day 19 : Data modeling
- Day 20 : Reports and dashboards (SQL)
- Project 4 : End-to-end data pipeline
Week 5 - Advanced SQL and automation (Days 21-25)
- Advanced SQL and automation
COURSE DETAILS
| Duration | 25 days (5 weeks) of live online classes |
|---|---|
| Topics | SQL basics, joins, advanced SQL, analytics and integration |
| Mode | Live online classes |
| Batch | One-to-one or group batch |
| Language | Hindi or English |
| Projects | 4 projects: query report, joins analysis, advanced report, data pipeline |
| Certificate | Yes, certificate of completion |
| Support | Doubt support and lifetime support |
| Demo | Free 3-4 day demo class |
| Fees | Contact Sujeet Sir: +91 88025 79388 |
HOW IT IS TAUGHT
Live online by Sujeet Sir in Hindi or English, with real workplace examples, a project every week, a certificate and lifetime support.
Join a free demo
Questions about this course
What is the fee of the SQL Server course?
Fees depend on one-to-one or group batch. Contact Sujeet Sir on +91 88025 79388 or WhatsApp for the current fee.
Is there a free demo?
Yes. Join the 3-4 day free demo before you pay.
Which language is it taught in?
Hindi or English, as you prefer.