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

Données et services numériques, dans le nuage et ailleurs
Certificat informatique et internet via France Université Numerique Introduction to Digital Curation
University College London via Independent Excel Avanzado
Miríadax SAP Business Warehouse powered by SAP HANA
SAP Learning Programming Mobile Applications for Android Handheld Systems: Part 2
University of Maryland, College Park via Coursera