Netezza Development Online Training
0 STUDENTS ENROLLED
Pre requisites:
- Basic Operating system knowledge and Unix/Linux commands exposure
- Basic knowledge on SQL statements and RDBMS concepts
- Developer experience on any OLTP/OLAP environments is an added advantage
Lab setup:
- Windows 7/8 64 bit machine that supports Virtualization
- 6GB+ RAM; 100GB+ hard disk
- VMWARE 10 or above
- Netezza Emulator 7.x
Training Material:
- Class PPT’s (Soft copy)
- Netezza 7.x PDF’s (Soft copy)
- Netezza Emulator setup softwares
Course Outline:
- NPS AMPP Architecture (1 hour)
- NPS High availability architecture (Clustering, mirroring, failover) (1 hour)
- Netezza Emulator Setup (2 hours)
- Installations: Drivers, Aginity, NZADMIN (2 hours)
- Netezza SQL (NZSQL) & backslash commands (2 hours)
- Creation of database objects such as databases, tables, etc (2 hour)
- Data distribution & best practices (Random, Hash) (2 hour)
- Data Loading and Unloading (CLI, GUI) (3 hours)
- Analyzing Optimizer & Query plans (1 hour)
- Statistics, Zonemaps, CBT (1 hour)
- Table Skew, Groom table (1 hour)
- Views, System Views, Materialized Views (1 hour)
- Functions, SQL Extensions, Joins, Subqueries (1 hour)
- Stored procedures, SQL Analytical Functions (2 hours)
- Performance Tuning Best Practices (1 hours)
- Netezza CLI commands (1 hours)
- Netezza 7.1 & 7.2 features
Contents (Day1 – 8 hours):
- 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 Netezza appliance models in the market
- Various other Datawarehouse appliances in the market
- Netezza Host Filesystems (/nz, /export/home, /nzscratch)
- Host, S-blade, disk High availability
- Netezza Emulator Installation
- Netezza drivers, Aginity Workbench Installation
- 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
- Netezza SQL Commands
- Lab: Emulator installation, NZSQL Internal slash commands, Netezza SQL Commands
Contents (Day2 – 8 hours):
- Create Databases and Tables, Table, Synonym, Sequence
- Create View, Materialized views,
- Create users, groups
- Create Synonyms, Sequences
- System tables, views, privileges (object, administrative)
- SQL Identifiers, Netezza Data types, Internal Data types
- Data Distribution (Hash, Random)
- Data Distribution: Collocated Joins
- Data Distribution: Single/Double Redistribution, Broadcasting
- Multi Column Distribution
- Data Distribution: Best Practices
- Data Loading/Unloading using External Tables
- Data Loading/Unloading using Compressed External Tables
- Table backup using CTAS
- Data Loading using NZLOAD
- Data Loading using NZLOAD fixed format
- Lab: Database objects creation, Data Loading/unloading (both CLI & GUI)
Contents (Day3 – 8 hours):
- Analyzing optimizer plans
- Extents & Zonemaps
- Clustered Base Tables (CBT)
- Groom table
- Skew Table
- Transactions
- Statistics(Database, Table, Column, System)
- NZ* commands
- Netezza Appliance models
- Netezza System logs
- Table constraints
- Netezza Joins, Sub queries
- Netezza Stored procedures
- Netezza Functions
- SQL Analytics Functions
- Performance Tuning best practices
- Certification Preparation questions
- Netezza 7.1 features
- Netezza 7.2 features
- Lab: Groom Table, Skew Table, Stored procedures, Analytics Functions
Course Reviews
No Reviews found for this course.
Write a Review