IBM Netezza is a subsidiary of IBM company and it is mainly used to market high-performance data warehouse appliances. Netezza appliances are now considered as PureData System for Analytics. 

Topics Covered in this module are:

  • Overview of Netezza
  • Netezza fundamental principles
  • Netezza components
  • Host file systems
  • Key features of Netezza
  • Advantages of using IBM Netezza 

In this module, you will get a clear idea of NPS AMPP Architecture and its key components.

Topics Covered in this module are:

  • Overview of Netezza AMPP Architecture
  • Key components in Netezza AMPP Architecture
  • The terminology used in Netezza Architecture
  • Installation of the Netezza system
  • Installation of Netezza EmulatorGUI Admin Tools

In IBM Netezza, the Command Line Interface (CLI) is mainly used to issue commands to manage Netezza databases, hardware, and software. The Netezza CLI commands are used to manage and monitor a Netezza system.

Topics Covered in this module are:

  • Use of Command Line Interface in Netezza
  • How to manage Netezza software and hardware using Netezza CLI
  • Monitoring Linux Logs
  • How to monitor a Netezza system.
  • Netezza Events

In this module, you will gain in-depth knowledge of the Data Distribution and distribution key values. The Distribution key in Netezza is used to increase session performance with parallel processing.

Topics Covered in this module are:

  • Data Distribution
  • Distribution Keys and Distribution columns
  • Multi-Column Distribution
  • Broadcasting
  • Data Loading using External Tables
  • Database Object Creation
  • Data Loading using NZLOAD

In this module, you will gain expertise in Database Backup and Restore processes, and also you will know in detail about the storage unit and operations performed to manage database levels.

Topics Covered in this module are:

  • Global Backups and Restores
  • Schema Level backups and restores
  • Netezza EventsWork Load Management
  • Host level backups and restores
  • NZSYSTEM overview
  • Resource sharing groups
 
Load More