Learn: Commonly Used Netezza Basic Commands

1. Connecting to Netezza Database

zConnect -h <hostname> -p <port> -U <username> -d <database_name>

Replace <hostname>, <port>, <username>, and <database_name> with appropriate values.

2. Query Execution

SELECT * FROM <table_name>;

Replace <table_name> with the table you want to select data from.

3. Explanation of SQL Statements

CREATE TABLE

CREATE TABLE <table_name> ( <column1_name>,  <column2_name>, ...);

ALTER TABLE

ALTER TABLE <table_name> ADD COLUMN <new_column_data_type> <new_column_name>;

INSERT INTO

INSERT INTO <table_name> (, , ...) VALUES (, , ...);

4. Data Manipulation Language (DML)

DELETE

DELETE FROM <table_name> WHERE <condition>;

UPDATE

UPDATE <table_name> SET <column_name>=<new_value> WHERE <condition>;

5. Data Definition Language (DDL)

DROP TABLE

DROP TABLE <table_name>;

Good luck with your data analysis using Netezza!