• tomcoffing

Learn Redshift with Tera-Tom - Performance Tuning Joins

Updated: Sep 16


This blog is from the Amazon Redshift Architecture and SQL book by Tom Coffing and David Cook.


Are you ready to learn about Amazon Redshift from the best technical trainer the world has ever seen? Tom Coffing, AKA Tera-Tom, makes learning fun, exciting, and easy. Learning Amazon Redshift is one of the best moves you can make in your career because Redshift has a brilliant design for the cloud.


Tom Coffing is an expert on all database systems as he has written over 85 books covering them all. Once Tom understood the Teradata Architecture and then Amazon Redshift, all the other databases were easy to learn.


Tom became famous as a teacher because he memorized every student's name when he greeted them. Tom has taught over 1,000 classes and never missed a single name. Ask anyone who attended a class taught by Tom Coffing.


Tom has also led a team of developers for almost 20 years to create the Nexus, which queries, migrates, and joins data across all systems.


Nexus version 17 can migrate from every combination between all systems as the source or the target.


• MySQL

• Excel

• Microsoft Access

• Snowflake

• Redshift

• Synapse

• BigQuery

• Teradata

• Oracle

• SQL Server

• DB2

• Hadoop

• MapR

• Greenplum

• Postgres

• Vertica

• Netezza

• SAP HANA

• Yellowbrick • SQLite


You can download a free trial of Nexus at CoffingDW.com. You can also see some of the great features of Nexus right here.

https://www.youtube.com/watch?v=o7YGXfxrJOM&t=24s.


You can also see the Nexus in action migrating data to the cloud here.

https://www.youtube.com/watch?v=_9ABivdwJPk&t=3s.


This video is part of the Tera-Tom Amazon Architecture series, where Tom provides videos that are only five minutes long. You can take your time and go at your own pace.



Performance Tuning Joins


Learn the most important performance tuning lesson for Amazon Redshift and all Massively Parallel Processing systems. This video might be the funniest parody, but so important for understanding how joins work in Redshift. Tom Coffing and his wife Leona make this incredibly important video fun.


Watch the video and understand how to define tables, so Amazon Redshift joins work brilliantly.




The picture above shows Tom Coffing, his wife Leona, and their three kids in 1989.



12 views0 comments