Provisioning SQL Databases Certification Training Course Overview

The Provisioning SQL Databases training at Koenig aims to impart skills and knowledge to provision and manage a Microsoft SQL Server 2016 database. The SQL Server 2016 course covers provisioning on both Azure and on-premise. It will also familiarize participants with conducting new installations and migrations to the latest version from an existing older one.
 
This SQL Server 2016 training on Provisioning is ideal for professionals who manage, maintain and administer SQL Server databases in enterprise environments. This course is also suitable for professionals who are into application development where content is sourced from SQL Server databases.
Test your current knowledge Qubits42

Provisioning SQL Databases (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1700
08 - 12 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

04 - 08 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1950
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: SQL Server Components
  •   Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options
Module 2: Installing SQL Server
  • Considerations for SQL Installing Server
  • Considerations for SQL Installing Server
  • Installing SQL Server
  • Automating Installation
Module 3: Upgrading SQL Server to SQL Server 2017
  •   Upgrade Requirements
  • Upgrade SQL Server Services
  • Side by Side Upgrade: Migrating SQL Server Data and Applications
  • Upgrading SQL Server
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
  • Buffer Pool Extension
  • Managing Database Storage
Module 5: Performing Database Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Performing Database Maintenance
Module 6: Database Storage Options
  • SQL Server storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Stretch Databases
  • Implementing 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
  • Plan and Deploy an Azure SQL
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
  • Migrating SQL Server Databases to Azure
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
  • Deploying SQL Server on an Azure Virtual Machine
Module 10: Managing databases in the Cloud
  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation
  • Managing Databases in the Cloud
Download Course Contents

Request More Information

Course 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

 

Upon Completion of this Course, you will accomplish following:-

  • Understand the platform, components and architectural overview of SQL Server 2016
  • Configure and install SQL Server
  • Provision a Database Server
  • Upgrade SQL Server services and migrate data and applications to the latest version
  • Implement SQL Server Virtual Machines in Azure
  • Deploy and migrate Azure SQL database
  • Manage Database storage and files (shared)
  • Maintain database integrity while performing maintenance tasks

Give an edge to your career with Microsoft certification training courses. Students can join the classes for Provisioning SQL Databases Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Student Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?

Student Name Country Month Feedback Rating
Danik Colin Canada Apr-2020 A1. He's professional and understands our needs. I would recommend him to a friend or take classes with him again.

FAQ's


Yes, fee excludes local taxes.