MS SQL Server Course And Training

 

About this course

Introduction To SQL Server

  • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2

  • Connecting To Server

  • Server Type

  • Server Name

  • Authentication Modes

  • Sql Server Authentication Mode

  • Windows Authentication Mode

  • Sql Server Management Studio and Tools In Management Studio

  • Object Explorer

  • Object Explorer Details

  • Query Editor

 

TSQL (Transact Structured Query Language)

  • Introduction To TSQL

  • History and Features of TSQL

  • Types Of TSQL Commands

  • Data Definition Language (DDL)

  • Data Manipulation Language (DML)

  • Data Query Language (DQL)

  • Data Control Language (DCL)

  • Transaction Control Language (TCL)

  • Creating Database

  • Altering Database

  • Deleting Database

  • Constrains

  • Procedural Integrity Constraints

  • Declarative Integrity Constraints

  • Not Null, Unique, Default and Check constraints

  • Primary Key and Referential Integrity or foreign key constraints

  • Data Types In TSQL

  • Table

  • Creating Table

  • Altering Table

  • Deleting Table

  • Data Manipulation Language

  • Insert

  • Identity

  • Creating A Table From Another Table

  • Inserting Rows From One Table To Another

  • Update

  • Computed Columns

  • Delete

  • Truncate

  • Differences Between Delete and Truncate

  • Data Query Language (DQL)

  • Select

  • Where clause

  • Order By Clause

  • Distinct Keyword

  • Isnull() function

  • Column aliases

  • Predicates

  • Between … And

  • In

  • Like

  • Is Null

  • Built In Functions

  • Scalar Functions

  • Numeric Functions

  • Character Functions

  • Conversion Functions

  • Date Functions

  • Aggregate Functions

  • Convenient Aggregate Functions

  • Statistical Aggregate Functions

  • Group By and Having Clauses

  • Super Aggregates

  • Over(partition by …) Clause

  • Ranking Functions

  • Common Table Expressions (CTE)

  • Top n Clause

  • Set Operators

  • Union

  • Intersect

  • Except

  • Joins

  • Inner Join

  • Equi Join

  • Natural Join

  • Non-Equi Join

  • Self Join

  • Outer Join

  • Left Outer Join

  • Right Outer Join

  • Full Outer Join

  • Cross Join

  • Sub Queries

  • Single Row Sub Queries

  • Multi Row Sub Queries

  • Nested Sub Queries

  • Co-Related Sub Queries

  • Exists and Not Exists

  • Control statements In TSQL Programming

  • Conditional Control Statements

  • If

  • Case

  • Looping Control Statements

  • While

 

Indexes

  • Clustered Index

  • NonClustered Index

  • Create , Alter and Drop Indexes

  • Using Indexes

 

Login Creation

  • SQL Server Authenticated Login

  • Windows Authenticated Login

  • User Creation

  • Granting Permissions

  • Revoking Permissions

  • Roles​

 

Views

  • Purpose Of Views

  • Creating , Altering and Dropping Indexes

  • Simple and Complex Views

  • Encryption and Schema Binding Options in creating views

    

Transaction Management

  • Introduction

  • Begin Transaction

  • Commit Transaction

  • Rollback Transaction

  • Save Transaction

  • Role Of Log File In Transaction Management

  • Implicit Transactions

  

Cursors

  • Working With Cursors

  • Types Of Cursors

  • Forward_Only and Scroll Cursors

  • Static, Dynamic and Keyset Cursors

  • Local and Global Cursors

  

Stored Sub Programs

  • Advantages Of Stored Sub Programs compared to Independent SQL Statements

  • Stored Procedures

  • Creating , Altering and Dropping

  • Optional Parameters

  • Input and Output Parameters

  • Permissions on Stored Procedures

  • 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

  • Magic Tables

  • Instead Of Triggers

  • Exception Handling

  • Implementing Exception Handling

  • Adding and removing User Defined Error Messages To And From SQL Server Error Messages List​

 

Raising Exceptions Manua

Course Details
  • Duration: 

  • hours effort:  hours per week

  • Price With GST: 11800/-

  • Subject:

  • Level: beginner

Prerequisites

Marathahalli Office:

Real Time Signals Technologies Private Limited

#102, Krishna Grand, Over Marathahalli Bridge,

Bangalore, Karnataka, India 560037

BTM office:

Real Time Signals Technologies Private Limited,

#4, 2nd Floor, 1st phase, 2nd Stage, BTM Layout,

Opposite to Udupi Garden,

Bangalore-76, bengaluru, Karnataka, 560076

Whitefield office:

Real Time Signals Technologies Private Limited,

#1906, Brigade Metropolis,

Mahadevpura,

Bengaluru, Karnataka, 560048

Belgium Europe office:

Real Time Signals Technologies,

Hemelstraat 42, 2018 Antwerpen

Belgium, Europe

Thane Office:

Real Time Signals Technologies Private Limited,

#202, GARDEN ENCLAVES BLDG NO1,

VASANT VIHAR,

THANE 400607, MAHARASHTRA, India 

 

 © 2014-2018 by Real Time Signals Technologies. All Rights Reserved.