SQL
Learn SQL from the ground up—master the language used to manage and query relational databases. Ideal for beginners and those looking to enhance their data skills with practical, real-world examples.
Key Highlights:
✅ Introduction to Databases and SQL
✅ Understanding Data Types and Table Structures
✅ Writing Basic to Complex SQL Queries
✅ Filtering, Sorting, and Joining Data
✅ Aggregation Functions and Grouping Data
✅ Subqueries and Nested Queries
✅ Data Manipulation: INSERT, UPDATE, DELETE
✅ Indexing and Query Optimization Techniques
✅ SQL Functions and Stored Procedures
✅ Real-life SQL Scenarios and Use Cases
✅ Hands-on Exercises and Mini Projects
Training Content
Module 1: SQL Introduction
o SQL Architecture
o Basic components
o Introduction to System database
o MASTER, MODEL, TEMP,MSDB
o Using DDL, &DML Statements
o CREATE
o ALTER
o DROP
o TRUNCATE
o INSERT
o UPDATE
o DELETE
o SQL Datatypes
o Varchar, Varchar(2)
o Smallint, Int, Bigint
o Numeric, Money, Float
o Date, Time, Datetime
o Basic SQL Query Writing
o Retrieving data using SELECT
o Applying Filters
o Removing Duplicates
o Retrieve TOP N records
Module 2: SQL Clauses
o Order By, Group By & Having usage inside queries
o Union vs Union All
o Case, Like, INTO
Module 3: Joins
o Introduction to JOINS
o Left Join, Right Join, Inner join
o Full Join
o Cross Join
o Self-Join
Module 4: Subqueries, CTE & TEMP Tables
o Creating Sub queries
o Learning when to use Sub queries
o Creating Local & Global temporary tables
o Difference between Local& Global temporary tables
o Working with Common Table Expressions (CTE)
Module 5: Stored Procedures
o Introduction to Stored Procedure
o Creating Stored Procedure
o Debugging Stored Procedure
Module 6: Functions
o Introduction to functions
o Learning about system functions
o Create User Defined functions
o Create and User Table Valued function
o Aggregate Functions
Module 7: Performance Tuning
o Identifying the blocks for performance
o Fine tuning blocking queries
o Introduction to Execution Plan (Actual and Estimated)
o Rewrite the blocking queries to improve the performance.
Module 7: SQL Server Agent
Introduction to SQL Server Agent
o Creation of Jobs to schedule
