Netezza SQL
- 2h 40m
- Mike Larkins, Tom Coffing
- Coffing Data Warehousing
- 2014
This book contains nearly 800 pages of brilliant Netezza examples ranging from simple commands to advanced procedures. Netezza SQL, like all others in the Genius Series, takes readers through in a clear and logical manner using pictures and real-life examples. This book is a must-read for any Netezza environment.
About the Authors
Tom Coffing, better known as Tera-Tom, is the founder of Coffing Data Warehousing where he has been CEO for the past 20 years. Tom has written over 50 books on all aspects of Teradata, Netezza, Kognitio, Redshift, ParAccel, Vertica, SQL Server, and Greenplum. Tom has taught over 1,000 Teradata classes in places such as India, Africa, Europe, China, Malaysia, and throughout North America.
Tom is also the owner and designer of the Nexus Query Chameleon, the most sophisticated enterprise query tool in the industry. The Nexus works on all platforms, including Hadoop, converts table structures between all systems, and allows companies to load their ERwin logical model inside Nexus. The Nexus guides users like a GPS system. Users point and click on any table or view from any system, and they are guided to what joins to what. As users choose the columns they want on their report, the SQL is built automatically.
In High School, Tom was the first athlete from his school to ever place at state. He was selected by his school to represent them at Buckeye Boys State, and Tom was inducted into the first class of the Lakota High School Hall of Fame.
At the University of Arizona and University of Nevada Las Vegas, Tom was a two-time All-American wrestler, Sophomore Athlete of the year, and a two-time winner of the 1980 Olympic wrestling trials. Tom graduated with a Bachelor's degree in Speech Communications.
After college, Tom became a state and national champion speech winner for Toastmasters and won two orchid awards as an actor. Tom is the proud father of three wonderful children and has been married for the past 32 years.
Mike Larkins is the greatest SQL writer the world has ever known. Mike has built the SQL programs for CoffingDW and has thus provided CoffingDW with an enormous gift. Mike graduated with a degree in Management Information Systems from Chapman University in Orange, CA. In addition to writing multiple data warehousing books, his computer career spans 30 years in a variety of related positions: computer operations, programming, system analysis, operating systems support, consulting, and college instructor.
Over the course of his career, Mike obtained the following certifications after achieving the Teradata Master Certification:
- Teradata Certified Professional
- Teradata Certified Administrator
- Teradata Certified Developer
- Teradata Certified SQL Specialist
- Teradata Certified Implementation Specialist
- Teradata Certified Designer
In this Book
-
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
