Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professional which is having working experience from Top IT companies. The Training in is every thing we explained based on real-time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.
Course Content
Netezza Training Course Curriculum
Contents (Unit:1):
- About Netezza
- Netezza AMPP Architecture
- Netezza Architecture fundamental principles
- Netezza components terminology: FPGA Core, CPU Core, Disk, Host, S-Blade, SPU, SPA, Disk Enclosure
- Various other Datawarehouse appliances in the market
- Netezza Host Filesystems (/nz, /export/home, /nzscratch)
- Host High availability and clustering
- Controlling DRBD with Heartbeat
- Netezza HA Administration
- Netezza disk mirroring (Replication, Failover, Regeneration)
- S-Blade Failover
- Netezza Emulator Installation
- Netezza IP Addresses
- Standard Log Files (Netezza, Linux)
- Introduction to Netezza Command Line Interface (CLI)
- Netezza CLI options
- Finding Netezza system status (NZSTATE)
- Netezza SQL Introduction
- Netezza Environment Variables
- NZSQL command-line options
- NZSQL Internal slash commands
- Create Database, Table, Synonym, Sequence
- Create View, Materialized views, user, groups
- System tables, views, privileges (object, administrative)
- SQL Identifiers, Netezza Data types, Internal Datatypes
Contents (Unit:2):
- Data Distribution (Hash, Random)
- Data Distribution: Collocated Joins
- Data Distribution: Single/Double Redistribution, Broadcasting
- Multi-Column Distribution
- Data Distribution: Best Practises
- Data Loading/Unloading using External Tables
- Data Loading/Unloading using Compressed External Tables
- Data Loading using NZLOAD
- Data Loading using NZLOAD fixed format
Contents (Unit:3):
- Database Level backups/restores (Full, Differential, Cumulative)
- Schema Level backups/restores
- Global backups/restores
- Host level backups/restores
- Netezza Events (Setup & Monitoring)
- Query/Audit history collection
- Work Load Management
- Concurrent Jobs
- Resource Sharing Groups
- Gatekeeper Scheduler
- GRA Scheduler
- Snippet Scheduler
- Resource Scheduler
- Short Query Bias
- NZSYSTEM: Change system registry values
- Introduction to NZSTOP, NZSTART, NZSYSTEM RESTART
Contents (Unit:4):
- NZADMIN Installation
- ODBC Drivers Installation
- Aginity workbench installation
- Extents & Zone maps
- Clustered Base Tables (CBT)
- Groom table
- Skew Table
- Transactions
- Statistics(Database, Table, Column, System)
- NZ* commands
- Netezza Appliance models
- Netezza System logs
- Functions, Operators
- Table constraints
- Joins, Stored procedures, SQL Extensions
For More Details