Provisioning Databases on SQL Server

4.9(45,300 Ratings)

Duration

5 Days

Upcoming Batch

23 November 2026 - 27 November 2026

Batch Options

4 hours & 8 hours

Language

English/ Arabic

Provisioning Databases on SQL Server

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

Target Audience

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.

Course Content

7 modules · 24 topics

01Upgrade your SQL Server3 topics

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

02Configure your databases and data files5 topics

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

03Maintain your databases3 topics

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

04Configure storage to support SQL Server databases4 topics

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

05Design a cloud-based installation of SQL Server4 topics

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

06Move databases into the cloud3 topics

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

07Use an Azure Virtual Machine to host SQL Server2 topics

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

Schedule Dates

4 upcoming batches

Session Type

Physical sessions run at our training facility.

Provisioning Databases on SQL Server
Batch Dates	Duration	Batch Options	Language
23 November 2026 - 27 November 2026Next	5 Days	4 hours & 8 hours	English/ Arabic
01 March 2027 - 05 March 2027	5 Days	4 hours & 8 hours	English/ Arabic
07 June 2027 - 11 June 2027	5 Days	4 hours & 8 hours	English/ Arabic
13 September 2027 - 17 September 2027	5 Days	4 hours & 8 hours	English/ Arabic

Can’t find a suitable date? Request a schedule that fits your team.

Request More Information

FAQs

What is the duration of the Provisioning Databases on SQL Server course?

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

Will there be any hands-on labs or practical sessions?

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

Is there a certification exam associated with this course?

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

What materials are provided as part of the course?

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

Are there any discounts available for group enrollments?

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

This course includes:

Soft copy of Courseware
Certificate of Course Completion
Experienced and Professional Trainer
Lab and Exercises During Training
Sample Questions for Exam Preparation
Mock Test on the Last Day of Training
Exam Registration Guidance
5-Star Training Environment

Upcoming Batch

23 November 2026 - 27 November 2026

View all batch dates

How We Deliver

Select the method that best suits your needs.

Online Instructor-Led Training Classroom Training Onsite Training Overseas Training

Request More Information

First Name *Please enter your first name.

Last Name

Email Address *Please enter a valid email address.

Phone Number *Please enter your phone number.

Country

Message

Your information is secure and never shared.

How We Deliver

Flexible Training Options to Meet Your Needs

Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.

Select the method that best suits your needs.