Duration: 3 Days
This course will introduce you to the concepts and architecture behind IBM PureData System for Analytics N1001 and N2001 series appliances. In addition it will teach database design, query analysis and query development for the IBM PureData System for Analytics N1001 and N2001 series appliances. This course is also designed to give you a working knowledge of the IBM PureData System for Analytics N1001 and N2001 database features and best practices.
What You Will Learn
- Administer the IBM PureData System for Analytics appliances
- 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
Audience
This intermediate course is for Database administrators, system administrators, application developers, and data warehouse architects.
Prerequistes
You are required to have a working knowledge of UNIX or Linux, experience with shell scripting, experience with VI editing, and basic SQL.
Course Outline
- Origins of Appliances
- PureData System for Analytics appliance architecture
- Connecting to the appliance
- Managing user permissions and privileges
- Using the NzAdmin tool
- Usage of databases and tables
- Insights into distribution methods
- Configuring client connectivity
- Importance of the optimizer and query plans
- Mechanics of zone maps and cluster based tables
- Usage of materialized views
- Statistics and their relationship to snippet execution
- Accessing data in multiple databases
- Defining what constitutes a transaction
- Implications and mechanism of the GROOM functionality
- Developing Stored Procedures
- Generate statistics
- Analyze query plans
- Create materialized views
- Reclaim unused disk space
- Program stored procedures
Course Labs
