EncartaLabs

Actian Matrix SQL

( Duration: 3 Days )

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

By attending Actian Matrix SQL workshop, attendees 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

COURSE AGENDA

1

Introduction

2

What is Columnar?

3

Best Practices for Table Design

4

Systems Tables

5

Compression

6

Temporary Tables

7

Explain

8

Basic SQL Functions

9

The WHERE Clause

10

Distinct Vs Group By AND TOP

11

Aggregation

12

Join Functions

13

Date Functions

14

OLAP Functions

15

Temporary Tables

16

Sub-query Functions

17

Substrings and Positioning Functions

18

Interrogating the Data

19

View Functions

20

Set Operators Functions

21

Statistical Aggregate Functions

22

Nexus

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top