Netezza SQL

Course Number: IBM-110

Duration: 3 days (19.5 hours)

Format: Live, hands-on

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

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.