Azure SQL Data Warehouse Architecture and SQL

Azure SQL Data Warehouse Architecture and SQL

Bascom Bridge’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.

 

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

AZURE SQL TRAINING PREREQUISITES

No prior experience is required.

AZURE SQL TRAINING MATERIALS

All Azure training students receive comprehensive courseware.

SOFTWARE NEEDED FOR EACH PC:

Internet access via Firefox, Chrome, or Internet Explorer is required in order to access the remote environment used for this training.

For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

AZURE SQL TRAINING 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

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


Azure SQL Data Warehouse Architecture and SQL

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : AZR-120
  •  Theory : 50%
  •  Lab : 50%
  • Duration : 18 hours
Scroll Up
Skip to toolbar