Code: DW52
Duration: 5 days
Description
This course will teach participants database administration for the IBM PureData System for Analytics appliances. It is designed to give the participant 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 also teaches participants advanced database administration skills for the IBM PureData System for Analytics Advanced Concepts System. It is designed to give participants a working knowledge and understanding on IBM PureData System for Analytics internals to optimize IBM PureData System for Analytics performance and tune system parameters. This course provides an overview of IBM PureData System for Analytics administration and analysis.
Outcomes
- 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
Audience
Prerequisites
- Working knowledge of UNIX or Linux
- Eexperience with shell scripting,
- Experience with VI editing
- Basic SQL