Guidance

Here is List of order to learn SQL Server:

• Relation DataBase and DataWare Housing Concepts

• Installing and Configuring SQL Server 2005 

• Database Configuration and Maintenance

          (Tables,Indexes,System tables,views,Stored Procedures,Schemas)

• Backup and Restore a Data Base

         (Backup concept,Types of backup,Restore Concept Types of Recovery models,Real time Tasks with solutions)

• Designing SQL Server Security

         (TCP Endpoints,Logins,Users,Server Roles,DataBase roles,Data Encryption,Surface  Area Configuration)

• SQL Server Architecture

• Detailed Theory on Indexes,Stored Procedures

(Types of Indexes,Stored Procedures, Indexs design and working Inside SQL Server)

• Automating SQL Server

(Jobs,Alerts,Maintenance Plan,Import and Export data)

• LogShipping  

• Database Mirroring

• Replication

(Replication Concepts,types of Replication,Implement and configure Replications
Realtime tasks with solutions,performance on Replication)

• Failover Clustering and RAID systems

(basic Concepts on Clustering,Types of Clusters,Types of RAIDS)

• T SQL Programming

• SQL Server Query Optimization and Perofrmance

• SQL Server Reporting,Integration and Analysis Services.

• Basic differences between SQL Server 2005 and 2008.