MS SQL 2014/2016 Training

Table of Content

Introducing SQL Server 2014/2016
• What's New in SQL Server?
• SQL Server Editions
• Installing SQL Server

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 AdventureWorks2014
• Executing SQL Statements
• Identifiers
• Creating Data Types
• Operators
• Variables
• Functions
• Using T-SQL to Build and Alter Objects

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

Advanced Transact-SQL
• Transactions
• Rowset Functions
• Ranking Functions
• Cursors
• Structured Error Handling

XML and SQL Server
• XML Columns and Indexes
• Querying and Modifying XML Data
• Using OPENXML
• Using FOR XML

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

.NET inside of SQL Server
• Creating CLR User-Defined Functions
• Creating CLR Stored Procedures
• Using the Sql Namespace
• Creating CLR Triggers
• Creating CLR User-Defined Types
• Choosing When To Use CLR Objects

SMO and RMO Programming
• Retrieving Server Information
• Working With Database Objects
• Generating Scripts
• Viewing and Modifying Server Configuration
• Understanding RMO

Data Protection/Tracking
• Understanding Change Data Capture
• Data Capture Schema and Tables
• Transparent Data Encryption

Contact Us

We are always here to guide you...

Quick Enquiry

Please enter name.
Please enter name.
Please enter valid email adress.
Please enter Course name.
Please enter your comment.

sitcomputerairoli@gmail.com

+91 9619 3417 13

+91 7506 4114 34

Website : www.sitcomputer.in

We Are Social