Microsoft SQL Server 2016: Installation and Administration

Offered By: LinkedIn Learning

Tags

Microsoft SQL Server Courses Data Management Courses Database Administration Courses Database Security Courses High Availability Courses Security Management Courses

Course Description

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

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

Conclusion

Next steps

Taught by

Gerry O'Brien

Related Courses

MongoDB for DBAs
MongoDB University MongoDB Advanced Deployment and Operations
MongoDB University 内存数据库管理
openHPI Data Cleansing with Data Quality Services (DQS)
Microsoft via edX Recovering Data in Azure and SQL Server
Microsoft via edX