SQL Server 2016 Administration
Database Administration from Zero to Hero
Description
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.
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
Who Should Attend!
- Developers, DevOps and New Database Administrators
- Novice to Intermittent