Description
In this course, you will learn:
- Get an overview of installing, administering, and managing SQL Server 2016 in this course with SQL Server expert Gerry O'Brien
- how to install the database and tools, configure different instances, optimize performance, and secure your database with user roles and logins
- Gerry also covers administrative duties such as backup and restoration, database migration, and high-availability options, including database replication, log shipping, and always-on availability.
- This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.
Syllabus:
1. Installation and Configuration
- Introduce installation options
- Installation options continued
- Database storage strategies
- Capacity and growth considerations
- Understanding service accounts
- Install SQL Server
- Setting up the database
2. Database Instances
- Configure instance properties
- Configure instance properties continued
- Collation and Unicode support
- Configure linked servers
- Database engine services management
3. Performance Considerations
- Locks, blocking, and deadlocks
- Using the profiler
- Auditing the database
- Resource governor
4. Security
- Manage roles
- Manage server logins
- Manage database users
- Manage database roles
- Implement server permissions
- Implement database permissions
- Logon triggers
5. Managing Data
- Backup and restore strategies
- Backup demonstration
- Moving database files
- Ensure data integrity
- Manage indexes and data maintenance
6. High Availability Options
- Database replication
- Log shipping
- Database mirroring
- Always On