History and features of TSQL Types of TSQL commands Data definition language (DDL) Data manipulation language (DML) Data query language (DQL) Database Creating database Altering database Deleting database Constraints Primary key and referential integrity or foreign key constraints Data types in TSQL Table Creating table Altering table Deleting table ERD – entity relationship diagram

What are Facts Multi Dimensional Model Hierarchies OLAP MOLAP ROLAP HOLAP Cubes and its Functions Star Schema Fact Table Dimensional Tables Snow flake Schema Fact less Fact Table Confirmed Dimensions

Forward Engineering Reverse Engineering Update Model, Alter database Complete compare

Inner join Outer join Left outer join Right outer join Full outer join Cross join

Clustered index NonClustered index Create, alter and drop indexes Using indexes Execution plan – seek, scan

Purpose of views Creating, altering and dropping indexes Encryption and schema binding options in creating views

Forward Engineering Reverse Engineering Update Model, Alter database Complete compare

Creating, altering and dropping Optional parameters Input and output parameters

Purpose of triggers Differences between stored procedures and user defined functions and triggers Creating, altering and dropping triggers After triggers Instead of triggers

Microsoft SQL Server Training in Chennai | Microsoft SQL Server Course in Chennai

MsSql Server Training

SQL Server Training furnishes students with the knowledge and skills to design and develop the SQL Server database. The course focuses on the primary features and tools of SQL Server for developing a database. You’ll understand how to alter tables using T-SQL and work with SELECT statements, SQL queries, indexes, triggers, transaction types, and more. This course includes all the topics you need to master to advance your development skills and clear the SQL Server certification exam.

Syllabus

Introduction To SQL Server

Connecting to server
SQL server management studio and tools in management studio
Object explorer
Object explorer details
Query editor

TSQL (Transact-Structured Query Language)

Connecting to server
SQL server management studio and tools in management studio
Object explorer
Object explorer details
Query editor

Introduction to TSQL

History and features of TSQL
Types of TSQL commands
Data definition language (DDL)
Data manipulation language (DML)
Data query language (DQL)
Database
Creating database
Altering database
Deleting database
Constraints
Primary key and referential integrity or foreign key constraints
Data types in TSQL
Table
Creating table
Altering table
Deleting table
ERD – entity relationship diagram

Data Manipulation Language

Integration Layer
Staging Area
Targets
Analysis & Reporting
HPQS
Introduction

Data Query Language (DQL)

Different Phases of ModellIng
What Is a Dimension

Top n Clause

What are Facts
Multi Dimensional Model
Hierarchies
OLAP
MOLAP
ROLAP
HOLAP
Cubes and its Functions
Star Schema
Fact Table
Dimensional Tables
Snow flake Schema
Fact less Fact Table
Confirmed Dimensions

SQL Operators

Forward Engineering
Reverse Engineering
Update Model, Alter database
Complete compare

Built-In Functions

Forward Engineering
Reverse Engineering
Update Model, Alter database
Complete compare

Sub Queries

Set Operators

Union
Intersect
Except

Joins

Inner join
Outer join
Left outer join
Right outer join
Full outer join
Cross join

Indexes

Clustered index
NonClustered index
Create, alter and drop indexes
Using indexes
Execution plan – seek, scan

Views

Purpose of views
Creating, altering and dropping indexes
Encryption and schema binding options in creating views

TSQL Programming

Forward Engineering
Reverse Engineering
Update Model, Alter database
Complete compare

Cursors

Stored Procedures

Creating, altering and dropping
Optional parameters
Input and output parameters

User Defined Functions

Creating, altering and dropping
Types of user defined functions
Scalar functions
Table valued functions
Inline table valued functions
Multi statement table valued functions
Permissions on user defined functions

Triggers

Purpose of triggers
Differences between stored procedures and user defined functions and triggers
Creating, altering and dropping triggers
After triggers
Instead of triggers

Practice Test and Interview Questions

Qmatrix Technologies offers advanced SQL Server interview questions and answers along with SQL Server resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.