|
Database & Reporting Training
/
IBM Training
Netezza SQL
50%Lecture/Demo 
50%Lab IBM® Netezza® appliances are now part of IBM PureSystems, a quick, efficient integrated data analytics system that optimizes performance and runs complex algorithms. Accelebrate's Netezza SQL training class teaches students how to write efficient big data queries using Netezza SQL. Course Number:IBM-110Duration:3Location and PricingMost Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us. Netezza SQL Training ObjectivesAll students will learn:
Netezza SQL Training OutlineIntroduction 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 Prerequisites:No prior experience is required. Training Materials:All Netezza training students receive comprehensive courseware, available electronically. Software needed for each student 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. Related Courses: |
Please see our complete list of
Microsoft Official Courses
Recent Training Locations
United States
Alabama
Hunstville
Montgomery / Birmingham
Alaska
Anchorage
Arizona
Phoenix
Tucson
Arkansas
Fayetteville / Little Rock
California
San Francisco /
Oakland / San Jose
Orange County / Los Angeles
Sacramento
San Diego
Colorado
Denver /
Boulder / Colorado Springs
Connecticut
Hartford
DC
Washington
Florida
Fort Lauderdale / Miami
Jacksonville
Orlando
Saint Petersburg / Tampa
Georgia
Atlanta
Augusta & Savannah
Idaho
Boise
Illinois
Chicago
Indiana
Indianapolis
Iowa
Cedar Rapids / Des Moines
Kansas
Wichita
Kentucky
Lexington / Louisville
Louisiana
Baton Rouge / Orleans
Maine
Portland
Maryland
Annapolis / Baltimore
Hagerstown & Frederick
Massachusetts
Springfield
Boston / Cambridge
Michigan
Ann Arbor / Detroit
Grand Rapids
Minnesota
Saint Paul / Minneapolis
Mississippi
Jackson
Missouri
Kansas City
St. Louis
Nebraska
Lincoln / Omaha
Nevada
Reno and Las Vegas
New Jersey
Princeton
New Mexico
Albuquerque
New York
Buffalo
Albany
White Plains / York City
North Carolina
Charlotte
Durham / Raleigh
Ohio
Canton / Akron
Cincinnati
Cleveland & Columbus
Dayton
Oklahoma
Tulsa / Oklahoma City
Oregon
Portland
Pennsylvania
Pittsburgh
Philadelphia
Rhode Island
Providence
South Carolina
Columbia & Charleston
Spartanburg & Greenville
Tennessee
Memphis / Nashville
Knoxville
Texas
Dallas
El Paso
Houston
San Antonio / Austin
Utah
Salt Lake City
Virginia
Richmond / Alexandria / Arlington
Washington
Tacoma / Seattle
West Virginia
Charleston
Wisconsin
Madison / Milwaukee
Canada
Alberta
Edmonton / Calgary
British Columbia
Vancouver
Nova Scotia
Halifax
Ontario
Ottawa
Toronto
Quebec
Montreal
Puerto Rico
San Juan