IBM Netezza Online Training Modules Overview

Core topics of Netezza Online Course

Core topics of IBM Netezza DBA Online Course

Lession – 1

• NPS AMPP Architecture & Various Netezza 7.2 appliance models
• Netezza High Availability Architecture (Clustering, Mirroring, fail over)
• Installing Netezza system and client softwares
• Installing Netezza Emulator for day-to-day practice
• Nz Admin: GUI Admin Tool (Installation & Set-up)

Lession – 2

• 0 Netezza Command Line Interface (CLI)
• 1 Manage NPS with CLI commands
• 2 Manage User access to Netezza Databases
• 3 Monitoring Netezza and Linux logs
• 4 Netezza Events (Set-up & Monitoring)

Lession – 3

• 0 Databases & Tables
• 1 Data Distribution (Hash, Random), Cluster Base Tables, Table Skew
• 2 Generate Statistics, Zone Maps, Materialized Views, Groom Table
• 3 Backup & Restore (Host Level, Database Level, Table Level)
• 4 Database Refreshes & Migrations

Lession – 4

• 0 Netezza Appliance migration (For Example: 6.x to 7.x migration)
• 1 Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE
• 2 Data Loading/Unloading using GUI Tools
• 3 Optimizer and query plans
• 4 Query history collection & Reporting

Lession – 5

• 0 Netezza Replication/DR Architecture
• 1 Techniques to improve Netezza performance
• 2 Frequent DBA activities such as SPU replacements, etc
• 3 ODBC/JDBC/OLEDB Client Connectivity
• 4 Working with IBM Netezza Support to resolve issues

Netezza project

IBM Netezza DBA Online Training

Core topics of IBM Netezza DBA Online Course

Module 1 : Administration Overview

Topics : Administrator’s Roles and Tasks, Netezza Software Directories, Initial System Setup and Information, Managing the External Network Connections, Managing the DNS Updates, Administration Interfaces, Setting up Remote Access, Other Netezza Documentation

Module 2 : Installing The Netezza Client Software

Topics : Client Software Packages, Installing on Linux/UNIX Clients, Installation Requirements, Setting the Path for Netezza CLI Client Commands, Installing The Netezza Tools or Removing the IBM Netezza Tools, Environment Variables, Removing the CLI Clients from UNIX Systems, Installing the RPM and Shared Library Files, Client Timeout Controls, Netezza Port Numbers, Installing Netezza CLI Client on a Linux/UNIX System, Upgrading and Removing the Web Admin Interface, Changing the Default Port Numbers, Specifying Non default NPS Port Numbers for Clients, Clients and Unicode Characters, Creating Encrypted Passwords and using Stored Passwords

Module 3 : Netezza Administration Interfaces

Topics : Netezza CLI Overview, Netezza CLI Command Syntax, Summary of Commands Command Locations, using the Netezza Commands, SQL Command Overview and Nz sql Command, Netezza CLI Command Syntax, Nz admin Tool Overview and Client Compatibility, Specifying Identifiers in Commands, Setting Automatic Refresh, Starting the Nz admin Tool, Logging into Nz admin and Connecting to the Netezza System, Main Menu Commands and Administration Commands, using the Nz admin Tool Hyperlinks, Controlling Nz admin Session Termination, Displaying System Components, Interpreting the Color Status Indicators,

Module 4 : Managing Netezza HA Systems

Topics : Linux ha and DRBD Overview, Linux ha Administration, CIB, Differences with the Previous Netezza HA Solution, Heartbeat Configuration, Netezza Cluster Management Scripts, Managing Fail over Timers, Monitoring the Cluster and Resource Group Status, Fail over Criteria, Important Information about Host and Host, NPS Resource Group, Cluster Manager Events, Split Brain, Transitioning from Maintenance to Clustering Mode, DRBD Administration, IP Address Requirements, Forcing Heartbeat To Shutdown, Restarting Heartbeat after Maintenance Network Issues, Shutting Down Heartbeat on Both Nodes Without Causing Relocate, Linux Users and Groups Required for HA, Resolving Configuration Problems, Checking for user Sessions and Activity

Module 5 : Managing The Netezza Hardware

Topics : Netezza Hardware Components, Hardware Types, States Ids, Roles, Location, System Resource Balance Recovery, Call home File, Hardware Management Tasks, Managing Hosts, Spus and Disks, Displaying the Active Path Topology, Automatic Query and Load Continuation, Handling Transactions During Fail over and Regeneration, PDU and Circuit Breakers Overview, Powering on and off the NEC Info frame DWH Appliance, NEC Info frame DWH PDU and Circuit Breakers Overview

Module 6 : Managing The Netezza Server

Topics : Displaying the Current System State, Revision Levels and Software Revision, System States Reference, Overview of the Netezza System Processing, System States During Netezza Startup, Backup and Restore Server, Client, Load, Session, SPU Cores Boot server and Event Manager, Database Operating System, Host Statistics Generator, System Errors and System Logs, Startup and Statistics Servers, Flow Communications Re-transmit, Changing the System Registry

Module 7 : Managing The Event Rules

Topics : Template and Managing Event Rules, the Send mail.Cfg File, Copying a Template Event, Specifying the Event Match Criteria, Aggregating Event Email Messages, Template Event Reference, Hardware Services, Notifications, Query History Events, Hardware Temperature and System Temperature, Monitoring, Displaying Alerts

Module 8 : Establishing Security And Access Control

Topics : Develop an Access Model, Netezza Database Users and Groups, Choosing a user Authentication Method, Security Model, Object Privileges, Administrator Privileges, Authentication, Configuration, Group Public Views, Always Available Functions, Limits

Module 9 : Managing User Content On The Netezza Appliance

Topics : Creating and Understanding Table Size and Storage Space, Database and Table Guidelines, Understanding Transaction Ids, Best Practices for Disk Space Usage in Tables, Distribution Keys, Avoiding Data Skew And Viewing Data Skew, Accessing Rows in Tables, Organizing Keys and Zone Maps, using Clustered Base Tables, Grooming Tables, Managing Sessions, Execution Plans, Transactions, Selecting Organizing Keys

Module 10 : Backing Up And Restoring Databases

Topics : Database Completeness, Compression during Backups and Restores, Portability, Multi Stream Backup, Upgrade/Downgrade Concerns, Encryption Key Management in Backup and Restore, Specifying Backup Privileges, Third Party Backup And Recovery Solutions Support, Maintaining Database Statistics, IBM Tivoli, TSM Connector, EMC Network Connector

Module 11 : Managing Workloads On The Netezza Appliance

Topics : WLM Feature Summary, Concurrent Jobs, Resource Sharing Design, Service Level Planning, Managing Gate Keeper, Short Query Bias, And GRA, Assigning Users To Resource Groups, Guaranteed Resource Allocation Settings, Monitoring Resource Utilization and Compliance, Netezza Priority Levels.

IBM Netezza DBA project

Job Opportunities in IBM Netezza

Who wouldn’t prefer a job that assures a fast paced global career, higher than average perks? The job opportunities in the domain of IBM Netezza are quite plenty. And with the increase in the colossal demand for the qualified experts across the top industries, more & more number of aspirants are planning towards securing their career in this domain. And also in response to the whooping salary packages for the certified professionals in this domain most of the professionals who are working in other prominent technologies are working towards making a career transition into this domain.

IBM Netezza Online Training by SacrosTek Systems will set you on the right career path of achieving success in this domain.

SacrosTek Systems offer certification programs for IBM Netezza. Certificates are issues on successful completion of the course and the assessment examination. Students are requested to participate in the real-time project program to get first-hand experience on the usage and application of the IBM Netezza. The real-time projects are designed by our team of industry experts to help students get best possible exposure to the IBM Netezza and its applications.