Book cover for Snowflake Architecture and SQL by Tom Coffing

Snowflake Architecture and SQL

2022 Released
3-4 Hours
Audiobook Unavailable
Paperback Unavailable
Hardback Unavailable
Coffing PublishingISBN 9781940540566

In this book, readers will learn the Snowflake architecture with an excellent level of detail. Readers will also learn the clever tricks and tips that make Snowflake unique, including failsafe, time travel, and min-max pruning. In addition, Reader can create all types of Snowflake tables and views and learn how to performance tune Snowflake tables and queries. Readers will also gain significant knowledge of SQL, starting at the most basic level and building to intermediate and advanced levels. Advanced topics include date functions, non-structured data (JSON), advanced analytics, User Defined Functions (UDF), and Stored Procedures. There are over 600 examples of managing Snowflake and SQL. The book is 90% hands-on examples. The readers can download and use the SQL_Class database with 28 tables representing the tables in the book.

Tom Coffing

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. You can contact Tom at 513 300-0341 or at Tom.Coffing@CoffingDW.com.

More by Tom Coffing

Why Readwise Books?

Readwise Books is an ebook & audiobook platform that automatically logs how much you and your friends read, making it fun and easy to read more. Learn more →