Advanced SQL |

Advanced SQL Server

Synopsis

This SQL Server training course concentrates on providing solid working knowledge and efficient coaching on Advanced SQL and gives an in-depth knowledge of writing SQL scripts and managing databases using Dynamic SQL. It also covers concepts of performance tuning and optimization to reduce query cost along with detailed sessions on Partition Table and Partition Views.

Prerequisites

Basic knowledge and understanding on SQL statements.

Exercises

This course is instructor-led. Regular assignments and questionnaire on Dynamic SQL are given for effective learning. The final chapter includes a real-world example using Dynamic SQL.

Approach

All contents in this course is aimed at making you a pro SQL Developer.

Day 1

Triggers

Table Level
Database Level
Server Level

Day 2

Using Audit in SQL Server
Sequence
CTE’s
Recursive CTE’s
Understanding of Pivot

Day 3

Table Partition

Partition Function
Partition Scheme

Partition Views

Bulk Insertions

Day 4

Introduction to Change Tracking in SQL Server.
Encryption in SQL Server

Day 5

Using Dynamic SQL with Examples
Guard against SQL injection

Day 6

Performance Tuning and Optimizations in SQL Server
Display Options of Execution Plans
Clustered Index
Non-Clustered Index

Day 7

Indexing method
Seek v/s Scan, Include Columns

Day 8

System Functions used to Enhance Performance query.
IN v/s EXISTS v/s INNER JOIN

Day 9/10

Introduction to Dynamic SQL
Writing Scripts in Dynamic SQL
Using Exec and Sp_executesql
Working with Parameters in Sp_executesql

Day 12/13

Project in Dynamic SQL

 4.5/5

Submit your review
Name:
Email:
Rating:	1 2 3 4 5
Review:

Check this box to confirm you are human.
Submit Cancel