TrainingRite.
Enquire Now

Data & Analytics · Online training

SQL Training

Querying, joins, aggregations, window functions, subqueries and performance-aware SQL.

Level: Beginner to AdvancedDelivery: Online8 modules

Who should attend

Data analysts, BI developers, QA professionals, application developers and database users.

Prerequisites

Basic computer literacy. The course can start from SQL fundamentals.

Learning outcomes

  • Create and query relational database objects.
  • Write joins, aggregations, subqueries and CTEs.
  • Use window functions for analytical queries.
  • Modify data and understand transaction behaviour.
  • Analyse query plans and apply basic performance techniques.
  • Solve practical reporting and data-analysis problems.

Detailed curriculum

8 modules
01Relational database and SQL basics
  • RDBMS, schema, table, row, column and data types
  • Keys, constraints and relationships
  • SQL command groups: DDL, DML, DQL, DCL and TCL
  • SELECT, aliases, expressions and DISTINCT
  • NULL semantics and basic operators
02Filtering, sorting and functions
  • WHERE, AND, OR, NOT, IN, BETWEEN and LIKE
  • ORDER BY and limiting result sets
  • String, numeric and date/time functions
  • CASE expressions and conditional logic
  • Type conversion, NULL handling and COALESCE
03Joins and set operations
  • INNER, LEFT, RIGHT and FULL joins
  • Self joins and multi-table joins
  • UNION and UNION ALL
  • EXCEPT/MINUS and INTERSECT where supported
  • Finding unmatched records and avoiding duplicate multiplication
04Aggregation and subqueries
  • COUNT, SUM, AVG, MIN and MAX
  • GROUP BY and HAVING
  • Single-row and multi-row subqueries
  • Correlated subqueries and EXISTS
  • Common Table Expressions and recursive CTE concepts
05Advanced SQL and analytics
  • ROW_NUMBER, RANK, DENSE_RANK and NTILE
  • LEAD, LAG and running totals
  • Window frames and partitioning
  • Pivoting/unpivoting concepts (engine dependent)
  • Date-series, cohort and trend analysis examples
06Data definition and manipulation
  • CREATE, ALTER, DROP and TRUNCATE
  • INSERT, UPDATE, DELETE and MERGE/upsert concepts
  • Views, temporary tables and common table expressions
  • Stored procedures, functions and triggers overview
  • Transactions, COMMIT, ROLLBACK and ACID
07Performance and database programming
  • Indexes and selectivity basics
  • Execution plans and identifying expensive operations
  • Sargability and query-writing hygiene
  • Statistics, partitioning and indexing trade-offs
  • Parameterised queries and SQL injection prevention
08Practical analytics project
  • Translate business questions into SQL queries
  • Build sales, customer and operational reports
  • Validate data quality and reconcile totals
  • Create reusable views or query scripts
  • Explain query results and performance considerations

How you will practise

Learn through instructor-led sessions using realistic, live applications. Then apply each concept through guided assignments on a separate hands-on practice application, with feedback to help you build practical skills and confidence.

Practical exercises and labs

  • Solve progressively harder SQL exercises across related tables.
  • Build monthly sales, customer retention and product performance queries.
  • Use window functions to rank products and calculate running totals.
  • Inspect execution plans and improve selected slow queries.

Capstone project

Develop a SQL analytics pack for a sample retail dataset: schema review, data-quality checks, business KPI queries, window-function analysis, reusable views and query optimisation notes.

Tools and technologies

One primary SQL engine must be selected for each batch (SQL Server, PostgreSQL, MySQL or Oracle). Syntax differences should be called out.

Assessment approach

  • Module-wise knowledge checks or short practical tasks.
  • Hands-on exercise review using an agreed checklist or rubric.
  • Final project demonstration and explanation of design decisions, test evidence or outputs, as applicable.
  • Completion criteria, attendance requirements and any certificate conditions must be separately approved and published by TrainingRite.

Schedule and fees

Upcoming batch schedules are shared by our TrainingRite team. Please submit an enquiry and our team will contact you by email or phone with the latest schedule. TrainingRite does not publish course fees or discounts on the website. Our counselling team will share the applicable course fee and other details with you by email or phone after you submit an enquiry.

Frequently asked questions

Who should join this course?

Data analysts, BI developers, QA professionals, application developers and database users.

Do I need prior experience?

Basic computer literacy. The course can start from SQL fundamentals.

Is the training online?

TrainingRite programmes are delivered online.

Will I get hands-on practice?

Sessions are instructor-led and use realistic applications. You then apply each concept through guided assignments on a separate practice application.

How can I enquire about fees and the next batch?

Fees and batch schedules are not published on the website. Submit the enquiry form on this page and our counselling team will share them with you by email or phone.

Related courses