Simple play icon Course
Skills Expanded

Create and Use Views in Snowflake

by Mike McQuillan

Have you been wondering what "views" in Snowflake are all about? This course will teach you how to create, use, and manage views in Snowflake, showing how views can be utilized in queries and managed to support data segregation.

What you'll learn

Are you writing lots of similar queries using joins? Are you having problems maintaining a large collection of SELECT statements? Maybe views can help you out! In this course, Create and Use Views in Snowflake, you'll learn how views can be created. First, you'll learn how views are used in queries to reduce the amount of code you have to write and maintain. Then, you'll discover how views can help to keep your data secure and segregated. Finally, you'll explore various options Snowflake provides you to help manage your views. When you’re finished with this course, you’ll have a better understanding of what views are for, when you should consider using them, and how you can utilize them in Snowflake.

About the author

Mike is a polyglot architect/developer who loves to mess around with data. He runs a consultancy company in the UK, helping organizations to build better systems and databases. Mike is married and has one daughter and two dogs, Dolly and Bertie. They keep his feet warm when he's working on courses and articles. Mike has written a book on SQL Server and writes regular articles for sqlservercentral.com. He also likes collecting old computers like the Commodore 64 and Sinclair Spectrum. No, he doe... more

Ready to upskill? Get started