Provisioning Databases on SQL Server

Overview Schedule Dates Course Content Faqs

Course Overview

This five-day instructor-led course is intended for IT professionals who are interested in expanding their knowledge base and technical skills about SQL Server. In this course, students learn how to provision SQL Server databases both on-premises and in Azure. The course covers new installations and migrations from existing installations.

About This Course

Audience Profile

This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and basic Windows navigation skills.

At Course Completion

Describe the components of the SQL Server
Provision a database server that runs SQL Server
Upgrade a database server
Configure a new database on SQL Server
Maintain a database hosted on SQL Server
Configure storage for a database
Plan to deploy SQL Server on Microsoft Azure
Move a database from SQL Server on-premises to Microsoft Azure
Provision SQL Server on an Azure virtual machine
Manage databases and data files for SQL Server in the cloud

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Target Audiance

Database Administrators who enhanced their skills in managing SQL Server databases.
IT Professionals seeking to expand their knowledge on SQL Server provisioning and deployment.
Software Developers who gained insights into optimizing database performance and scalability.
System Architects looking to design robust database infrastructures using SQL Server.

Schedule Dates

Provisioning Databases on SQL Server

21 October 2024 - 25 October 2024

Provisioning Databases on SQL Server

27 January 2025 - 31 January 2025

Provisioning Databases on SQL Server

28 April 2025 - 02 May 2025

Provisioning Databases on SQL Server

28 July 2025 - 01 August 2025

Course Content

Satisfy the requirements for a SQL Server upgrade
Plan to upgrade the SQL Server services you have installed
Perform a side-by-side upgrade

Overview of SQL Server data storage
Configure system database storage
Configure user database storage
Move databases
Set up the buffer pool extension

Maintain the integrity of your databases
Optimize performance by using indexes
Use Database Maintenance Plans

Optimize the performance of SQL Server by configuring storage
Use a network file share to store files for SQL Server
Store SQL Server files in the Cloud
Use SQL Server Stretch Database

IaaS and PaaS database options in Microsoft Azure
Use Azure Virtual Machines to host databases
Azure SQL Database security
Set up database in Azure SQL Database

Test your databases before a migration
Database compatibility with Azure SQL Database
Migrate a database into the cloud

Set up an instance of SQL Server on an Azure Virtual Machine
Move a database to an Azure Virtual Machine

FAQs

The duration of the course is typically five days, consisting of 40 hours of instruction and hands-on lab exercises.

Yes, the course includes numerous hands-on labs and practical exercises to reinforce the concepts taught and provide real-world experience.

Yes, the course prepares participants for the Microsoft Certification Exam 70-764: Administering a SQL Database Infrastructure.

Participants receive comprehensive course materials, including lecture notes, lab manuals, and access to a virtual SQL Server environment for practice.

Yes, discounts are typically available for group enrollments. Please contact the course provider for specific details on group rates and discounts.