Netezza SQL Training Overview
IBM® Netezza® appliances are now part of IBM PureSystems, a quick, efficient integrated data analytics system that optimizes performance and runs complex algorithms.
Accelebrate's Netezza SQL training class teaches students how to write efficient big data queries using Netezza SQL.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, online classes for individuals.
See a schedule of online courses.
Objectives
- 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
Prerequisites
No prior experience is required.
Outline
Introduction
Basic SQL Functions
The WHERE Clause
Distinct Vs Group By
Review
Aggregation Function
Join Functions
Date Functions
OLAP Functions
Temporary Tables
Sub-query Functions
Substrings and Positioning Functions
Interrogating the Data
View Functions
Set Operators Functions
Data Manipulations
Tables, DDL, and Data Types
Statistical Aggregate Functions
Stored Procedure Functions
Nexus Query Chameleon
Conclusion
Training Materials:
All Netezza training students receive comprehensive courseware, available electronically.
Software Requirements:
We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide. Please ask us for details.
