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. The chart below shows which systems users can query, migrate, and join data automatically with Nexus.
Nexus 17 can migrate from every combination between all systems as the source or the target.
• Microsoft Access
• SQL Server
• SAP HANA
You can download a free trial of Nexus at CoffingDW.com. You can also see some of the great features of Nexus right here.
You can also see the Nexus in action migrating data to the cloud here.
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.
Creating Amazon Redshift Tables
If you are creating tables or working with Amazon Redshift, you will want to see this video. Tera-Tom does what he does best, and that is to explain how the architecture of Redshift works. You will learn how to create Redshift tables using three methods for the best performance tuning.
Watch the video and understand how to define Amazon Redshift tables and how Redshift processes data.
The picture above shows the most advanced software architecture in the world. Invented by Tom Coffing and his team of developers, it took 18 years to complete. Nexus software resides on a user's desktop, laptop, or server and coordinates with Nexus Server software so users can work from anywhere and still get high-speed data transfer to migrate and join data across all database platforms. For more information on Nexus, contact Tom.Coffing@CoffingDW.com.