Type and hit enter to Search
×

Provisioning Databases on SQL Server

  • 4.9(45,300 Rating)

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

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.

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 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
08 July 2024 - 12 July 2024
Provisioning Databases on SQL Server
14 October 2024 - 18 October 2024
Provisioning Databases on SQL Server
20 January 2025 - 24 January 2025
Provisioning Databases on SQL Server
21 April 2025 - 25 April 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.

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?