Kursbeskrivning: IBM Netezza 6.0 New Features

In this course, we will highlight the enhancements to the IBM Netezza Platform Software (NPS) Version 6.x. You will learn how to apply new features including:

• Password Management Enhancements
• Ability to ADD and DROP columns using the ALTER TABLE command
• Clustered base Tables
• New data load formats options
• Non-locking reclaim (Groom)
• Improvements to Work Load Management
• Multi-destination backup and restore
• OLAP
• NZPortal

Visa den här kursen i andra länder

Tillbaka till toppen

This course is for Application Developers, System Administrators, Data Warehouse Architects, and Database Administrators who are familiar with IBM Netezza Platform Software (NPS) Version 5.x.

Tillbaka till toppen

You should have the following background:

• Netezza Data Warehouse Appliance Usage 5.0 (required)

Tillbaka till toppen

• Utilize Password Management Features
• ADD and DROP columns from a table
• Implement Clustered Base Tables to improve query performance
• Load data using the new formats options
• Use Non-locking reclaim (Groom)
• Manage access to the Netezza Appliance using improved Work Load Management (WLM)
• Conduct backups and restores with Multi-destination files
• Use the three new OLAP commands: Grouping Sets, Rollup, and Cube

Tillbaka till toppen

• Password Management Enhancements
• Ability to ADD and DROP columns using the ALTER TABLE command
• Clustered base Tables
• New data load formats options
• Non-locking reclaim (Groom)
• Improvements to Work Load Management
• Multi-destination backup and restore
• OLAP
• NZPortal

Tillbaka till toppen