Azure – SQL

Course Description

SQL Azure is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. 

This Azure – SQL focuses primarily on Azure SQL Database as a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software. Learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure’s data services, from a single database instance to a massive scale data warehouse for working with Big data. You’ll gain an understanding of how to configure firewall rules, manage log-ins and users, as well as roles and permissions, perform a database restore, and generally secure an Azure SQL database.

Finally, you’ll be introduced to Azure SQL Data Warehouse, a fully managed and scalable cloud service, that is compatible with other Azure offerings, such as Machine Learning and Data Factory, as well as existing SQL Server tools.

What Will I 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

Who is the target audience?

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

Requirements