Overzicht
| Cursuscode | DW501BE | Leermethode | Klassikaal
(Hands-on labs) |
|---|---|---|---|
| Duur | 3.0 dagen | Type cursus | Publiek/privaat onsite |
| Prijs |
EUR 2.050,00 excl BTW
EUR 2.480,50 incl BTW |
This course will teach participants database administration for the IBM Netezza 1000. This course is designed to give the participant an overview of the IBM Netezza 1000 architecture and provide a working knowledge and understanding of the Netezza database features and best practices.
Bekijk deze cursus in andere landen
Roadmaps:
Deelnemers
This course is for Database Administrators, System Administrators, Application Developers and Data Warehouse Architects.
Vooropleiding
You should have the following background:
- Working knowledge of Unix or Linux
- Experience with Shell Scripting
- Experience with VI Editing
- Basic SQL
Doelstelling
- 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
Onderwerpen
- where data warehouse appliances come from
- IBM Netezza data warehouse architecture
- connecting to IBM Netezza data warehouse applicance host
- managing user access to IBM Netezza database'
- 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