T-SQL Training

T – SQL DATABASE TRAINING PROGRAMME

​

I. Introduction to t-SQL

A. Overview of t-SQL and its role in relational databases

B. Understanding the SQL Server environment

C. Exploring t-SQL data types and variables

 

II. Retrieving Data with SELECT Statements

A. Basic SELECT statement syntax

B. Filtering data with WHERE and comparison operators

C. Sorting and ordering data with ORDER BY

D. Limiting and paging data with TOP and OFFSET-FETCH

E. Using DISTINCT and GROUP BY for aggregating data

 

III. Working with Multiple Tables

A. Introduction to table joins (INNER JOIN, LEFT JOIN, RIGHT JOIN)

B. Using aliases for table and column names

C. Combining data with UNION and UNION ALL

D. Performing subqueries for complex queries

 

IV. Manipulating Data with DML Statements

A. Inserting data into tables

B. Updating and deleting data

C. Using transactions for data integrity

D. Understanding the MERGE statement for data synchronization

 

V. Working with Functions

A. Introduction to built-in functions (e.g., string functions, mathematical functions)

B. Using aggregate functions (e.g., SUM, COUNT, AVG)

C. Creating user-defined functions

D. Working with scalar and table-valued functions

 

VI. Advanced Querying Techniques

A. Using conditional logic with CASE expressions

B. Handling NULL values with ISNULL and COALESCE

C. Implementing logical operators (AND, OR, NOT)

D. Pattern matching with LIKE and wildcard characters

 

VII. Modifying Table Structures

A. Creating and altering tables

B. Defining constraints (e.g., primary key, foreign key)

C. Adding and modifying columns

D. Creating and managing indexes for performance optimization

 

VIII. Stored Procedures and Views

A. Creating and executing stored procedures

B. Passing parameters to stored procedures

C. Working with views for data abstraction and security

D. Modifying and dropping stored procedures and views

 

IX. Working with Triggers

A. Understanding triggers and their types

B. Creating and managing DML triggers

C. Using INSTEAD OF triggers for data manipulation

D. Handling trigger-related issues and considerations

 

X. Query Optimization and Performance Tuning

A. Analyzing query execution plans

B. Optimizing queries for performance

C. Indexing strategies and best practices

D. Identifying and resolving performance bottlenecks

 

XI. Error Handling and Debugging

A. Implementing error handling with TRY-CATCH blocks

B. Raising and handling custom errors

C. Logging and troubleshooting errors

D. Using debugging tools and techniques