Overview
-
Learn how to install and administer SQL Server 2016. Find out how to optimize performance, secure SQL Server, and back up and restore your database.
Syllabus
-
Introduction
- Welcome
- What you should know
- Introduce installation options
- Installation options continued
- Database storage strategies
- Capacity and growth considerations
- Understanding service accounts
- Install SQL Server
- Setting up the database
- Configure instance properties
- Configure instance properties continued
- Collation and Unicode support
- Configure linked servers
- Database engine services management
- Locks, blocking, and deadlocks
- Using the profiler
- Auditing the database
- Resource governor
- Manage roles
- Manage server logins
- Manage database users
- Manage database roles
- Implement server permissions
- Implement database permissions
- Logon triggers
- Backup and restore strategies
- Backup demonstration
- Moving database files
- Ensure data integrity
- Manage indexes and data maintenance
- Database replication
- Log shipping
- Database mirroring
- Always On
- Next steps
