Warning: DOMDocument::loadXML(): Start tag expected, '<' not found in Entity, line: 1 in /home/sitctrai/public_html/sqldbaonlinetraining/wp-content/plugins/premium-seo-pack/modules/title_meta_format/init.social.php on line 483
Contact Us :info@spectoittraining.com, India :+91-9533456356,USA :+1-847-787-7647

Transact SQL Online Training

Transact SQL Online Training Course Content 

Basics of Database Design

  • Normalization
  • Denormalization
  • Tools for Normalization in SQL Server
  • Introducing SQL Server Management Studio
  • Creating a Database
  • Adding Tables
  • Creating Indexes and Constraints
  • Building Relations

T-SQL Basics

  • What is T-SQL?
  • Syntax Conventions
  • Introducing AdventureWorks2012
  • Executing SQL Statements
  • Identifiers
  • Creating Data Types
  • Operators
  • Variables
  • Functions

SELECT Queries

  • The SELECT Clause
  • The FROM Clause
  • The WHERE Clause
  • The ORDER BY Clause
  • Using GROUP BY and HAVING
  • Using TOP N and TOP N PERCENT
  • UNION Queries
  • Full-Text Search

Action queries

  • SELECT INTO queries
  • DELETE queries
  • TRUNCATE TABLE queries
  • INSERT queries
  • UPDATE queries
  • MERGE queries

Locking and Execution Plans

  • What is Locking?
  • Monitoring Locks
  • Tuning Locking
  • Deadlocks
  • Tuning Queries
  • Management Data Warehouse
  • Performance Studio

Views, Stored Procedures, and Functions

  • Using Views
  • Using Stored Procedures
  • Using Functions

Triggers

  • Creating DML Triggers
  • Altering DML Triggers
  • Using the Inserted and Deleted Tables
  • Checking Updated Columns
  • Recursive and Nested Triggers
  • Creating DDL Triggers

Data Protection/Tracking

  • Understanding Change Data Capture
  • Data Capture Schema and Tables
  • Transparent Data Encryption

Security and SQL Server

  • Choosing Service Accounts
  • Authentication Modes
  • Roles and Users
  • Permissions
  • Object Ownership