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

