preloader

khansqlserver@gmail.com

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
1
2
3
4
5
Submit
     
Cancel

Create your own review

Average rating:  
 0 reviews