Introduction to the Azure SQL data platform
In this introduction module, participants are introduced to the different offerings in the Azure SQL Database platform and their key capabilities.
- What is the Azure SQL data platform?
- Introduction to Azure SQL Databases
- Introduction to SQL Managed instances
- Working with the Azure Management Portal
Working with SQL Managed Instances
- Creating SQL Managed Instances
- Securing SQL Managed Instances
SQL Managed Instances features and capabilities
- Supported and unsupported features in SQL Managed Instances
- Database backup and restore
- Monitoring and auditing SQL Managed Instances
SQL Managed Instance database migrations
- Available tools for database migrations
- The Data Migration Assistant
- The Azure Database Migration Service
Working with Azure SQL Databases
In this module, participants will learn how to create an Azure SQL logical server. An Azure SQL server is a central administration point for multiple databases. Participants will also learn how to create an Azure SQL Database. Once the Azure SQL Server and Azure SQL Databases are up and running, Firewall rules must be configured to allow client applications to connect to the Azure SQL Databases.
- Creating and configuring a Server in Azure SQL
- Creating and configuring an Azure SQL Database
- Implementing Firewall Rules
- Overview of the Azure SQL Management Tools
Developing Azure SQL Databases
- Creating tables, views, stored procedures, ...
- Migrate an existing SQL Server database
- Exporting and Importing BACPAC files of a SQL Database
- Copy an Azure SQL Database
Azure SQL Database Client Connectivity
- Connectivity Overview
- Available Connectivity Libraries
- Azure SQL Database Connection Strings
Scaling Azure SQL Databases
A common application pattern in building SaaS applications is to provision a single database for each customer.
But different customers often have varying usage patterns making it difficult to predict the resource requirements for each individual database.
Elastic Database Pools solve this problem by allowing you to purchase resources for a pool of databases.
Within a Database Pool, each database can then request resources between specified minimum and maximum parameters.
- Introducing Elastic Database Pools
- Implementing Elastic Database Pools and working with eDTU's
- Creating Elastic Database Pools
- Configuring Elastic Databases
- Monitoring Elastic Database Pools
- Creating Elastic Jobs
Securing user access to Azure SQL databases
Authentication requires that users must prove their identity before they can login to an Azure SQL Server or Database. Authorization is used to control what users can actually do and see inside an Azure SQL Database. Participants will learn how they can work Logins and Users to configure the security of Azure SQL
- Authentication overview
- Configuring Authentication
- Configuring Authorization
- Creating Logins and Users
- Working with contained databases
Monitor an Azure SQL database
- Configuring Database Auditing
- Azure SQL Database threat detection
- Working with Extended Events
Backup, Restore and High Availability
This module describes the capabilities that Azure SQL Database provides for business continuity and disaster recovery. Students will learn about the backup and restore features of an Azure SQL Database, how to setup geo-replication of Azure SQL Databases.
- Business Continuity overview
- Backup of an Azure SQL database
- Restoring an Azure SQL database
- Geo-Restore of an Azure SQL database
- Geo-Replication of Azure SQL databases
Modernizing Your Data Estate with SQL Server 2019
This module covers challenges and solutions using the latest version of SQL Server including:
- Overall SQL Server 2019
- Intelligent Performance
- What's New in Security
- Mission Critical Availability
- Data Virtualization
- SQL Server Linux and Containers
- What Else, Migration and Next Steps
Working with Big Data and Data Science (Big Data Clusters for SQL Server 2019)
Abstraction levels, frameworks, architectures and components within SQL Server big data clusters
Participants of this training will learn about the different offerings of the Microsoft Azure SQL Database platform.
In the first part of the training you will learn about SQL Managed Instances and how they can be used to do a lift-and-shift migration of on-premises databases to the cloud.
In the second part you will learn how to work with the Azure SQL Database offering. The complete database lifecycle from creating and configuring your servers and databases, developing new database objects or migrating existing databases and client applications will be covered.
This 3-day course is intended for existing DBA's and database developers who want to move their databases to the Azure SQL Database platform.
Participants of this course need to have a basic understanding of the Microsoft SQL Server platform.