Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data
Beaulieu, Alan
相關主題
商品描述
To help you on the path to becoming a Snowflake pro, this concise yet comprehensive guide reviews fundamentals and best practices for Snowflake's SQL and Scripting languages. Developers and data professionals will learn how to generate, modify, and query data in the Snowflake relational database management system as well as how to apply analytic functions for reporting.
Author Alan Beaulieu also shows you how to create scripts, stored functions, and stored procedures to return data sets using Snowflake Scripting. This book is ideal whether you're new to databases and need to run queries or reports against a Snowflake database, or transitioning from databases such as Oracle, SQL Server, or MySQL to cloud-based platforms.
With this book, you will:
- Generate and modify Snowflake data using Insert, Update, Delete
- Query data in Snowflake using Select, including joining multiple tables, using subqueries, and grouping
- Apply analytic functions for performing subtotals, grand totals, row comparisons, and other reporting functionality
- Build scripts combining SQL statements with looping, if-then-else, and exception handling
- Learn how to build stored procedures and functions
- Use stored procedures to return data sets
商品描述(中文翻譯)
為了幫助您成為一名Snowflake專家，這本簡潔而全面的指南回顧了Snowflake的SQL和腳本語言的基礎知識和最佳實踐。開發人員和數據專業人員將學習如何在Snowflake關聯式數據庫管理系統中生成、修改和查詢數據，以及如何應用分析函數進行報告。作者Alan Beaulieu還向您展示如何使用Snowflake腳本語言創建腳本、存儲函數和存儲過程來返回數據集。無論您是對數據庫新手，需要對Snowflake數據庫運行查詢或報告，還是從Oracle、SQL Server或MySQL等數據庫過渡到基於雲的平台，這本書都非常適合您。通過這本書，您將能夠：生成和修改Snowflake數據，使用Insert、Update、Delete；使用Select在Snowflake中查詢數據，包括多表聯接、使用子查詢和分組；應用分析函數進行小計、總計、行比較和其他報告功能；構建結合SQL語句、循環、if-then-else和異常處理的腳本；學習如何構建存儲過程和函數；使用存儲過程返回數據集。
