MS 20532 – Developing Microsoft Azure Solutions
Module 6: Storing Tabular Data in Azure
Dynamic web applications will invariably need to store the data that is being managed and manipulated by users. ASP.NET has always relied on technologies like ADO.NET and Entity Framework to access data from Microsoft SQL Server. For the cloud, the Microsoft Azure platform provides a SQL as a Service that allows developers to use SQL data and queries in the same manner as they would use in an on-premises implementation. Lesson 1, What Is Azure SQL Database, defines the Microsoft Azure SQL Database service in Azure and the reasons for using it. Lesson 2, Managing SQL Databases in Azure, describes the widely used management tools as well as the new ones available for use with a SQL database hosted in Azure. Lesson 3, Using Azure SQL Databases with SQL Server Data Tools, describes in detail the SQL Server Data Tools (SSDT) templates, panes, and projects available in Microsoft Visual Studio 2015. Lesson 4, Migrating Data to Azure SQL Databases, describes a couple of simple methods to migrate an existing schema and data from an on-premises environment to the cloud. Lesson 5, Using Azure SQL Databases with Entity Framework, provides details on some of the ways you can leverage Entity Framework Code First to your advantage when working with a database that is hosted in the cloud.
- Azure Storage Overview
- Azure Storage Tables Overview
- Table Entity Transactions
Lab: Storing Event Registration Data in Azure Storage Tables
After completing this module, you will be able to:
- Describe the difference between Azure SQL Database editions.
- Explain some of the advantages and disadvantages of hosting databases in SQL Database.
- Explain some of the advantages and disadvantages of hosting databases in a SQL Server installation on an Azure virtual machine.
- Describe the tools that you can use to manage SQL databases in Azure.
- Describe the Visual Studio 2015 features that you can use to manage SQL databases in Azure.
- Describe the options for migrating data from an on-premises environment to the cloud.
- Describe the strategies for using Entity Framework with SQL databases in Azure.
About this Course
This course is intended for students who have experience building ASP.NET and C# applications. Students will also have experience with the Microsoft Azure platform and a basic understanding of the services offered.
This course offers students the opportunity to take an existing ASP.NET MVC application and expand its functionality as part of moving it to Azure. This course focuses on the considerations necessary when building a highly available solution in the cloud. This course also prepares the students for the 70-532: Developing Microsoft Azure Solutions certification exam.
The candidates targeted by this training have basic experience in implementing and monitoring Microsoft Azure solutions. Candidates are also proficient with the development tools, techniques, and approaches used to build application solutions.
At Course Completion
After completing this course, students will be able to:
- – Compare the services available in the Azure platform.
- – Configure and deploy web applications.
- – Creating Azure Web Apps from the gallery.
- – Deploying and monitoring Azure Web Apps.
- – Creating and configuring Azure Virtual Machines.
- – Create and manage a storage account.
- – Manage blobs and containers in a storage account.
- – Create, configure and connect to a SQL Databases instance.
- – Identify the implications of importing a SQL standalone database.
- – Manage users, groups and subscriptions in an Azure Active Directory instance.
- – Create a virtual network.
- – Implement a point-to-site network.
In addition to their professional experience, students must have experience working with the Azure platform. They will also have a general understanding of C# concepts for the lab scenario. Candidates experience can include:
- – Compare the services available in the Azure platform
- – Configure and deploy web applications
- – Creating Azure Web Apps from the gallery
- – Deploying and monitoring Azure Web Apps
- – Creating and configuring Azure Virtual Machines
- – Create and manage a storage account
- – Manage blobs and containers in a storage account
- – Create, configure, and connect to a SQL Databases instance
- – Identify the implications of importing a SQL standalone database
- – Manage users, groups, and subscriptions in an Azure Active Directory instance
- – Create a virtual network
- – Implement a point-to-site network
- 1 Module 1: Overview of the Microsoft Azure Platform Preview
- 2 Module 2: Building Application Infrastructure in Azure Preview
- 3 Module 3: Hosting Web Applications on the Azure Platform Preview
- 4 Module 4: Storing SQL Data in Azure Preview
- 5 Module 5: Designing Cloud Applications for Resiliency Preview
- 6 Module 6: Storing Tabular Data in Azure Preview
- 7 Module 7: Storing and Consuming Files from Azure Storage Preview
- 8 Module 8: Designing a Communication Strategy by Using Queues and Service Bus Preview
- 9 Module 9: Automating Integration with Azure Resources Preview
- 10 Module 10: Securing Azure Web Applications Preview