SQL Server Online Training

Course Content

Database Concepts

• Introduction to Database
  
• Data Models
  
• Acid Properties
  
• Database Terms
  
• Advantages and importance of Database
  

SQL Server Introduction

• Introduction to SQL Server
  
• History of SQL Server
  
• Versions of SQL Server
  
• SQL Server Components
  
• Different Editions of SQL Server
  

SSMS

• What is SSMS(SQL Server Management Studio)
  
• How to connect to SQL Server using SSMS
  
• SSMS components
  
• SQL commands categories
  

SQL Commands

• DDL
  
• DML
  
• DCL
  
• TCL and DQL
  

Database

• Introduction to Database
  
• Creating a Database
  
• Understanding System Database
  
• Manipulating database ( using Window and Commands)

DDL Commands

• Data types
  
• Creating Table
  
• Renaming a Table
  
• Alter a table
  
• Drop a Table
  
• Truncate Table
  
• Identity Column

Constraint

• Introduction to Constraint
  
• Types of Constraints
  
• Row/Table Level Constraint
  
• Adding and Dropping Constraints
  
• Enable/Disable Constraints
  
• Example
  

DML Commands

• INSERT INTO
  
• DELETE and UPDATE commands
  

SQL Select [DQL]

• Select Statement
  
• Clauses (TOP, DISTINCT, ORDER BY, WHERE)
  

Operators

• SQL Operators
  
• Set Operators

Aggregate Functions

• Usage
  
• GROUP BY
  
• HAVING
  
• clauase

Single Row Functions

• Different types with examples
  

Sub Queries

• Advantage
  
• Syntax
  
• Types of Sub Queries
  
• Single Row and Multi row sub queries
  

Joins

• Advantages
  
• Syntax
  
• Keywords
  
• Example
  
• Types of Joins
  
• Implementation
  

Views

• Introduction
  
• Table vs View
  
• Simple and Complex views
  

Indexes

• Introduction
  
• Architecture
  
• Table Scan
  
• Using Index
  
• Clustered and Non-clustered Index
  

TCL

• Transaction Control Language
  
• ACID Test
  
• Using Commit
  
• Rollback
  
• Understanding Lock
  
• etc.,
  

Exception Handling

• Introduction
  
• blocks
  
• Example
  

T-SQL

• Introduction to T-SQL
  
• T-SQL statements
  
• Control structures
  

System Functions

• List and usage of system functions
  
• With example queries
  

Cursors

• Introduction
  
• Advantages and importance
  
• Declare and usage of cursor
  
• Examples in detail
  

Stored Procedures

• Introduction
  
• Syntax
  
• Creation of SP
  
• Invoking a stored procedure
  
• dropping
  
• Task
  

User Defined Functions

• Introduction
  
• Syntax
  
• Creation of UDF
  
• Invoking functions
  
• dropping
  
• Task

Triggers

• Introduction
  
• Advantages
  
• Creating a Trigger
  
• Implementation
  
• Examples and Task
  

Transaction

• Introduction
  
• Implementation
  
• Example
  

Course Packages

Batches