Course details
This course will teach participants database administration for the IBM PureData System for Analytics (PDA) N1001 and N2001 appliance. This course is designed to give the participant an overview of the IBM PureData System for Analytics (PDA) architecture and provide a working knowledge and understanding of the PDA database features and best practices. It includes content and labs on the features introduced in NPS 7 including full schema support.
Target Audience:
This course is for Database administrators, system administrators, application developers, and data warehouse architects.
Prerequisites:
You are required to have a working knowledge of UNIX or Linux, experience with shell scripting, experience with VI editing, and basic SQL.
Content:
- 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
Course Location
About Global Knowledge Egypt
Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.
See all Global Knowledge Egypt courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- EGP 2,031Duration: 1 To 2 Months
- GCP Essentials - Level 3 Study 365EGP 1,148Duration: 5 Hours
