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

Optimizing Microsoft Windows Server Storage
Microsoft via edX High Availability and Disaster Recovery with the SAP HANA Platform
SAP Learning Microsoft Exchange Server 2016 - 3: Mailbox Databases
Microsoft via edX Microsoft SharePoint 2016: Workload Optimization
Microsoft via edX Microsoft Azure Virtual Machines
Microsoft via edX