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.
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