The IBM PureData System for Analytics - Essentials training course will teach database administration for the IBM PureData System for Analytics appliances. This course is designed to provide an overview of the IBM PureData System for Analytics architecture and provide a working knowledge and understanding of the Netezza database features and best practices. This course is designed to give you a working knowledge and understanding on IBM PureData System for Analytics internals to optimize IBM PureData System for Analytics performance and tune system parameters.
The IBM PureData System for Analytics - Advanced training course teaches you advanced database administration skills for the IBM PureData System for Analytics (PDA) N1001 and N2001 appliances. This course is designed to give you a working knowledge and understanding on IBM PureData System for Analytics (PDA) N1001 and N2001 appliance internals to optimize IBM PDA performance and tune system parameters.
By attending IBM PureData System for Analytics - Essentials workshop, delegates will learn to:
- Administer the IBM PureData System for Analytics
- Configure client connectivity
- Create databases and tables
- Determine distribution methods
- Set up Clustered Base Tables
- Load and unload tables
- Generate statistics
- Analyze query plans
- Create materialized views
- Reclaim unused disk space
- Program stored procedures
- Analyze Plan files
- Perform query analysis and troubleshooting
- Optimize data distributions
- Interact with advanced CLI commands
- Use nzsql and workload management
By attending IBM PureData System for Analytics - Advanced workshop, delegates will learn to:
- Analyze Plan files
- Perform query analysis and troubleshooting
- Optimize data distributions
- Interact with advanced CLI commands
- Use nzsql and workload management:
- Determine workload management requirements
- Make use of the System Management functionality
- Working knowledge of UNIX or Linux, experience with shell scripting, experience with VI editing, and basic SQL.
This IBM PureData System for Analytics class is recommended for:
- Database administrators
- System administrators
- Application developers
- Data warehouse architects