SQL Server Online Training

Duration of the Course

• 30 Hrs

SQL Server Online Training Course Overview

Introduction to Data Store

• What is a Database?
• Data Storing in Different ways
• Books and Papers
• Data Files
• Datab

Introduction to DBMS

• Introduction to RDBMS
• Understanding CODD rules
• Understanding SEQUEL

Introduction to SQL Server

• What is the difference between SQL Server 2005 and 2008?
• Data Definition Language
• Data Manipulation Language

Constraints in SQL Server

• Not Null
• Unique
• Primary key
• Check
• Referential Integrity
• Self-Referential Integrity

Functions in SQL Server

• How to use the functions in SQL Server?
• Single Row Functions
• Group Function

Operators in SQL Server

• How many operators used in SQL Server
• Conditional operator
• Logical operator
• Set operator

Clauses in SQL Server

• Where
• Group by
• Having
• Order by

Additional Queries

• What is a sub Query?
• Building a Nested Sub Query
• Nested Queries Using Single-Value SELECT Statements
• Nested Queries Using Sub Queries That Return Multiple Values

Correlated Sub-Queries

• How Correlated Sub-Queries Work
• Correlated Sub-Queries in the where Clause
• Correlated Sub-Queries in the select List

SQL Joins

• Inner Join
• Self-Join
• Outer Join
• Cross-Join

Transaction Control Language

• Creating tables from existing table
• Indexes
• Functions
• Procedures
• Triggers
• Cursors
• Views
• Managing Security with Data Control Language
• User creation
• Controlling the permission by grant, revoke and Deny
• Disadvantages of SQL and Introduction to T-SQL

Indexes

• Clustered Index
• Non-Clustered Index

Functions

• System-Defined Functions
• User-Defined Functions
• Scalar Function
• Inline Table-valued Function
• Multi-Statement Table-Valued Function

Triggers

• DML Triggers
• DDL Triggers

Cursors

• Understanding the Cursors
• Types of Cursors

Visit for SQL Server Online Training