Course Code: 26388

55369 Provisioning Databases on SQL Server Course

Class Dates:
11/4/2024
9/30/2024
Length:
Days
Cost:
$2695.00
Class Time:
Technology:
Server
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course Overview
  • This five-day course provides a comprehensive understanding of SQL Server and its various components. Students will learn about the SQL Server platform, its architecture, and how to configure services, accounts, and networking. The course covers topics such as installation, upgrade strategies, and configuring databases and data files.

    Students will gain knowledge about maintaining databases for long-term performance, using techniques like CHECKDB and index rebuilding. The course also delves into optimizing SQL Server performance through storage configuration, including options like fileshares, local storage, and cloud storage, along with the use of SQL Server Stretch Databases.

    Additionally, the course explores cloud-based installations of SQL Server using Microsoft Azure, discussing database hosting options and migration. Students will learn how to move databases to Azure SQL Database and utilize Azure Virtual Machines for hosting SQL Server instances.
  • Audience
  • Students will gain skills in administering databases hosted in Microsoft Azure, including security, Azure Storage setup, and automating administration tasks.

Prerequisites

  • Basic understanding of relational databases
    Basic Windows knowledge

Course Details

  • Benefits
  • Describe the components of 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
  • Module 1: Understand the components of SQL Server
  • Overview of the SQL Server platform
  • Understand the architecture of SQL Server
  • Configure services, accounts, and networking
  • Lab 1: No Lab
  • Module 2: Install a SQL Server system
  • Plan your SQL Server installation
  • Plan the temporary database
  • Install SQL Server manually
  • Install SQL Server automatically
  • Lab 1: Install SQL Server
  • Prepare for the installation
  • Install the database server
  • Check your installation
  • Perform an unattended installation
  • Module 3: Upgrade your SQL Server
  • Satisfy the requirements for a SQL Server upgrade
  • Plan to upgrade the SQL Server services you have installed
  • Perform a side-by-side upgrade
  • Lab 1: Perform a SQL Server upgrade
  • Set up database users
  • Restore the database and transaction logs
  • Complete post-upgrade tasks
  • Module 4: Configure your databases and data files
  • Overview of SQL Server data storage
  • Configure system database storage
  • Configure user database storage
  • Move databases
  • Set up the buffer pool extension
  • Lab 1: Configure database storage
  • Configure the temporary database
  • Configure new databases
  • Attach a database
  • Module 5: Maintain your databases
  • Maintain the integrity of your databases
  • Optimize performance by using indexes
  • Use Database Maintenance Plans
  • Lab 1: Maintain your databases
  • Check your data integrity
  • Defragment databases by rebuilding indexes
  • Manage database using Database Maintenance Plans
  • Module 6: Configure storage to support SQL Server databases
  • Optimize the performance of SQL Server by configuring storage
  • Use a network fileshare to store files for SQL Server
  • Store SQL Server files in the Cloud
  • Use SQL Server Stretch Database
  • Lab 1: Set up Stretch Database
  • Execute the Stretch Database Advisor
  • Set up Stretch Database for a database table
  • Module 7: Design a cloud-based installation of SQL Server
  • 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
  • Lab 1: Set up a database in Azure SQL Database
  • Design a cloud database deployment
  • Set up Azure SQL Database
  • Configure firewall rules for a cloud database
  • Module 8: Move databases into the cloud
  • Test your databases before a migration
  • Database compatibility with Azure SQL Database
  • Migrate a database into the cloud
  • Lab 1: Move a database to Azure SQL Database
  • Ensure that the database is compatible with Azure SQL Database
  • Move the database into the cloud
  • Module 9: Use an Azure Virtual Machine to host SQL Server
  • Set up an instance of SQL Server on an Azure Virtual Machine
  • Move a database to an Azure Virtual Machine
  • Lab 1: Set up a SQL Server instance in the cloud
  • Create a Virtual Machine in Azure
  • Move a database to the Virtual Machine
  • Connect clients to the Virtual Machine
  • Module 10: Administer databases hosted in Microsoft Azure
  • Secure your deployment of Azure SQL Database
  • Set up Azure Storage to support databases
  • Automate administration tasks
  • Lab 1: Administer cloud databases in Azure
  • Use data masks to protect personal data
  • Automate an administration task