title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Netezza Architecture and SQL
Duration
3 Days
Course
NETZ-120
Available Formats
Classroom Training, Online Training
Course Description
Overview
In this course, students will learn the Netezza Architecture starting at the most basic level and going to the most advanced level with many examples. This will be enhanced for performance tuning as the students get to do Netezza hands-on training with SQL.Objectives
Upon completion of the Netezza Architecture and SQL course, students will have a deeper knowledge and understanding of the Netezza Architecture and how to tune it. They will also know all SQL commands and their options.
Topics
- How Netezza Works
- A Chip Off The Old Block
- How Netezza Distributes the Data
- Deep Dive Inside a Netezza Extent and Row
- How Joins Work Internally
- CTAS and CBT
- Temporary Tables
- Materialized Views
- Collecting Statistics
- Using nzsql
- Creating Tables
- Systems Views
- Explains
- 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
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.