Here is another popular lab from Hands-On-Lab library: Create and Manage Azure SQL Data Warehouse.
Azure SQL Data Warehouse is a cloud based, scale-out, relational database capable of processing massive volumes of data. SQL Data Warehouse combines the SQL Server relational database with Azure cloud scale-out capabilities. It uses T-SQL and other Microsoft tools like SQL Server Management Studio to work with the Azure Data Warehouse. At any point of time, you can increase and decrease the computing power for Azure Data warehouse without any downtime. In this lab, we will see how to create a SQL Server at Azure and then how to create the Azure SQL Data Warehouse. In the first exercise, we will learn to create Azure SQL Server and Azure data warehouse. In the second exercise, we will learn to configure firewall option which is used to connect Azure Data warehouse with On-Premises SSMS and also learn to create login and user for Data Warehouse. In the third exercise, we will learn to load data into Azure Data warehouse from On-Premises SQL server.
Exercise 1: Create Azure SQL Server and Create Azure Data Warehouse.
Exercise 2: Configure firewall option, Connect Azure Data warehouse with On-Premises SSMS, Create login and user for Data Warehouse
Exercise 3: Load data into Azure Data warehouse from On-Premises SQL server.
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.
Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.
Happy Learning – The Practical Way.
Leave A Comment