SQL SERVER Training Content
1) Differentiate Files and Databases
2) DBMS and Entity Relationship Model (E-R Model)
3) RDBMS
4) Normalizations
5) SQL Server 2008 over view
Versions and Editions
Features of SQL Server
Differentiate the SQL Server and Oracle
Services of SQL Server
Tools of SQL server
6) Structured Query Language (SQL)
· Data Definition Language (DDL)
· Data Manipulation Language (DML)
· Transaction Control Language (TCL)
· Data Control Language (DCL)
7) Databases
Database Architecture
System Databases
User Defined Databases
Files and File Groups
8) Tables
System Tables
User Tables
Temporary Tables
9) Data types
10) Constraints
11) Rules and Defaults
12) Joins
13) Sub Queries
14) Built in Functions
15) Operators
16) Views
17) Indexes
18) T- SQL Programming
19) Stored Procedures
20) Triggers
21) User Defined Functions
22) Transactions
23) Locks
24) Performance Tuning
25) Cursors
26) Backup and Recovery Databases
27) Security