Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft SQL Server 2016: Installation and Administration

via LinkedIn Learning

Go to class Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

2 hours 36 minutes
Sessions

On-Demand
Level

Intermediate

Found in

Coursera

Gain a Splash of New Skills - Coursera+ Annual Nearly 45% Off

GetSmarter

AI Adoption - Drive Business Value and Organizational Impact

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

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

Reviews

4.6 rating at LinkedIn Learning based on 129 ratings

Start your review of Microsoft SQL Server 2016: Installation and Administration