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