Kognitio Architecture and SQL Training

In this training class, 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.

Goals
  1. Learn to gain a deeper knowledge and understanding of the Kognitio Architecture and Kognitio SQL and how to write it.
Outline
  1. Introduction to the Kognitio Architecture
    1. What is Parallel Processing?
    2. The Basics of a Single Computer
    3. Data in Memory is fast as Lightning
    4. Parallel Processing Of Data
    5. Kognitio is an In-Memory System
    6. Kognitio has Three Table Distribution Options
    7. Kognitio has Linear Scalability
    8. Nexus is Now Available for Kognitio
  2. Kognitio Table Structures
    1. Kognitio has Three Table Distribution Options
    2. A Table that is distributed via a Round Robin Technique
    3. Round Robin Technique is the Default
    4. Random Distribution
    5. A Table that is distributed by Hash
    6. Tables that join are excellent candidates for Hashed Tables
    7. Hash Distribution
  3. Nexus for Kognitio
    1. Nexus is Available on the Cloud
    2. Nexus Queries Every Major System
    3. How to Use Nexus
    4. Why is Nexus Special? Visualization and Automatic SQL
    5. Why is Nexus Special? Cross-System Joins
    6. Why is Nexus Special? The Amazing Hub System
    7. Why is Nexus Special? Save Answer Sets as Tables
    8. Why is Nexus Special? Automated Data Movement
    9. Why is Nexus Special? Nexus makes the Servers Talk Directly
    10. What Makes Nexus Special? The Garden of Analysis
    11. The Garden of Analysis Grouping Sets Tab
  4. The Basics of SQL
    1. Introduction
    2. Setting the Default Schema
    3. SELECT * (All Columns) in a Table
    4. Fully Qualifying a Database, Schema and Table
    5. SELECT Specific Columns in a Table
    6. Commas in the Front or Back?
  5. The WHERE Clause
    1. The WHERE Clause limits Returning Rows
    2. Double Quoted Aliases are for Reserved Words and Spaces
    3. Character Data needs Single Quotes in the WHERE Clause
    4. Character Data needs Single Quotes, but Numbers Don't
    5. Comparisons against a Null Value
    6. NULL means Unknown Data so Equal (=) won't return rows
    7. Use IS NULL or IS NOT NULL when dealing with NULLs
  6. Distinct, Group By and TOP
    1. The Distinct Command
    2. Distinct vs. GROUP BY
    3. Quiz How many rows come back from the Distinct?
    4. Answer How many rows come back from the Distinct?
    5. TOP Command
    6. TOP Command with an ORDER BY Statement
    7. Just Place the TOP n in front of any Query
  7. Aggregation
    1. Quiz You calculate the Answer Set in your own Mind
    2. Answer You calculate the Answer Set in your own Mind
    3. Quiz You calculate the Answer Set in your own Mind
    4. Answer You calculate the Answer Set in your own Mind
    5. The 3 Rules of Aggregation
    6. There are Five Aggregates
  8. Join Functions
    1. A Two-Table Join Using Traditional Syntax
    2. A two-table join using Non-ANSI Syntax with Table Alias
    3. You Can Fully Qualify All Columns
    4. A two-table join using ANSI Syntax
    5. Both Queries have the same Results and Performance
    6. Quiz Can You Finish the Join Syntax?
    7. Answer to Quiz Can You Finish the Join Syntax?
    8. Quiz Can You Find the Error?
  9. Date Functions
    1. Current_Date
    2. Current_Date and Current_Time
    3. Current_Date and Current_Timestamp
    4. Current_Timestamp with Milliseconds
    5. Current_Timestamp with Microseconds
    6. Current_Timestamp and SYSDATE are Synonyms
    7. The Now Function
    8. Adding Days, Weeks and Months to a Date
  10. Sub-query Functions
    1. An IN List is much like a Subquery
    2. An IN List Never has Duplicates Just like a Subquery
    3. An IN List Ignores Duplicates
    4. The Subquery
  11. OLAP Functions
    1. The Row_Number Command
    2. Using a Derived Table and Row_Number
    3. Finding the First Occurrence
    4. Finding the Last Occurrence
    5. Quiz How did the Row_Number Reset?
    6. Answer How did the Row_Number Reset?
    7. RANK Defaults to Ascending Order
    8. Getting RANK to Sort in DESC Order
    9. RANK OVER and PARTITION BY
    10. RANK and DENSE RANK
    11. CSUM
    12. CSUM The Sort Explained
    13. CSUM Rows Unbounded Preceding Explained
    14. CSUM Making Sense of the Data
    15. CSUM Making Even More Sense of the Data
    16. CSUM The Major and Minor Sort Key(s)
  12. Temporary Tables
    1. There are Two Types of Temporary Tables
    2. CREATING A Derived Table
    3. Naming the Derived Table
    4. Aliasing the Column Names in the Derived Table
    5. Multiple Ways to Alias the Columns in a Derived Table
  13. Strings
    1. The LENGTH Command Counts Characters
    2. The LENGTH Command Spaces can Count too
    3. The LENGTH Command Counts Trailing Spaces
    4. The LENGTH Command and TRIM
    5. UPPER and LOWER Commands
    6. Using the LOWER Command
    7. Using the UPPER Command
    8. Non-Letters are Unaffected by UPPER and LOWER
    9. The CHARACTERS Command Counts Characters
  14. Interrogating the Data
    1. The NULLIF Command
    2. The COALESCE Command Fill In the Answers
    3. The COALESCE Answer Set
    4. The COALESCE Command
    5. The COALESCE Answer Set
    6. The COALESCE Quiz
    7. Answer - The COALESCE Quiz
  15. Set Operators Functions
    1. Rules of Set Operators
    2. INTERSECT Explained Logically
    3. INTERSECT Explained Logically
    4. UNION Explained Logically
    5. UNION Explained Logically
    6. UNION ALL Explained Logically
    7. UNION ALL Explained Logically
  16. View Functions
    1. The Fundamentals of Views
    2. Creating a Simple View to Restrict Sensitive Columns
    3. Creating a Simple View to Restrict Rows
    4. Basic Rules for Views
    5. Exception to the ORDER BY Rule inside a View
    6. Views sometimes CREATED for Formatting
  17. Table Create and Data Types
    1. Kognitio Has Three Table Distribution Options
    2. A Table that is distributed via a Round Robin Technique
    3. Round Robin Technique is the Default
    4. A Table that is distributed by Hash
    5. Tables that join are excellent candidates for Hashed Tables
    6. A Table that is distributed by Hash by Multiple Columns
    7. The Reasons for a Multi-Column HASHED Distribution Key
    8. Creating a Table that is replicated across all Nodes
    9. The Concept is all about the Joins
  18. Data Manipulation Language (DML)
    1. INSERT Syntax # 1
    2. INSERT example with Syntax 1
    3. INSERT Syntax # 2
    4. INSERT example with Syntax 2
    5. INSERT example with Syntax 3
  19. Kognitio Explain
    1. How to See an EXPLAIN Plan
    2. Seeing an EXPLAIN Plan with Nexus
    3. The Eight Rules to Reading an EXPLAIN Plan
    4. Interpreting Keywords in an EXPLAIN Plan
    5. Interpreting an EXPLAIN Plan
    6. A Single Segment Retrieve The Fastest Query
  20. Statistical Aggregate Functions
    1. The Stats Table
    2. Numeric Manipulation Functions
    3. Ceiling Gets the Smallest Integer Not Smaller Than X
    4. Floor Finds the Largest Integer Not Greater Than X
    5. The Round Function and Precision
    6. The STDDEV_POP Function
    7. A STDDEV_POP Example
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Preparing for Class

Training for your Team

Length: 3 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

Training once again was great !! Webucator and Trainer did not let me down.
Janet Kimson
Great instructor! Class was tailored to our needs as a company. We will invite Webucator back!
Lori Council
Midwest Mole Inc
Great class! And great instructor! The learning materials are extremely beneficial and the class seemed well outlined. Definitely looking forward to taking additional classes with Webucator.
Ana Ochoa
Federal Emergency Management Agency (FEMA)
The instructor was great. The pace of the class was perfect.
Kelly Hayes
Methodist Hospital for Surgery

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,008

Students who have taken Instructor-led Training

11,712

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 28,955 reviews

Contact Us or call 1-877-932-8228