Studyportals placeholder

Delivering a Data Warehouse in the Cloud, Certificate

Delivering a Data Warehouse in the Cloud, Certificate

  • Application Deadline
  • 42 days
    Duration

About

The Delivering a Data Warehouse in the Cloud Delivering a Data Warehouse in the Cloud course is part of the Microsoft Professional Program Certificate in Big Data from MicrosoftX 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.

Note: To complete the hands-on elements in this course, you will require an Azure subscription. You can sign up for a free Azure trial subscription (a valid credit card is required for verification, but you will not be charged for Azure services).  Note that the free trial is not available in all regions. It is possible to complete the course and earn a certificate without completing the hands-on practices.

Detailed Programme Facts

  • Deadline and start date Application deadline and start date were not specified by the programme.
  • Programme intensity Part-time
    • Average part-time duration 42 days
    • Intensity 2 hrs/week
    • Duration description

      6 weeks 2 to 3 hours per week

  • Languages
    • English
  • Delivery mode
    Online
    • Time flexibility
      Self-paced

Programme Structure

Courses include:
  • Key Concepts of SQL DW and MPP
  • Provisioning a SQL Data Warehouse
  • Designing Tables and Loading Data
  • Integrating SQL DW in a Big Data Solution

Lecturers

  • Chris Randall - Senior Content Developer, Microsoft Learning Experiences
  • Chris Testa-O'Neill

English Language Requirements

This programme requires 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 Applies to you

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

    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.