About this course:

At the point when you have to scale your data warehouse processing and storage abilities in minutes, not months, you need a cloud-based enormously equal processing arrangement.

In this course of software engineering, you will figure out how to deploy, plan, and load information using Azure SQL Data Warehouse of Microsoft or SQL DW. You'll find out about compressed in-memory indexes, data distribution, elastic scale, and PolyBase for Big Data.

Note: To finish the hands-on components in this course, you will require an Azure membership. You can pursue a free Azure preliminary membership (a legitimate credit card is required for confirmation, yet you won't be charged for Azure services). Note that the free preliminary isn't accessible in all locations. It is conceivable to finish the course and gain credentials without completing the hands-on practices.

Course Objective:

• Choosing an enormously equal processing design for a cloud-based data warehouse.
• Designing indexes and tables to productively distribute information in tables across numerous nodes.
• Loading information from an assortment of sources, querying using PolyBase, integrating into Big Data situations, and securing and recovering information.

Audience:

Data Analyst

Programmers

Prerequisite:

Awareness of database ideas and fundamental SQL inquiry syntax Familiarity with the analytics and reporting needs of the users a willingness to adapt effectively and continue on while troubleshooting specialized issues is basic.