Sql Server Database Administration Training

[Edu9Trainings]

Contract Details :

[email protected], +1(262) 607-4058

 

Course Details  ( Expert Trainer : A Microsoft Certified SQL Server Consultant with vast experience - 9 years  in Design, Development & Administration of Database Environments )

======================================================================================================================

Concepts:

 

•              Introduction to SQL Server & its Services (SSIS, SSAS, SSRS)                                 [O]

•              Database Concepts, Compatibility, Recovery Models                                             [O]

•              Basic T-SQL                                                                                                                       [O, D]

•              System and User Databases                                                                                         [O,D]

•              SQL Server Configuration                                                                                              [O,D]

•              Backup & Recovery                                                                                                        [O,D]

•              Log shipping                                                                                                                     [O,D]

•              Mirroring                                                                                                                          [O,D]

•              Clustering                                                                                                                          [O]

•              Replication                                                                                                                        [O,D]

•              Security                                                                                                                              [O,D]

•              Introduction to Storage Area Networks (SAN)                                                          [O]

•              Monitoring                                                                                                                        [O]

•              SQL Server Management Studio                                                                                  [O,D]

•              SQL Server Agent & jobs                                                                                                [O,D]

•              SQL Mail                                                                                                                            [O,D]

•              SQL Profiler                                                                                                                       [O,D]

•              Linked Servers                                                                                                                  [O,D]

•              Memory & CPU                                                                                                                [O]

•              DMV’s and Troubleshooting                                                                                          [O,D]

•              Performance Tuning                                                                                                        [O,D]

 

O - Orientation

D – Demonstration

 

Course Content: Basic & Intermediate Levels

Session Duration: ~2 hours/day

[Edu9Trainings]

Contact Details :
[email protected], +1(262) 607-4058

Course Details ( Expert Trainer : A Microsoft Certified SQL Server Consultant with vast experience - 9 years in Design, Development & Administration of Database Environments )