Netezza

IBM Netezza
Reading Time: 3 minutes

  • Creating User and User Management
  • Managing Workloads

our OTHER COURSES

CLOUD COMPUTING

Cloud computing is the on-demand availability of computer system resources, especially data storage (cloud storage) and computing power, without direct active management by the user

BIG DATA

Big data is a field that treats ways to analyze, systematically extract information from, or otherwise deal with data sets that are too large or complex to be dealt with by traditional data-processing application software.

DATA WAREHOUSING

Data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence. 

WEB DEVELOPMENT

Web development is the work involved in developing a Web site for the Internet or an intranet. It can range from a simple single static page to complex Internet applications.

APP DEVELOPMENT

Mobile app development is the act or process by which a mobile app is developed for mobile devices, such as personal digital assistants, enterprise digital assistants or mobile phones.

SOFTWARE TESTING

Software testing is an investigation conducted to provide stakeholders with information about the quality of the software product or service under test.

NPS AMPP Architecture & Various Netezza 7.2 appliance models

  • Netezza High Availability Architecture (Clustering, Mirroring, failover)
  • Installing the Netezza system and client software
  • Installing Netezza Emulator for day-to-day practice
  • Nz Admin: GUI Admin Tool (Installation & Set-up)


Netezza Command Line Interface (CLI)

  • Manage NPS with CLI commands
  • Manage User access to Netezza Databases
  • Monitoring Netezza and Linux logs
  • Netezza Events (Set-up & Monitoring)


Databases & Tables

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

Netezza Appliance migration (For Example: 6.x to 7.x migration)

  • Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE
  • Data Loading/Unloading using GUI Tools
  • Optimizer and query plans
  • Query history collection & Reporting


Netezza Replication/DR Architecture

  • Netezza performance improvement techniques
  • Common DBA activities such as SPU replacements, etc
  • ODBC/JDBC/OLEDB Client Connectivity
  • Working with IBM Netezza Support to resolve issues
Complete Netezza Course
Take your journey towards learning Netezza in just 30 days, just 1 hour a day. Joins 1000s  of others who have benefited by upskilling and boosting their careers
Free Netezza Course
Netezza TwinFin Arch.
Learn about Netezza TwinFin Architecture and how it is unique
TwinFin Architecture
Sequences
What are Sequences and how are they used to generate unique IDs
Netezza Sequences
Netezza Overview
Quick introduction to what is Netezza and how is it used in Data Warehousing
Netezza Overview
nzstats command
using nzstats to gather statistics and why is it useful
nzstats