Azure SQL Training Overview
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.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- 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.
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
Training Materials
All Azure training students receive comprehensive courseware.
Software Requirements
Attendees will not need to install any software on their computer 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 be fine.
