Duration
5 days
Audience
This course is for database administrators, system administrators, application developers, and data warehouse
architects.
Course Outline
- Data warehouse overview
- Architecture
- Connecting to the IBM PureData System for Analytics host
- Managing user access to the IBM PureData System for Analytics database
- Administration tools
- Databases and tables and schemas
- Distributions
- Loading and unloading tables
- ODBC, JDBC, OLEDB client connectivity
- Optimizer and query plans
- Zone maps and Clustered Base Tables (CBT)
- Materialized views
- Generate statistics
- Cross-database access
- Transactions
- GROOM
- Stored procedures
- High availability architecture
- DBOS internals and system log files
- nzsql and scripting
- nzevents and event processing
- Analyzing plan files
- Analyzing and optimizing query performance
- Workload management
- System management
- Configuring query history
- Backup and restore
- Security including authenticating users with LDAP, SSL
Programme scope, delivery arrangements and suitability are confirmed during enquiry.