SQL Training

Sql Server / PL SQL

Module 1

• SQL Server Architecture — RDBMS concepts, SQL Server versions, system databases
• Management Studio (SSMS) — navigation, query editor, messages, execution plan basics
• Databases & Tables — creation, structure, understanding in-built databases

Module 2

• Retrieving Data — SELECT fundamentals, order of operations
• Removing duplicates using DISTINCT
• Column & Table Aliases
• CASE expressions
• ORDER BY / GROUP BY usage

Module 3

• Sorting techniques
• Filtering data using predicates (WHERE)
• TOP, OFFSET–FETCH for pagination
• Handling NULL and unknown values

Module 4

• Aggregate functions — SUM, COUNT, AVG, MIN, MAX
• GROUP BY for summarisation
• Filtering groups using HAVING

Module 5

• SQL Server Data Types overview
• Working with character data
• Working with date & time data

Module 6

• Creating tables
• Altering tables — add/modify columns
• Data type increase/decrease
• Simple insert & column-specific insert
• Bulk insert & best practices

Module 7

• NOT NULL, DEFAULT, UNIQUE constraints
• Primary & Foreign Keys
• Index concepts
• Relationship integrity & cascading rules

Module 8

• Inner, Left, Right, Full Outer Joins
• Cross join & Self join
• Anti join (NOT EXISTS) & Semi join (EXISTS)

Module 9

• Understanding SQL Views
• Creating views with filters & joins
• Views vs Tables

Module 10

• String functions — LEFT, RIGHT, LENGTH, LOCATE
• LOWER/UPPER, FORMAT, CONCAT functions

Module 11

• Date functions — DATE_ADD, CURRENT_DATE, CURRENT_TIME
• Datediff, DATE_FORMAT
• DAYOFWEEK, MONTH, YEAR, LAST_DAY
• EXTRACT function

Module 12 — Programming with T-SQL / PL-SQL

• Variables — declaring, assigning values
• T-SQL batch execution, delimiters
• IF…ELSE, CASE expressions
• WHILE loops & control-flow logic
• Dynamic SQL — using variables inside SQL blocks
• Exception handling basics

Module 13 — Stored Procedures

• Creating stored procedures
• Types of procedures
• Input / Output parameters
• Executing & managing stored procedures

Module 14 — Triggers & Cursors

• DML triggers — INSERT/UPDATE/DELETE
• DDL triggers
• Working with cursors
• Replacing cursors using temp tables, CTEs

Module 15 — Transactions

• ACID Properties
• Begin, Commit, Rollback
• Real-time transaction scenarios

Module 16 — Data Analyst Advanced SQL

• Window Functions — ROW_NUMBER, RANK, DENSE_RANK
• LAG, LEAD, NTILE
• Running totals & moving averages
• Grouping Sets, Rollup, Cube
• Analytical queries for BI dashboards

Module 17 — PL/SQL for Analysts (Oracle / procedural SQL)

• PL/SQL blocks — DECLARE, BEGIN, EXCEPTION, END
• Functions & procedures in PL/SQL
• Packages — specification & body
• PL/SQL triggers
• Collections — VARRAY, nested tables
• BULK COLLECT & FORALL for high-performance processing

Module 18 — Practical Data Analyst Workflows

• Data cleaning & preprocessing
• Handling NULLs, outliers, type conversions
• Joins for reporting, KPI calculations
• Building SQL datasets for Power BI / Tableau
• Performance tuning — indexing, statistics, execution plans

Module 19 — Project + Interview Prep

• Case studies with real-time datasets
• End-to-end analytics project
• SQL + PL/SQL interview questions
• Training certificate