Amazon Redshift: A Columnar Database SQL and Architecture

  • 2h 20m
  • David Cook, Tom Coffing
  • Coffing Data Warehousing
  • 2014

Amazon Redshift: A Columnar Database SQL and Architecture illuminates the brilliance behind Amazon’s Redshift technology. It is over 600 pages long, and it shows users how to set it up, tune it, load and go. This book also contains all of the SQL you need to query it with ease. After reading this book, you will know why more and more companies are using Redshift as part of their overall data warehouse strategy.

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.

David Cook is one of the lead developers on the Nexus Query Chameleon software at Coffing Data Warehousing. While in this position, David has designed and created several data analysis tools, including the Garden of Analysis, which queries answer sets without leaving the PC. He is also the creator of the database to database move and compare module that allows users to move and compare databases from different platforms.

David brings to Coffing Data Warehousing a strong background of experience with information technology and management, including time spent managing logistics information for national building products manufacturers. David's ability to communicate well combined with his programming genius has made him a great asset for Coffing Data Warehousing.

David graduated cum laude from The Ohio State University where he received a BA in Communication Technology. David furthered his education at Miami University, where he held a senator position in the student government while maintaining a 4.0 GPA in his area of study in Computer Science and Programming.

In this Book

  • What is Columnar?
  • Best Practices For Table Design
  • System Tables
  • Compression
  • Temporary Tables
  • Explain
  • Basic SQL Functions
  • The WHERE Clause
  • Distinct Vs Group By AND TOP
  • Aggregation
  • Join Functions
  • Date Functions
  • OLAP Functions
  • Temporary Tables
  • Sub-query Functions
  • Substrings and Positioning Functions
  • Interrogating the Data
  • View Functions
  • Set Operators Functions
  • Statistical Aggregate Functions


Rating 4.6 of 3433 users Rating 4.6 of 3433 users (3433)
Rating 4.5 of 420 users Rating 4.5 of 420 users (420)