Alan Beaulieu
Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data
Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data
💎 Earn 304 Points (£3.04) on this item.
YOU SAVE £3.05
- Condition: Brand new
- UK Delivery times: Usually arrives within 2 - 3 working days
- UK Shipping: Fee starts at £3.89. Subject to product weight & dimension
Bulk ordering. Want 15 or more copies? Get a personalised quote and bigger discounts. Learn more about bulk orders.
Couldn't load pickup availability
- More about Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data
This guide provides fundamentals and best practices for Snowflake's SQL and Scripting languages, covering data generation, modification, querying, analytic functions, scripts, stored functions, and procedures. It is ideal for beginners and professionals transitioning from other databases to cloud-based platforms.
Format: Paperback / softback
Length: 300 pages
Publication date: 20 October 2023
Publisher: O'Reilly Media
This comprehensive guide is designed to assist you in your journey to becoming a proficient Snowflake professional. It covers both the fundamentals and best practices of Snowflake's SQL and Scripting languages, empowering developers and data professionals to generate, modify, and query data within the Snowflake relational database management system. Author Alan Beaulieu also demonstrates how to create scripts, stored functions, and stored procedures to efficiently retrieve data sets using Snowflake Scripting. Whether you are new to databases or transitioning from other platforms like Oracle, SQL Server, or MySQL to cloud-based solutions, this book is your ideal resource.
In this book, you will learn:
Generate and modify Snowflake data using Insert, Update, Delete queries 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
By mastering the techniques outlined in this guide, you will gain the skills and knowledge necessary to leverage Snowflake's powerful capabilities and optimize your data management processes. So, whether you are a developer, data analyst, or business professional looking to expand your database expertise, this book is a must-read.
Weight: 700g
Dimension: 178 x 237 x 26 (mm)
ISBN-13: 9781098140328
UK and International shipping information
UK and International shipping information
We deliver throughout the United Kingdom and to 128 countries and territories worldwide, including the United States, Australia, Canada, Germany, Spain and France.
