SQL for Data Analysis
A beginner-friendly 8-week course that takes you from your first SELECT to joins, subqueries, CTEs, window functions and stored procedures on MySQL and PostgreSQL. You practise on real business-style databases and finish with a capstone you can show in interviews.
- Duration: 8 weeks
- Fee: Rs 15,999 (about Rs 2,666 a month on EMI)
- Field: Data & Analytics
Roles this track prepares you for
- Data Analyst
- Junior Data Analyst
- Database Analyst
- Business Intelligence Analyst
- SQL Developer
- Reporting Analyst
- MIS Executive
- Business Analyst
- Data Reporting Analyst
- Analytics Associate
Curriculum
- Databases and Your First Queries - Understand how relational databases store data, set up MySQL and PostgreSQL, and write your first SELECT queries with filters and sorting.
- How Relational Databases Store Business Data
- Setting Up MySQL and PostgreSQL
- SELECT and WHERE: Asking Your First Questions
- Sorting, Limiting and Removing Duplicates
- NULL Values, AND, OR, IN and LIKE
- Functions, CASE and Cleaning Messy Data - Use text, date and conditional functions to clean real-world data, and learn where MySQL and PostgreSQL syntax differ.
- Text Functions: Trim, Replace, Concat and Substring
- Working With Dates and Times
- CASE WHEN: Adding Business Rules to Queries
- Type Casting and Cleaning Messy Columns
- MySQL vs PostgreSQL: Syntax Differences That Bite
- Aggregation, GROUP BY and KPI Reports - Summarise thousands of rows into business numbers with COUNT, SUM, AVG, GROUP BY and HAVING, and build a monthly KPI report.
- COUNT, SUM, AVG, MIN and MAX on Business Data
- GROUP BY: Totals by City, Product and Month
- HAVING vs WHERE: Filtering Rows and Groups
- Building a Monthly KPI Report in SQL
- Joins: Combining Multiple Tables - Connect orders, customers and products with INNER, LEFT, RIGHT, self and cross joins, and avoid the traps that duplicate or drop rows.
- Primary Keys, Foreign Keys and Table Relationships
- INNER JOIN: Matching Rows Across Tables
- LEFT and RIGHT JOIN: Keeping Unmatched Rows
- Joining Three or More Tables
- SELF JOIN and CROSS JOIN in Practice
- Join Traps: Duplicates, Lost Rows and Wrong Totals
- Subqueries and CTEs - Break hard questions into steps using scalar, correlated and nested subqueries, then rewrite them as readable chained CTEs.
- Scalar Subqueries: One Answer Inside a Query
- Subqueries in WHERE, IN, EXISTS and FROM
- Correlated Subqueries: Row-by-Row Questions
- CTEs: Writing Readable Step-by-Step Queries
- Chaining CTEs to Solve Multi-Step Problems
- Window Functions for Analytics - Rank, compare and trend your data without losing rows, using OVER, PARTITION BY, ROW_NUMBER, RANK, LAG, LEAD and running totals.
- OVER and PARTITION BY: Calculations Without Collapsing Rows
- ROW_NUMBER, RANK and DENSE_RANK
- LAG and LEAD: Comparing With Previous and Next Rows
- Running Totals and Moving Averages
- NTILE and Top-N Per Group
- Stored Procedures, Views and Data Extraction - Change data safely, save queries as views, automate reports with stored procedures, speed queries with indexes and extract data for Power BI.
- INSERT, UPDATE, DELETE and Transactions Safely
- Views: Saving Queries for Reuse
- Stored Procedures: Your First Automated Report
- Procedure Parameters and Simple Logic
- Indexes and Reading Query Plans
- Extracting Data to CSV and Power BI
- Capstone: End-to-End Analyst Project and Interview Prep - Analyse a full retail database from raw tables to a business summary, then prepare for SQL interviews with timed practice and portfolio-ready work.
- Capstone Brief: Reading the Schema and Planning
- Answering Business Questions With Joins and Aggregates
- Advanced Analysis With CTEs and Window Functions
- Turning Query Results Into a Business Summary
- SQL Interview Prep: Common Questions and Timed Practice
Frequently asked questions
How long is the SQL for Data Analysis course?
It runs for 8 weeks. It is self-paced online learning from EasySkill Career Academy, Surat.
How much does the SQL for Data Analysis course cost?
The fee is Rs 15,999, or about Rs 2,666 a month on EMI.
What will I build in SQL for Data Analysis?
Every module ends in a graded practical task that AI checks in about 30 seconds, so you finish with a portfolio you can show to employers or clients.
Which roles does SQL for Data Analysis prepare me for?
It prepares you to apply for roles such as Data Analyst, Junior Data Analyst, Database Analyst, Business Intelligence Analyst, SQL Developer. It does not guarantee a job or income.
Can I learn online, or do I have to visit a centre?
You can learn fully online. EasySkill also has centres in Adajan, Vesu and Bhestan, Surat, if you prefer to visit.
All career tracks