• tomcoffing

Learn Redshift with Tera-Tom - Defining Sort Keys in Tables

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 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.



Sort Key Options for Amazon Redshift inside Tables


Amazon Redshift allows you to sort the data inside a Redshift table, which can be quite advantageous. You can utilize a single-column sort key, a compound sort key, or an interleaved sort key. Let Tera-Tom explain how each works in Redshift.


Watch the video and understand the advantages of different sort keys in Redshift.








12 views0 comments