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