- Module 1: In this module, you will learn about running SQL Server 2019 on Linux servers and containers.
In this module, you will:
- Describe the key benefits of running SQL Server on Linux.
- Describe both Windows and cross-platform tools that can be used to administer SQL Server on Linux.
- Describe the benefits of running SQL Server on Linux virtual machines.
- Describe the benefits of running SQL Server on container runtime environments, such as Docker.
- Module 2: Introduction to open-source database migration on Azure
By the end of this module, you'll be able to:
- Describe the features and services available in Azure for hosting an open-source database.
- Explain the key considerations for implementing a migration project.
- Describe different approaches that you can take for migrating databases.
- Module 3: Learn how to use Azure Automanage to optimize IT operations and management.
By the end of this module, you'll be able to:
- Describe how Azure Automanage best practices can optimize the operations of Windows Server and Linux virtual machines.
- Explain the different services available through Azure Automanage.
- Create and assign a custom configuration profile for Azure Automanage machines.
- Describe how to extend Azure Automanage capabilities to non-Azure infrastructure using Azure Arc.
- Module 4: Learn how to decide if the MEAN stack (MongoDB, Express.js, AngularJS, and Node.js) is a good choice for you and set up a MEAN-based web application on a new Azure Linux virtual machine.
In this module, you will:
- Decide if the MEAN web stack is right for you.
- Create an Ubuntu Linux VM to host your web app.
- Install the MEAN stack components on your VM.
- Create a basic web app on your MEAN stack.
Overview
Syllabus
- Module 1: Module 1: Introduction to SQL Server on Linux
- Introduction
- What is SQL Server on Linux?
- SQL Server on Linux features
- Tools for SQL Server on Linux
- Use containers with SQL Server on Linux
- Summary
- Module 2: Module 2: Introduction to open-source database migration on Azure
- Introduction
- MySQL and PostgreSQL database services in Azure
- Considerations for migration
- Approaches to migration
- Knowledge check
- Summary
- Module 3: Module 3: Optimizing IT operations and management with Azure Automanage
- Introduction
- Describe concepts around Azure Automanage best practices
- Enable Azure Automanage best practices
- Create and assign a custom configuration profile
- Extend Azure Automanage across non-Azure infrastructure with Azure Arc
- Knowledge check
- Summary
- Module 4: Module 4: Build and run a web application with the MEAN stack on an Azure Linux virtual machine
- Introduction
- Decide if MEAN is right for you
- Exercise - Create a VM to host your web application
- Exercise - Install MongoDB
- Exercise - Install Node.js
- Exercise - Create a basic web application
- Summary