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

LinkedIn Learning

Microsoft SQL Server 2016: Installation and Administration

via LinkedIn Learning

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.