ABOUT SQL SERVER  TRAINING

File Management System And Its Drawbacks Database Management System (DBMS) and Data Models Physical Data Models Logical Data Models Hierarchical Data Model (HDBMS) Network Data Model (NDBMS) Relational Data Model (RDBMS) Object Data Model (ODBMS) Object Relational Data Model (ORDBMS) Conceptual Data Models Entity – Relationship (E-R) Model

SQL SERVER  COURSE AT DLK

Sql Server Training Institute in Chennai Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2 Connecting To Server Server Type Server Name Authentication Modes SQL Server Authentication Mode Windows Authentication Mode Login and Password SQL Server Management Studio and Tools In Management Studio Object Explorer Object Explorer Details Query Editor Advantages Of Stored Sub Programs compared to Independent SQL Statements Stored Procedures Creating , Altering and Dropping Optional Parameters Input and Output Parameters Permissions on Stored Procedures User Defined Functions Creating, Altering and Dropping Types Of User Defined Functions Scalar Functions Table Valued Functions Inline Table Valued Functions Multi Statement Table Valued Functions Permissions On User Defined Functions Triggers Purpose of Triggers Differences Between Stored Procedures and User Defined Functions and Triggers Creating, Altering and Dropping Triggers Magic Tables Instead Of Triggers Exception Handling Implementing Exception Handling Adding and removing User Defined Error Messages To And From SQL Server Error Messages List Raising Exceptions Manual

SQL SERVER TRAINING INSTITUTE IN CHENNAI

Our Curriculum

Section 1:Introduction To DBMS  
File Management System And Its Drawbacks
Database Management System (DBMS) and Data Models
Physical Data Models
Logical Data Models
Hierarchical Data Model (HDBMS)
Network Data Model (NDBMS)
Relational Data Model (RDBMS)
Object Data Model (ODBMS)
Object Relational Data Model (ORDBMS)
Section 2:Introduction To SQL Server   
Connecting To Server
Server Type
Server Name
Authentication Modes
SQL Server Authentication Mode
Windows Authentication Mode
Object Explorer
Object Explorer Details
SQuery Editor
Section 3:Introduction To TSQL   
History and Features of TSQL
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Transaction Control Language (TCL)
Creating Database
Section 4:Data Manipulation Language    
Identity
Creating A Table From Another Table
Inserting Rows From One Table To Another
Differences Between Delete and Truncate
Section 5:Data Query Language (DQL)   
Select
Where clause
Column aliases
Order By Clause
IsNull() function
Section 6:Built In Functions   
Scalar Functions
Numeric Functions
Conversion Functions
Date Functions
Convenient Aggregate Functions
Statistical Aggregate Functions
Group By and Having Clauses
Common Table Expressions (CTE)
Section 7:BTop n Clause   
Set Operators
Joins
Sub Queries
Indexes
Security
Views
Section 8:Stored Sub Programs   
Stored Procedures
User Defined Functions
Triggers
Exception Handling
Section 9:CLR Integration   
Working With XML Data Type
Backup and Restore Of Database
Attach and Detach of Database
Normalization