SQL Server Developer Certification Training

File Management System And Its Drawbacks

Database Management System (DBMS) and Data Models

Physical Data Models

Logical Data Models

Relational Data Model (RDBMS)

Object-Relational Data Model (ORDBMS)

Entity – Relationship (E-R) Model

Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2

Connecting To Server

Server Type

Server Name

Authentication Modes

SQL Server Developer Authentication Mode

Windows Authentication Mode

Login and Password

SQL Server Developer Management Studio and Tools In Management Studio

TSQL (Transact Structured Query Language)

Types Of TSQL Commands

Data Definition Language (DDL)

Data Manipulation Language (DML)

Data Query Language (DQL)

Data Control Language (DCL)

Transaction Control Language (TCL)

Database(Create,Alter,Drop)

Constraints

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(create,Alter,Drop)

Insert, Update, Delete, and Truncate

Identity

Creating A Table From Another Table

Inserting Rows From One Table To Another

Differences Between Delete and Truncate

Select

Where clause

Order By Clause

Distinct Keyword

IsNull() function

Column aliases

Between … And

In

Like

IsNull

Scalar Functions

Numeric Functions

Date Functions

Aggregate Functions

Group By and Having Clauses

Super Aggregates Over(partition by …) Clause

Ranking Functions

Common Table Expressions (CTE)

Inner Join

Self Join

Outer Join

Left Outer Join

Right Outer Join

Full Outer Join

Cross Join

Single Row Sub Queries

Multi-Row Sub Queries

Co-Related Sub Queries

Clustered Index

NonClustered Index

Create, Alter and Drop Indexes

Using Indexes

Purpose Of Views

Creating, Altering, and Dropping Indexes

Simple and Complex Views

Encryption and Schema Binding Options in creating views

Introduction

Begin Transaction

Commit Transaction

Rollback Transaction

Save Transaction

Working With Cursors

Types Of Cursors

Static, Dynamic, and Keyset Cursors

Local and Global Cursors

Creating, Altering, and Dropping

Input and Output Parameters

Creating, Altering, and Dropping

Types Of User Defined Functions

Table Valued Functions

Inline Table Valued Functions

Multi Statement Table Valued Functions

Purpose of Triggers

Differences Between Stored Procedures and User Defined Functions and
Triggers

Creating, Altering, and Dropping Triggers

Implementing Exception Handling

Adding and removing User Defined Error Messages To And From SQL Server Developer

Error Messages List

Login Creation

SQL Server Authenticated Login

Windows Authenticated Login

User Creation

Granting, Revoking Permissions