Learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure&rsquo,s data services^ from a single database instance to a massive scale data warehouse for working with Big Data.
This course 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.You&rsquo,ll be introduced to data services that Azure provides to store^ manage^ and analyze data. As an alternative to the cost and complexity of managing on-site SQL Server installations^ you&rsquo,ll learn how to quickly set up and start using database applications in Azure. You&rsquo,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.Ongoing monitoring of your database applications is essential so you&rsquo,ll be introduced to tools and techniques that will help you determine usage requirements^ plan upgrades^ and troubleshoot performance and security issues.Finally^ you&rsquo,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. As a distributed database management system that can handle large amounts of data in which analytics play a significant role^ Azure SQL Data Warehouse provides an ideal solution for organizations that work with Big Data and need to scale up and down quickly.