SQL Server online Training starts on 20 JUL

[Kumarstp]

Hi ,

Any one intrested to learn SQL Server Online Classes Please contact my email Address:


[email protected]

Course period: 3 weeks (53 hours)



Start Date : 20 JUL,2010
[b][/b]





Here is the List of Topic which I will cover in the class:





S.No.    Chapter Name

1    Relation Data Base and DataWare Housing Concepts


2  Installing and Configuring SQL Server 2005


3  Database Configuration and Maintenance
        (Tables,Indexes,System tables,views,Stored Procedures,Schemas)

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

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

6  SQL Server Architecture


7  Detailed Theory on Indexes,Stored Procedures .
        (Types of Indexes,Stored Procedures,
        Indexs design and working Inside SQL Server)



8  Automating SQL Server
      (Jobs,Alerts,Maintenance Plan,Import and Export data)


9  LogShipping


10  Database Mirroring


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


12  Failover Clustering and RAID systems
        (basic Concepts on Clustering,Types of Clusters,Types of RAIDS)

13  T SQL Programming



14  SQL Server Query Optimization and Perofrmance


15  SQL Server Reporting,Integration and Analysis Services.
        Basic differences between SQL Server 2005 and 2008.