The Knowledge Academy Logo
The Knowledge Academy Logo
+61 1-800-150644 - Available 24/7

Send us your message.

X

Provisioning SQL Databases (M20765)

Key points about this course


Duration: 5 Days*

Exam: Provisioning SQL Databases

Accredited: Yes

Support: 24/7

Dates & Prices Enquire

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Online Icon

Online

Onsite Icon

In-house

Course Information

Provisioning SQL Databases Overview

This 5 day Provisioning SQL Databases trainer-led course aims to provide candidates with the necessary skills to provision an SQL Server database both in SQL Azure and on premise. By the completion of the course delegates will have the ability to provision a Database Server, upgrade and configure an SQL Server, manage Databases and Files, and provision, migrate, and maintain databases in the cloud.

 

For each module of the course, delegates will complete a lab that will enable them to obtain hands-on experience within each topic of the course. This will result in the development of skills and knowledge that can be implemented in the workplace.

 

The Knowledge Academy are a Microsoft Silver Partner, therefore this Provisioning SQL Databases training course is fully accredited by Microsoft.

Provisioning SQL Databases Outline

This course will cover the following content:

Module 1: SQL Server 2016 Components

  • Introduction to the SQL Server Platform

  • Overview of SQL Server Architecture

  • SQL Server Services and Configuration Options

  • Lab : Discussion: SQL Server versions

  • When we do use a separate installation of SQL Server and when would use a separate instance?

  • Which version of SQL Server is most suitable in your organization?

 

Module 2: Installing SQL Server 2016

  • Considerations for SQL Installing Server

  • TempDB Files

  • Installing SQL Server 2016

  • Automating Installation

  • Lab : Installing SQL Server

  • Assess the available resources

  • Install an instance of SQL Server

  • Perform post installation checks

  • Automating Installation

 

Module 3: Upgrading SQL Server to SQL Server 2017

  • Upgrade Requirements

  • Upgrade SQL Server Services

  • Migrating SQL Server Data and Applications

  • Lab : Upgrading SQL Server

  • Create the Application Logins

  • Restore Database Backups

  • Orphaned Users and Database Compatibility Level

 

Module 4: Working with Databases

  • Introduction to Data Storage with SQL Server

  • Managing Storage for System Databases

  • Managing Storage for User Databases

  • Moving and Copying Database Files

  • Side-by-Side Upgrade: Migrating SQL Server Data and Applications

  • Buffer Pool Extension

  • Lab : Managing Database Storage

  • Configuring tempdb Storage

  • Creating Databases

  • Attaching a Database

  • Enable Buffer Pool Extension

 

Module 5: Performing Database Maintenance

  • Ensuring Database Integrity

  • Maintaining Indexes

  • Automating Routine Database Maintenance

  • Lab : Performing Database Maintenance

  • Use DBCC CHECKDB to Verify Database Integrity

  • Rebuild Indexes

  • Create a Database Maintenance Plan

 

Module 6: Database Storage Options

  • SQL Server storage Performance

  • SMB Fileshare

  • SQL Server Storage in Microsoft Azure

  • Stretch Databases

  • Lab : Implementing Stretch Database

  • Run Stretch Database Advisor

  • Implement Stretch Database

 

Module 7: Planning to Deploy SQL Server on Microsoft Azure

  • SQL Server Virtual Machines in Azure

  • Azure Storage

  • Azure SQL Authentication

  • Deploying an Azure SQL Database

  • Lab : Plan and Deploy an Azure SQL Database

  • Plan an Azure SQL Database, Networking, performance tiers, security

  • Provision an Azure SQL Database

  • Connect to an Azure SQL Database

 

Module 8: Migrating Databases to Azure SQL Database

  • Database Migration Testing Tools

  • Database Migration Compatibility Issues

  • Migrating a SQL Server Database to Azure SQL Database

  • Lab : Migrating SQL Server Databases to Azure

  • Perform Migration Testing

  • Migrate a SQL Server Database to Azure SQL Database

  • Test a Migrated Database

 

Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine

  • Deploying SQL Server on an Azure VM

  • The Deploy Database to a Microsoft Azure VM Wizard

  • Lab : Deploying SQL Server on an Azure Virtual Machine

  • Provision an Azure VM

  • Use the Deploy Database to Azure VM Wizard

 

Module 10: Managing databases in the Cloud

  • Managing Azure SQL Database Security

  • Configure Azure storage

  • Azure Automation

  • Lab : Managing Databases in the Cloud

  • Configure Azure Security

  • Automate Azure Deployment

Who should attend?

This course is designed for individuals who need to have the skills to administer and manage SQL databases in order to fulfill their job role.

 

Prerequisites

In order to enroll on this Provisioning SQL Databases course, candidates must have a basic knowledge of: Microsoft Windows operating systems and their functions, Transact-SQL, relational databases, and some experience in designing databases. This is to ensure that candidates fully understand the content of the course.

Yes, The Knowledge Academy is fully accredited by Microsoft as a Microsoft Silver Partner for this Provisioning SQL Databases training course.
Our Provisioning SQL Databases trainers are experts in their field and have years of experience with Microsoft training.
Delegates will need to pass the Provisioning SQL Databases 70-765 examination. We do not provide the exam and it must be taken separately.
The Knowledge Academy offers a wide range of locations across the UK and around the world, making it easy to find a training venue near you.

Provisioning SQL Databases Examination

The Provisioning SQL Databases 70-765 examination must be passed in order to complete this course. We do not provide the exam and it must be taken separately. The exam will cover the following areas:

  • Implement SQL in Azure (40–45%)

  • Manage databases and instances (30-35%)

  • Manage Storage (30–35%)

Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device
Brisbane
Mon 22nd Jul 2019
Places available
$5995
VirtualLive Virtual
Mon 5th Aug 2019
Places available
$5995
Adelaide
Mon 12th Aug 2019
Places available
$5995
Sydney
Mon 19th Aug 2019
Places available
$5995
Brisbane
Mon 26th Aug 2019
Places available
$5995
VirtualLive Virtual
Mon 2nd Sep 2019
Places available
$5995
Adelaide
Mon 9th Sep 2019
Places available
$5995
Melbourne
Mon 16th Sep 2019
Places available
$5995
Canberra
Mon 23rd Sep 2019
Places available
$5995
Sydney
Mon 23rd Sep 2019
Places available
$5995
Perth
Mon 7th Oct 2019
Places available
$5995
VirtualLive Virtual
Mon 14th Oct 2019
Places available
$5995
Melbourne
Mon 21st Oct 2019
Places available
$5995
Brisbane
Mon 28th Oct 2019
Places available
$5995
VirtualLive Virtual
Mon 4th Nov 2019
Places available
$5995
Adelaide
Mon 4th Nov 2019
Places available
$5995
Canberra
Mon 18th Nov 2019
Places available
$5995
Sydney
Mon 18th Nov 2019
Places available
$5995
VirtualLive Virtual
Mon 2nd Dec 2019
Places available
$5995
Perth
Mon 2nd Dec 2019
Places available
$5995
Melbourne
Mon 16th Dec 2019
Places available
$5995

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 5 Days*

Exam: Provisioning SQL Databases

Accredited: Yes

Support: 24/7


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted Icon

Trusted & Approved

Microsoft Silver Learning Partner

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

bannerimg

Click here to save up to 50%!