SQL Server upgrades
- Offered byMicrosoft
SQL Server upgrades at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
SQL Server upgrades at Microsoft Course details
- Introduction to upgrading SQL Server
- SQL Server Discovery using the Microsoft Assessment and Planning (MAP) toolkit
- Assess and convert SQL Server databases using the Data Migration Assistant (DMA)
- Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
- Use the SQL Server Query Tuning Assistant
- In this learning path you will learn how to take an inventory of your SQL Server deployments using the Microsoft Assessment and Planning toolkit, how to upgrade SQL Server databases using the Data Migration Assistant, and how to optimize your updated system using both the Database Experimentation Assistant and Query Tuning Assistant
- This course shows you how to begin documenting your landscape, plan the most appropriate upgrade path, and test your migrated databases
- This course shows you how to install MAP on your client machine, and then use it to discover SQL Server instances within your corporate environment
- The Database Experimentation Assistant (DEA) is a standalone application that can compare workloads between the current version of your database, and the target
SQL Server upgrades at Microsoft Curriculum
Introduction to upgrading SQL Server
Introduction
Decide if an upgrade is right for your task
Discover your database landscape
Assess and convert your databases
Test your migration
Knowledge check - upgrade SQL Server versions
Tune queries post migration
Knowledge check - upgrade SQL Server tools
Summary
SQL Server Discovery using the Microsoft Assessment and Planning (MAP) toolkit
Introduction
Decide if MAP is right for your task
Install the MAP toolkit
Collect and assess inventory data
Exercise - Install the Microsoft Assessment and Planning Toolkit
Exercise - Collect and assess inventory data
Summary
Assess and convert SQL Server databases using the Data Migration Assistant (DMA)
Introduction
Decide if the Data Migration Assistant (DMA) is right for your task
Install the DMA
Identify compatibility issues
Upgrade a database
Create Azure SQL virtual machine
Exercise: Install the Data Migration Assistant (DMA)
Exercise: Identify compatibility issues
Exercise: Upgrade a database
Summary
Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
Introduction
Decide if DEA is right for your task
Install DEA
Configure a new capture
Review a trace analysis report
Exercise - Install the Database Experimentation Assistant
Exercise - Configure a new capture with DEA
Exercise - Review a trace analysis report in DEA
Summary
Use the SQL Server Query Tuning Assistant
Introduction
Decide if QTA is right for you
Get started with QTA
Tune queries with QTA
Knowledge check - Use the SQL Server Query Tuning Assistant
Summary
SQL Server upgrades at Microsoft Entry Requirements
- Basic understanding of SQL Server database administration.
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?