SQL
$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.
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.
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).
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:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
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.
Texas
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