Azure - SQL

Name: Azure - SQL
Rating: 4.3 (825 reviews)

In this course, students will get an overview of Azure SQL and also learn how to provision Azure SQL

Created byIntellezy Trainers

Last updated 1/2020

English

English [Auto],

What you'll learn

Overview and provision Azure SQL
Connect to Azure SQL DB and Migrate DB to Azure
Work with SQL security and metrics
Configure SQL DB auditing
Copy and export a database
Use DB Self-Service Restore and SQL DB Geo-Replication

Course content

3 sections • 10 lectures • 41m total length

Introduction1:43
Explore Azure sql as a platform as a service, provisioning and connecting to cloud databases, migrating on premises databases, securing access, monitoring usage, and geo replicate for outage protection.

Azure SQL1:52
Deploy your database into Azure SQL as a platform as a service, removing the need to manage hardware or sequel server, noting database isolation and lack of global temporary tables.
Provisioning Azure SQL6:01
Provision and deploy an Azure SQL database by creating a logical server with a unique name and resource group, selecting a region, configuring firewall, and choosing a standard pricing tier.
Connecting to Azure SQL DB7:31
Learn to connect to Azure SQL DB via SQL Server Management Studio and Data Explorer, configure firewall rules, and use connection strings for secure authentication.
Migrating to Azure DB5:39
migrate on-premises SQL databases to Azure SQL using a deployment wizard and bacpac files, moving from on-prem maintenance to a scalable Azure SQL platform as a service.
Understanding SQL Security3:06
Explore how to secure an Azure SQL environment by configuring firewall rules, virtual networks, server and database roles, logins, and Azure Active Directory users for controlled access.
Understanding SQL DB Metrics and Auditing4:59
Monitor Azure SQL DB throughput and metrics, transaction units, and auditing in the portal, using activity logs, diagnostics, threat protection, and alert rules to optimize performance and costs.
Backing Up and Protecting Your Database5:18
Configure long-term backups for your Azure SQL database with a recovery vault and weekly backups up to 10 years, five-minute restore points. Restore to a different location within 35 days.
Using SQL DB Geo-Replication3:29
Configure geo replication in the Azure portal to replicate your SQL database to a target region such as West US, creating a readable secondary server for near-time replication and resilience.

Requirements

Basic understanding of Azure and SQL concepts

Description

In this course, students will get an over the various Data services available in Azure. They will learn how to provision, configure and manage Azure SQL. While deploying a Logical SQL server to host Azure a DB Students will also connect to Azure SQL DB via SQL Server Management Studio, Migrate an on premises DB to Azure SQL, and work with SQL security and metrics. They will learn how to Configure SQL DB auditing, how to copy and export a database, and also how manage data recovery and availability using DB Self-Service Restore. Finally, they will learn how to use SQL DB Geo-Replication.

Updated May 2018

Who this course is for:

Students wanting an understanding of Azure SQL and to build their skills.

Azure - SQL

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Azure SQL8 lectures • 38min

Conclusion1 lecture • 2min

Requirements

Description

Who this course is for: