Data & Analytics
SQLBasic to Advanced
Query, analyse and manage data with SQL — the most in-demand skill across data and software roles.
Course overview
SQL is the language of data. Developers, analysts, data engineers and business teams all rely on it to retrieve and analyse information stored in databases.
Starting with simple queries, you will progress through joins, aggregations, subqueries, CTEs and window functions, and learn how databases are designed — using realistic business datasets.
Who is this course for?
- Students interested in data analytics or data engineering
- Developers who work with databases
- Business professionals who need to analyse data
Prerequisites
- No prior experience required
What you will learn
- Filter, sort and query data with SELECT
- Summarise data with GROUP BY and aggregates
- Combine tables with joins
- Write subqueries, CTEs and window functions
- Modify data and use constraints and indexes
- Design normalised database schemas
Module structure
01Database Basics
- Tables, rows and keys
- SELECT, WHERE, ORDER BY
- Filtering and sorting
02Aggregation
- GROUP BY and HAVING
- Aggregate functions
- Business reporting queries
03Joins
- Inner and outer joins
- Self joins
- Combining multiple tables
04Advanced Queries
- Subqueries
- Common Table Expressions (CTEs)
- Window functions
05Data Management
- INSERT, UPDATE, DELETE
- Constraints and indexes
- Views
06Database Design
- Normalisation
- ER modelling
- Case-study analysis
Module sequence and depth may be tailored to the batch level. Detailed syllabus available on enquiry.
Hands-on learning
- Querying realistic business datasets
- Report-building exercises
- Schema design exercise
- Interview-style SQL problems
Tools & technologies
- MySQL / PostgreSQL
- SQL Server basics
- DBeaver or equivalent client
Learning outcomes
01
Write accurate queries to answer business questions
02
Use joins, CTEs and window functions confidently
03
Design simple, well-structured databases
04
Tackle SQL interview questions
Duration, mode, batches & certificate
Duration
Shared on enquiry
Current batch schedule shared on enquiry.
Training mode
Online / Offline / Hybrid
Availability varies by batch.
Batches
Weekday & Weekend
Choose weekday or weekend (Sat & Sun) classes.
Certificate
Completion certificate
Issued on completing programme requirements.
FAQ
SQL — FAQs
What is the batch size for SQL?
Batches are kept small, so each learner gets focused guidance and time for questions.
Will I receive a certificate?
Yes. Learners who complete the programme requirements receive a verifiable course completion certificate from Sarng Infotech.
What is the duration and fee?
Batch schedules and fees are shared on enquiry, as they depend on the mode and batch you choose. Send us an enquiry and our team will share the current details.
