microsoft partner logo color
8245  Reviews star_rate star_rate star_rate star_rate star_half

Azure SQL Data Warehouse Architecture and SQL

Accelebrate's Azure SQL Data Warehouse Architecture and SQL training course teaches attendees basic and advanced concepts of the Azure SQL Data Warehouse Architecture and SQL. Skills Gained Basic SQL...

Read More
Course Code AZR-120
Duration 3 days
Available Formats Classroom

Accelebrate's Azure SQL Data Warehouse Architecture and SQL training course teaches attendees basic and advanced concepts of the Azure SQL Data Warehouse Architecture and SQL.

Skills Gained

  • Basic SQL Functions
  • The WHERE Clause
  • Distinct Vs. Group By
  • Aggregation Function
  • Join Functions
  • Date Functions
  • OLAP Functions
  • Temporary Tables
  • Sub-query Functions
  • Strings
  • Interrogating the Data
  • View Functions
  • Set Operators
  • Data Manipulation Language (DML)
  • Statistical Aggregate Functions

Prerequisites

No prior experience is required.

Course Details

Training Materials

All Azure training students receive comprehensive courseware.

Software Requirements

Attendees will not need to install any software on their computers for this class. The class will be conducted in a remote environment that Accelebrate will provide; students will only need a local computer with a web browser and a stable Internet connection. Any recent version of Microsoft Edge, Mozilla Firefox, or Google Chrome will work well.

Outline

  • Introduction to the Azure SQL Data Warehouse
  • The Azure SQL Data Warehouse Table Structures
  • Hashing and Data Distribution
  • The Technical Details
  • CREATE Statistics
  • The Basics of SQL
  • The Where Clause
  • Distinct, Group By and TOP
  • Aggregation
  • Join Functions
  • Date Function
  • Temporary Tables
  • Sub-query Functions
  • Window Functions OLAP
  • Working with Strings
  • Interrogating the Data
  • Table Create and Data Types
  • View Functions
  • Data Manipulation Language (DML)
  • Set Operators Functions
  • Stored Procedure Functions
  • Statistical Aggregate Functions
  • Systems Views
  • Nexus
  • Conclusion