Book

Data Modeling with Snowflake

Modeling guides are often steeped in theory and formal language. The innovative approach taken in Data Modeling with Snowflake combines practical modeling concepts with Snowflake best practices and unique features, allowing you to create efficient designs that leverage the power of the Data Cloud.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

10h48m

Language

English

About Book

Who Is This Book For?

This book is for developers working with SQL who are looking to build a strong foundation in modeling best practices and gain an understanding of where they can be effectively applied to save time and effort. Whether you’re an ace in SQL logic or starting out in database design, this book will equip you with the practical foundations of data modeling to guide you on your data journey with Snowflake. Developers who’ve recently discovered Snowflake will be able to uncover its core features and learn to incorporate them into universal modeling frameworks.

Book content

chapters 10h48m total length

Unlocking the Power of Modeling

An Introduction to the Four Modeling Types

Mastering Snowflake’s Architecture

Mastering Snowflake Objects

Speaking Modeling through Snowflake Objects

Seeing Snowflake’s Architecture through Modeling Notation

Putting Conceptual Modeling into Practice

Putting Logical Modeling into Practice

Database Normalization

Database Naming and Structure

Putting Physical Modeling into Practice

Putting Transformational Modeling into Practice

Modeling Slowly Changing Dimensions

Modeling Facts for Rapid Analysis

Modeling Semi-Structured Data

Modeling Hierarchies

Scaling Data Models through Modern Techniques

Appendix

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required