SQL Server 2016 Administration

SQL Server 2016 Administration

In this course you'll be taken from novice to experienced Database Administrator.

Learning about.

• Creating a Lab environment.
• Installing related services, Active Directory
• High Availability Systems, including mirroring and always on clusters
• SQL Server Security
• Benefits of Powershell
• Installing Windows Failover Cluster
• Configuring Always On Cluster
• Scans Vs Seeks
• Top I/O and CPU queries

By the time you have completed this course you will have the skills to administrate SQL Server in corporate networks or your own startup.

Database Administration from Zero to Hero

Url: View Details

What you will learn

• Install SQL Server, Create Always on groups, create a lab environment
• Perform Windows Active Directory Install, Create DHCP Scopes.
• Manage SQL Servers Via SSMS, Correctly configure windows firewall

Rating: 3.35

Level: Intermediate Level

Duration: 2 hours

Instructor: John Hall