EncartaLabs

Kognitio SQL

( Duration: 3 Days )

Kognitio SQL is a fast, scalable in-memory analytical platform available on a subscription basis using public or private cloud. This Kognitio SQL training course teaches attendees how to leverage the power of Kognitio and SQL to achieve their analytical goals.

By attending Kognitio 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 to the Kognitio Architecture

2

Kognitio Table Structures

3

Nexus for Kognitio

4

The Basics of SQL

5

The WHERE Clause

6

Distinct, Group By and TOP

7

Aggregation

8

Join Functions

9

Date Functions

10

Sub-query Functions

11

OLAP Functions

12

Temporary Tables

13

Strings

14

Interrogating the Data

15

Set Operators Functions

16

View Functions

17

Table Create and Data Types

18

Data Manipulation Language (DML)

19

Kognitio Explain

20

Statistical Aggregate Functions

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