Microsoft SQL Server Training Course

annexit

0 (No Review)

No student enrolled

Course Duration

10 week

About AnnexIT

AnnexIT is a leading e-learning platform providing live instructor-led interactive online training. We

cater to professionals and students across the globe in categories like Big Data & Hadoop, Business

Analytics, NoSQL Databases, Java & Mobile Technologies, System Engineering, Project Management

and Programming. We have an easy and affordable learning solution that is accessible to millions of

learners across the globe.

Course Description

Duration: 25-30 hours

Type: Online Training

Includes: Course Material

Microsoft SQL Server is a relational database server, developed by Microsoft, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network.

Training by Realtime Expert trainer
Live Online Classes
Free study material
Online virtual Classes available in morning, evening and weekend

Prerequisites

Attendees must have basic computer knowledge.

Microsoft SQL Server Course Curriculum

What’s New in SQL Server?
SQL Server Editions
Installing SQL Server

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

What is T-SQL?
Syntax Conventions
Introducing AdventureWorks2008
Executing SQL Statements
Identifiers
Creating Data Types
Operators
Variables
Functions
Using T-SQL to Build and Alter Objects

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

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

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

Using Views
Using Stored Procedures
Using Functions

Transactions
Rowset Functions
Ranking Functions
Cursors
Structured Error Handling

XML Columns and Indexes
Querying and Modifying XML Data
Using OPENXML
Using FOR XML

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

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

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

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

annexit

0.00 average based on 0 ratings

5 Star

4 Star

3 Star

2 Star

1 Star

Course Features

Duration 60h
Max Students Unlimited
Certificate Yes
Skill Advance
Category Database