55369: Provisioning Databases on SQL Server Training

Category

SQL

Rating
4.5
(4.5)
Price

$2475
Per Participant

Course Description

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.


Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.

Prerequisites for this training

  • Basic understanding of relational databases
  • Basic Windows knowledge

Who should attend this course?

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 have basic Windows navigation skills.

microsoft logoMicrosoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

GTR
  • Virtual Live Training
  • Guaranteed to Run

Jun 05, 2023

9:30 am - 5:30 pm EST
Online
  • Virtual Live Training

Jun 19, 2023

9:30 am - 5:30 pm EST
Online
  • Virtual Live Training

Jul 03, 2023

9:00 am - 5:00 pm EST
Online
GTR
  • Virtual Live Training
  • Guaranteed to Run

Jul 17, 2023

9:30 am - 5:30 pm EST
Online
  • Virtual Live Training

Jul 31, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Aug 07, 2023

9:30 am - 5:30 pm EST
Online
  • Virtual Live Training

Aug 21, 2023

9:00 am - 5:00 pm EST
Online
GTR
  • Virtual Live Training
  • Guaranteed to Run

Sep 04, 2023

9:00 am - 5:00 pm EST
Online
  • Virtual Live Training

Sep 18, 2023

9:00 am - 5:00 pm EST
Online
Request Batch

What you will learn

  • 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

Curriculum

This module explains how SQL Server products and editions are designed to address business data storage needs. It also gives the students an understanding of the SQL Server architecture and explains how to configure the Windows services that host SQL Server processes. Students also learn how to configure SQL Server accounts and networking.

Lessons

  • Overview of the SQL Server platform
  • Understand the architecture of SQL Server
  • Configure services, accounts, and networking
  • After completing this module, students will be able to:

  • Choose the right SQL Server components, editions, and versions for a business requirement.
  • Understand the architecture of SQL Server
  • Set up SQL Server services and networking
  • This module explains how to plan and install SQL Server on one or more on-premises servers in your organization. Students also learn how to set up the tempdb database and it files to perform well and how to automate an installation.

    Lessons

  • 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
  • After completing this module, students will be able to:

  • Design your installation of SQL Server.
  • Set up the tempdb database to perform optimally.
  • Perform an installation of SQL Server.
  • Automate an installation of SQL Server.
  • This module explains how to plan and execute an upgrade from an earlier version of SQL Server. Students learn about the various upgrade strategies so they can choose the best method to upgrade their SQL Server instances smoothly and with the least impact on user productivity.

    Lessons

  • 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
  • After completing this module, students will be able to:

  • Choose the best way to upgrade a SQL Server installation.
  • List the advantages and disadvantages of each SQL Server migration strategy.
  • Upgrade a SQL Server instance.
  • This module explains how SQL server uses hard disks to store database files, transaction logs, and other important files. Students will learn how to design disk storage to support a high-performance database and how to move databases from one storage location to another.
  • Lessons

  • 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
  • After completing this module, students will be able to:

  • Design storage files for a database.
  • Create databases.
  • Set up database storage files and filegroups.
  • Move a database from one storage location to another.
  • Use the buffer pool extension.
  • This module explains how to ensure that your databases continue to perform well in the long term by using CHECKDB and rebuilding indexes. The students also learn how to automate database maintenance tasks by using Database Maintenance Plans.
  • Lessons

  • 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
  • After completing this module, students will be able to:

  • Use CHECKDB to ensure the integrity of your database.
  • Use indexes to optimize database performance.
  • Automate database maintenance by using Database Maintenance Plans.
  • This module explains how to configure file storage for SQL Server to ensure high performance. Students learn how to choose from local storage, fileshares, and cloud storage locations. They also learn about SQL Server Stretch Databases and how to implement them.

    Lessons

  • 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
  • After completing this module, students will be able to:

  • Describe how SQL Server performance depends on I/O performance.
  • Use an SMB fileshare to store files for SQL Server.
  • Use Microsoft Azure to store files for SQL Server.
  • Use a Stretch Database.
  • This module explains how to decide whether you should migrate a database from an on-premises SQL Server to Microsoft Azure. Students learn about services in Azure that can host a database and how to choose the best one for their business needs. They also learn how to execute a migration.

    Lessons

  • 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
  • After completing this module, students will be able to:

  • Describe the ways you can run SQL Server in Microsoft Azure.
  • Decide whether an on-premises database is suitable for migration to Azure.
  • Move a database to Azure SQL Database.
  • This module explains how to move databases from on-premises SQL Server intances into Azure SQL Database. Students learn how to test their database and choose those that are suitable for a cloud migration. They also learn about, and use, the migration tools.

    Lessons

  • 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
  • After completing this module, students will be able to:

  • Choose the best database migration test tool.
  • Understand factors that prevent a database from migrating to Azure SQL Database.
  • Move a database from on-premises SQL Server to Azure SQL Database.
  • This module explains how to migrate a database to a Virtual Machine hosted in Azure. Students also learn how to update, license, and administer databases that run as SQL Server instances on Azure Virtual Machines.

    Lessons

  • 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
  • After completing this module, students will be able to:

  • Administer an instance of SQL Server that runs on an Azure Virtual Machine.
  • Move an on-premises database to an instance of SQL Server on an Azure Virtual Machine
  • This module explains how to run databases from day-to-day after you have completed a migration to the cloud. Students learn how to ensure good security, use Azure Storage accounts, and automate database administration tasks.

    Lessons

  • 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
  • After completing this module, students will be able to:

  • Manage encryption, firewall rules, and data masking for databases in Azure.
  • Use Azure Storage to support databases.
  • Automate database tasks by using scripts and Azure Automation
  • With Microtek Learning, you’ll receive:

    • Certified Instructor-led training
    • Industry Best Trainers
    • Official Training Course Student Handbook
    • Pre and Post assessments/evaluations
    • Collaboration with classmates (not available for a self-paced course)
    • Real-world knowledge activities and scenarios
    • Exam scheduling support*
    • Learn and earn program*
    • Practice Tests
    • Knowledge acquisition and exam-oriented
    • Interactive online course.
    • Support from an approved expert
    • For Government and Private pricing*

    * For more details call: +1-800-961-0337 or Email: info@microteklearning.com

    Request Call

    Our Clients

    For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

    • 300+ enterprise clients
    • 100,000+ professionals trained
    • Service 70 of the Fortune 100
    • 96% of our clients would recommend us
    our clients

    Our Awards

    our awards
    why choose us

    REVIEWS ON OUR POPULAR COURSES

    male

    I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.

    MARTIN

    TORONTO, CANADA

    • (5)
    male

    I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.

    Prince N.

    Texas

    • (5)
    male

    I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.

    Marsh George

    Texas

    • (5)
    Accredited By
    img-55369-provisioning-databases-on-sql-server.jpg

    Course Details

    • Start Date: Jun 05, 2023
    • Duration: 5 Days
    • Skill Level: Intermediate
    • Enrolled: 2819
    • Price: $2475
    • Course PDF: Click Here
    side post side mode

    Talk to Learning Advisor