Snowflake Architecture and SQL

  • 3h 3m
  • Tom Coffing
  • Coffing Data Warehousing
  • 2022
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.

About the Author

Tom Coffing has passed all 6 Teradata Certifications and is a Teradata Certified Master. Tom is often referred to as Tera-Tom because he has trained over 8,000 Teradata students over the past decade. Tom is considered one of the best technical speakers in the world. Tom has numerous data warehouse books on the market. They have been translated to many different languages and read in over 20 countries. Mike Larkins has over 30 years of experience in the computer industry and is considered one of the premier Teradata teachers in the world. He has 18 years of experience with NCR Corporation with the last five teaching Teradata SQL. Mike has since joined Tom Coffing's team of elite data warehouse consultants and teachers.

Tom Coffing and Mike Larkins have taught Teradata SQL at over 125 Teradata sites around the globe and have a combined 56 years of computer experience.

In this Book

  • Getting Started with a Snowflake Trial Account
  • What is Snowflake?
  • Configuring and Managing the Snowflake Warehouse
  • Brilliant Features of Snowflake
  • Performance Tuning with Cluster Keys
  • Data Sharing
  • Snowflake Tasks
  • Roles and Access Rights
  • Data Ingestion
  • Information_Schema System Catalog
  • Systems Functions
  • Introduction to SQL
  • The WHERE Clause
  • Distinct, Group By, Top, and Pivot
  • Aggregation
  • Joining Tables
  • Date Functions
  • Temporary Tables
  • Sub-query Functions
  • Analytic and Window Functions
  • Strings
  • Interrogating the Data
  • View Functions
  • Set Operators
  • Creating Tables
  • Inserts, Updates, and Deletes
  • Unstructured Data – JSON and XML
  • User Defined Functions (UDFs)
  • Stored Procedures
  • Statistical Aggregate Functions
  • Mathematical Functions