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
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.
Who Should Attend!
- Developers, DevOps and New Database Administrators
- Novice to Intermittent
Tags
- Database Administration
- SQL Server
Subscribers
101
Lectures
26
TAKE THIS COURSE
