SQL Server Training

Share course

SQL Server Course Content
Introduction To DBMS

File Management System And Its Drawbacks
Database Management System (DBMS) and Data Models
Physical Data Models
Logical Data Models
Hierarchical Data Model (HDBMS)
Network Data Model (NDBMS)
Relational Data Model (RDBMS)
Object Data Model (ODBMS)
Object Relational Data Model (ORDBMS)
Conceptual Data Models
Entity – Relationship (E-R) Model

Introduction To SQL Server

Connecting To Server
Server Type
Server Name
Authentication Modes
Sql Server Authentication Mode
Windows Authentication Mode
Login and Password
Sql Server 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
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
Creating Table
Altering Table
Deleting Table

Data Manipulation Language

Creating A Table From Another Table
Inserting Rows From One Table To Another
Computed Columns
Differences Between Delete and Truncate

Data Query Language (DQL)

Where clause
Order By Clause
Distinct Keyword
Isnull() function
Column aliases
Between … And
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)

Set Operators

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
Any or Some
Nested Sub Queries
Co-Related Sub Queries
Exists and Not Exists


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


Purpose Of Views
Creating , Altering and Dropping Indexes
Simple and Complex Views
Encryption and Schema Binding

Transaction Management

Begin Transaction
Commit Transaction
Rollback Transaction
Save Transaction
Role Of Log File In Transaction Management
Implicit Transactions

TSQL Programming

Introduction To TSQL Programming
Control statements In TSQL Programming
Conditional Control Statements
Looping Control Statements


Working With Cursors
Types Of Cursors
Forward_Only and Scroll Cursors
Static, Dynamic and Keyset Cursors
Local and Global Cursors

Stored Sub Programs

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
Purpose of Triggers
Differences Between Stored Procedures
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 
Raising Exceptions Manual

CLR Integration

Steps For Implementing It
A Simple Example With CLR Integration

Working With XML Data Type
Backup and Restore Of Database
Attach and Detach of Database




Key Highlights

  • PSN Trainings is a leading online training provider across the globe. Our online training team is highly qualified, experienced and skilled with real time  industry experience.

PSN Trainings Highlights:

  • Instructor Led Online Courses  with 24x7 On-Demand Support
  • World Class Trainers with +12 years Industry Experience. Instructors are not just trainers they are Consultants
  • We provide  24/7 Server access to help our trainees practice exercises
  • Teaching Material Prepared by Experts from PSN Trainings who have real time experience
  • Hands on Lab Assignments
  • 100% Placement Assistance
  • Project Based learning to get hands-on experience on a real life application!
  • Providing high quality interactive and cost effective online Training
  • Live Interactive classes by industry experts.

Trainer Information:

  • Having 8  years of  IT Industry Experience
  • 6  years  of SQL Server Real Time Experience
  • Having  3 yrs experience  as an online trainer for OBIEE
  • Held up to 60+ batches in past 3 Years
  • Trainer has an excellent practical & industrial knowledge