Administering and Provisioning a SQL Server Database

1 800 U Learn (853 276)

DDLS - Administering and Provisioning a SQL Server Database – Fast Track

Length

5 days

Price

$4290.00 inc GST

Reserve Your Spot

Overview

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally it will be of use to individuals who provision databases and develop applications that deliver content from SQL Server databases.

This course draws from both Microsoft 20764 – Administering a SQL Database Infrastructure and Microsoft 20765 – Provisioning SQL Databases to deliver a course that offers core SQL Server Administration skills over a single five day event.

Please note: We are unable to accept SATVs for this course.

Key Topics

Detailed Info

SQL Server 2016 Components
Installing SQL Server 2016
Working with Databases
Recovery Models and Backup Strategies
Backing Up SQL Server Databases
Restoring SQL Server 2016 Databases
SQL Server Security
Assigning Server and Database Roles
Authorizing Users to Access Resources
Protecting Data with Encryption and Auditing
Importing and Exporting Data
Introduction to Managing SQL Server by using PowerShell
Performing Database Maintenance
Automating SQL Server Management
Configuring Security for SQL Server Agent
Tracing Access to SQL Server with Extended events

Reserve your space Request a callback

Skills Gained

Key Topics

Target Audiences

Prerequisites

Skills Gained

After completing this course, students will be able to:

Provision and Install SQL Server 2016
Work With Databases
Describe recovery models and backup strategies
Backup SQL Server databases
Restore SQL Server databases
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Protect data with encryption and auditing
Import and export data
Managing SQL Server using PowerShell
Automate database management
Manage alerts and notifications
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure

Key Topics

Module 1: SQL Server 2016 Components
Module 2: Installing SQL Server 2016
Module 3: Working with Databases
Module 4: Recovery Models and Backup Strategies
Module 5: Backing Up SQL Server Databases
Module 6: Restoring SQL Server 2016 Databases
Module 7: SQL Server Security
Module 8: Assigning Server and Database Roles
Module 9: Authorizing Users to Access Resources
Module 10: Protecting Data with Encryption and Auditing
Module 11: Importing and Exporting Data
Module 12: Introduction to Managing SQL Server by using PowerShell
Module 13: Performing Database Maintenance
Module 14: Automating SQL Server Management
Module 15: Configuring Security for SQL Server Agent
Module 16: Monitoring SQL Server with Alerts and Notifications
Module 17: Tracing Access to SQL Server with Extended events
Module 18: Monitoring SQL Server
Module 19: Troubleshooting SQL Server

Appendix
Appendix 1: Upgrading SQL Server to SQL Server 2016
Appendix 2: Database Storage Options
Appendix 3: Migrating Databases to Azure SQL Database

Target Audiences

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us on 1800 853 276.

Prerequisites

This course requires that you meet the following prerequisites:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design

Print course details

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

You don't appear to have Javascript enabled, our contact forms & booking process unfortunately requires it.

If you'd like more information, or to book a course please email us

Email Course Outline

Request a Callback

Enter your details below and we'll email you a pdf of the course outline.

Enter your details below and one of our team will give you a call to answer any questions you may have.

Testimonials

See what our clients have said about us