Regarding Sql Server DBA Course /Professional Trainning

Regarding the Sql Server DBA Course /Professional Trainning ,Please contect  either e-mail or cell Phone given below:

E-mail :-surender704@gmail.com
Mobile No :-91-9711875652

Course contents to learn SQL Server DBA :                                        Duration = 3 Months

PART-1

1] Basic DBMS and RDBMS Concepts.

2] SQL Server Overview

3] SQL Server Architecture

4] Instance and Databases

5] SQL Command and Concepts

6] Constraints creation and alteration operations on database objects

5] Understanding of Joins, aggregate functions and Sub-queries of all types

7] T-SQL Concepts (Stored Procedure, Functions, Triggers, Cursor, Transactions)

PART-2

1] SQL Server Installation and Configurations

2] System and User Databases

3] Recovery Models of Database

4] Data files, File Groups and Database creation and Alteration

5] Transaction Log File

7] Security

8] Backups and Restorations

9] SQL Server Agent Overviews

10] Automat the Schedule tasks

11] Log Shipping

12] Mirroring

13] Failover Clustering

14] Replications

15] Import and Export the Data

16] Trouble Shooting the Issues

17] Identify the Performance Issues