Duration: 5 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.
You will also learn about the operational aspects of database administration, for the IBM PureData System for Analytics N1001 and N2001 appliances. You will learn about the High Availability, Backup and Restore, and Security aspects of the IBM PureData System for Analytics N1001 and N2001, so that SLAs can be met and service can be maintained. This course also teaches you how to manage the performance characteristics of the system through workload management and system parameters. Lastly, this course provides you with the knowledge to assist developers in tuning SQL queries to maximize performance.
This course is a combination of IBM PureData System for Analytics Usage (DW502) and IBM PureData System for Analytics Advanced Concepts (DW511).
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
- Analyze Plan files
- Perform query analysis and troubleshooting
- Optimize data distributions
- Interact with advanced CLI commands
- Use nzsql
- Determine workload management requirements
- Make use of the System Management functionality
Audience
This advanced course is for database administrators, system administrators, application developers and data warehouse architects.
Prerequistes
You should have:
- Working knowledge of Unix or Linux
- Experience with Shell Scripting
- Experience with VI Editing
- Basic SQL experience
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
- How High Availability is implemented in PureData System for Analytics
- Understanding the Database Operating System (DBOS) and it log files
- How to write scripts in nzsql
- How to take advantage of the nzevents functionality
- Reading query plan files and explaining the implications of snippet characteristics
- Discovering and rectifying query performance problems
- Configuring Workload Management
- Working with system management tools
- Configuring the retention of query plan history
- Developing backup and restore procedures
- Administering security
Course Labs
