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
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition
Book Practical SQL: A Beginner's Guide to Storytelling with Data, 2nd Edition
Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Loading in Snowflake: Using External Stages
Rating 4.6 of 32 users Rating 4.6 of 32 users (32)
Book SnowPro Core Certification Companion: Hands-On Preparation and Practice
Course Getting Started with Snowflake: Using Time Travel & the SnowSQL CLI
Rating 4.7 of 105 users Rating 4.7 of 105 users (105)