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.
Course Price : $2475 Per Participant
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.
Courses
Years of Experience
Global Learners
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.
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).
Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.
For dates, times, and location customization of this course, get in touch with us.
You can also speak with a learning consultant by calling 800-961-0337.
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
After completing this module, students will be able to:
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
Lab 1: Install SQL Server
After completing this module, students will be able to:
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
Lab 1: Perform a SQL Server upgrade
After completing this module, students will be able to:
Lessons
Lab 1: Configure database storage
After completing this module, students will be able to:
Lessons
Lab 1: Maintain your databases
After completing this module, students will be able to:
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
Lab 1: Set up Stretch Database
After completing this module, students will be able to:
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
Lab 1: Set up a database in Azure SQL Database
After completing this module, students will be able to:
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
Lab 1: Move a database to Azure SQL Database
After completing this module, students will be able to:
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
Lab 1: Set up a SQL Server instance in the cloud
After completing this module, students will be able to:
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
Lab 1: Administer cloud databases in Azure
After completing this module, students will be able to:
©2023 Microtek Learning – All Rights Reserved