+01068181373
info@ITeShare.com
Facebook Messenger
+201068181373
Enquire Now
Azure SQL Data Warehouse Architecture and SQL training course teaches attendees basic and advanced concepts of the Azure SQL Data Warehouse Architecture and SQL.
Prerequisites:
No prior experience is required.
Azure SQL Training Objectives
All students will learn:
- 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
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