Azure SQL Data Warehouse Architecture and SQL
Azure SQL Data Warehouse Architecture and SQL training course teaches attendees basic and advanced concepts of the Azure SQL Data Warehouse Architecture and SQL.
Duration: 25hrs
Course Content:
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