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