SQL Azure
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. Data is hosted, managed and provisioned in Microsoft data centers.
Duration:
Course Content:
Cloud Computing Introduction
- What is Cloud Computing
- Cloud Characteristics
- Cloud Computing Service Models
- Deployment Models in Cloud Computing
- Advantages and Disadvantages of Cloud Computing
Getting Starting with Azure
- Introduction to Azure
- Azure Hosting Models
- Azure Services
- Subscribing to Microsoft Azure
- Azure Portals
- Azure Resource Group
- Installing Microsoft Azure SD
Managing Azure with Windows PowerShell
- Installing the required modules
- Login to Azure Portal
- Creating Resource Group
- Managing Storage Accounts using PowerShell
- Understanding and Working with ARM Template
Windows Azure SQL Database
- Introduction/Overview.
- Comparing SQL Azure Database to Azure / On-Premise SQL Server.
- Creating and Using SQL Server and SQL Database.
- Azure SQL Database Tools.
- Using Azure SQL Database with EF Code First.
- Migrating on premise database to SQL Azure.
- Planning the Deployment
- Elastic Storage.
- Monitoring Azure SQL Database
- Configure SQL Database Auditing
- Manage Business Continuity
- Azure SQL Database vs SQL Server in IaaA VM