• Anytime
    Application Deadline
  • 42 days
    Duration

About

The Delivering a Data Warehouse in the Cloud course is part of the Microsoft Professional Program Certificate in Big Data from MicrosoftX.

When you need to scale your data warehouse's storage and processing capabilities in minutes, not months, you need a cloud-based massively parallel processing solution.

In this computer science course, you will learn how to deploy, design, and load data using Microsoft's Azure SQL Data Warehouse, or SQL DW. You'll learn about data distribution, compressed in-memory indexes, PolyBase for Big Data, and elastic scale.

What you'll learn:

  • Choosing a massively parallel processing architecture for a cloud-based data warehouse.
  • Designing tables and indexes to efficiently distribute data in tables across many nodes.
  • Loading data from a variety of sources, querying using PolyBase, securing and recovering data, and integrating into Big Data environments.

Detailed Programme Facts

  • Deadline and start date A student can apply at any time for this programme, there is no deadline.
  • Programme intensity Part-time
    • Average part-time duration 42 days
    • Part-time variant
      Flexible
    • Duration description

      6 weeks

      2 to 3 hours per week

  • Languages
    • English
  • Delivery mode
    Online
  • More information Go to the programme website

Programme Structure

Courses include:
  • Introducing SQL Data Warehouse
  • Designing and Querying Data Warehouses
  • Integrating and Ingesting Data
  • Managing Data Warehouses

English Language Requirements

This programme may require students to demonstrate proficiency in English.

Academic Requirements

Prerequisites:
  • Familiarity with database concepts and basic SQL query syntax
  • Familiarity with the reporting and analytics needs of users
  • A willingness to learn actively and persevere when troubleshooting technical problems is essential

Tuition Fee

  • International

    99 USD/full
    Tuition Fee
    Based on the original amount of 99 USD for the full programme and a duration of 42 days.
  • National

    99 USD/full
    Tuition Fee
    Based on the original amount of 99 USD for the full programme and a duration of 42 days.
We've labeled the tuition fee that applies to you because we think you are from and prefer over other currencies.
5% discount coupon: Z7LZNQ4TN3B2JTWU valid for any free course + certificate upgrade

Funding

Check the programme website for information about funding options.

StudyPortals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.

The Global Study Awards: get funded with up to £10,000 to study abroad

Together with the ISIC Association and British Council IELTS, Studyportals offers you the chance to receive up to £10000 to expand your horizon and study abroad. We want to ultimately encourage you to study abroad in order to experience and explore new countries, cultures and languages.