IBM Netezza admin training
Training
Online
Description
-
Type
Training
-
Level
Beginner
-
Methodology
Online
-
Class hours
35h
-
Duration
Flexible
-
Start date
Different dates available
The objective of this course is to enrich an associate with end-to-end knowledge on IBM Netezza Database Administration to handle day-to-day and any complex business needs.
Facilities
Location
Start date
Start date
About this course
We are very specialised for one to one training
Will start the training with in 48 hrs
Reviews
Subjects
- Database training
- Database
- IBM
- Netezza
- Netezza Appliances
- Data warehouse Architecture
- Netezza Database
- NzAdmin
- GUI Admin
- Netezza Transactions
- Query Plans
- Optimizer
Course programme
- About Netezza & Various Netezza Appliances
- Netezza Data warehouse Architecture
- Netezza High Availability Architecture
- Netezza Command Line Interface (CLI)
- Managing User Access to the Netezza Database
- NzAdmin: GUI Admin Tool
- Databases & Tables
- Data Distribution
- Data Types
- Netezza Transactions
- Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE
- Data Loading/Unloading using ETL tools
- Netezza system tables, views, and user tables
- Netezza stored procedures
- Generate Statistics
- Optimizer and Query Plans
- Zone Maps
- Materialized Views
- Reclaiming Space with NZRECLAIM, Groom Table
- Backup and Restore (Host, Database, Table)
- Client Installations
- ODBC/JDBC/OLEDB Client connectivity
- Database Refreshes, Data Migrations
- Techniques to improve Netezza performance
- Netezza Replication/DR architecture
- Working with IBM Netezza support to resolve issues
IBM Netezza admin training