Actian Matrix Architecture and SQL

Actian Matrix Architecture and SQL

Actian Matrix is a massively parallel processing database platform designed to deliver top performance.  Bascom  Bridge Bascom  Bridge’s Actian Matrix Architecture and SQL training course teaches attendees the basic and advanced Actian Matrix Architecture and SQL concepts they need to take full advantage of the platform.

ACTIAN MATRIX 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

ACTIAN MATRIX TRAINING PREREQUISITES

No prior experience is required.

ACTIAN MATRIX TRAINING MATERIALS

All Actian Matrix 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.

ACTIAN MATRIX TRAINING OUTLINE

• Introduction
• What is Columnar?
• Best Practices for Table Design
• Systems Tables
• Compression
• Temporary Tables
• Explain
• Basic SQL Functions
• The WHERE Clause
• Distinct Vs Group By AND TOP
• Aggregation
• Join Functions
• Date Functions
• OLAP Functions
• Temporary Tables
• Sub-query Functions
• Substrings and Positioning Functions
• Interrogating the Data
• View Functions
• Set Operators Functions
• Statistical Aggregate Functions
• Nexus
• Conclusion