Netezza SQL

Netezza SQL

 

IBM® Netezza® appliances are now part of IBM PureSystems, a quick, efficient integrated data analytics system that optimizes performance and runs complex algorithms.

Bascom  Bridge’s Netezza SQL training class teaches students how to write efficient big data queries using Netezza SQL.

 

 

NETEZZA SQL TRAINING OBJECTIVES

All students will learn:

  • Basic SQL Functions
  • The WHERE Clause
  • Distinct vs. Group By
  • Aggregation Function
  • Join Functions
  • Date Functions
  • OLAP Function
  • Temporary Tables
  • Sub-query Functions
  • Strings
  • Interrogating the Data
  • View Functions
  • Set Operators
  • Data Manipulation Language (DML)
  • Statistical Aggregate Functions

NETEZZA SQL TRAINING PREREQUISITES

No prior experience is required.

NETEZZA SQL TRAINING MATERIALS

All Netezza training students receive comprehensive courseware, available electronically.

SOFTWARE NEEDED FOR EACH PC:

We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide.  Please ask us for details.

For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

NETEZZA SQL TRAINING OUTLINE

  • Introduction
  • Basic SQL Functions
  • The WHERE Clause
  • Distinct Vs Group By
  • Review
  • Aggregation Function
  • Join Functions
  • Date Functions
  • OLAP Functions
  • Temporary Tables
  • Sub-query Functions
  • Substrings and Positioning Functions
  • Interrogating the Data
  • View Functions
  • Set Operators Functions
  • Data Manipulations
  • Tables, DDL, and Data Types
  • Statistical Aggregate Functions
  • Stored Procedure Functions
  • Nexus Query Chameleon
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Netezza SQL

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : IBM-110
  •  Theory : 50%
  •  Lab : 50%
  • Duration : 18 hours
Scroll Up
Skip to toolbar