Vue générale
| Code cours | DW501FR | Niveau de compétence | Advanced |
|---|---|---|---|
| Durée | 3.0 Jour(s) | Type de formation | Salle de cours
(Travaux pratiques) |
| Type de cours | Public/Privé | ||
| Prix |
EUR 2 050,00 HT
EUR 2 451,80 TTC |
This course will teach you database administration for the IBM Netezza 1000. This course is designed to give you an overview of the IBM Netezza 1000 architecture and provide a working knowledge and understanding of the Netezza database features and best practices.
Participants
This advanced course is for Database Administrators, System Administrators, Application Developers and Data Warehouse Architects.
Pré-requis
You should have the following background:
- Working knowledge of Unix or Linux
- Experience with Shell Scripting
- Experience with VI Editing
- Basic SQ
Objectifs
- Administer the IBM Netezza 1000
- 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
Contenu
- NzAdmin
- databases and tables
- distribution
- loading and unloading tables
- ODBC / JDBC / OLE-DB client connectivity
- optimizer and query plans
- zone maps and cluster base tables
- materialized views
- statistics
- cross-database access
- transactions
- reclaiming disc space using GROOM
- processing data using stored procedures