Kognitio Architecture and SQL

PT15202
Training Summary
In this course, students will learn the Kognitio Architecture and Kognitio SQL starting at the most basic level and going to the most advanced level with many examples.
Prerequisites
There are no prerequisites for this course.
Duration
2-3 Days/Lecture & Lab
Audience
This course is designed for anyone who has a desire to learn Kognitio SQL from beginners to an advanced audience. This course is completely customizable by the client.
Course Topics
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

Related Scheduled Courses