Beaulieu, Alan

Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data

(No reviews yet) Write a Review
ISBN 13:
9781098140328
author:
Beaulieu, Alan
format:
Paperback
publisher:
O'Reilly Media
language:
English
Publication Year:
2023
Pages:
398
Dimensions:
23.1 x 17.5 x 2.5 centimetres (0
Genre:
Computers, Programming, SQL,
Condition:
New
Availability:
Item usually sent within 10 working days
£49.97

Description

Mastering Snowflake SQL and Scripting is essential for anyone working with the popular cloud-based database management system. This comprehensive guide covers the fundamentals and best practices for generating, modifying, and querying data in Snowflake, as well as applying analytic functions for reporting.

With this book, you'll learn how to create scripts, stored functions, and stored procedures to return data sets using Snowflake Scripting. You'll also discover how to build scripts combining SQL statements with looping, if-then-else, and exception handling. Whether you're new to databases or transitioning from other platforms, this book provides the skills and knowledge needed to work efficiently in Snowflake.

Alan Beaulieu's guide covers a range of topics, including generating and modifying data using INSERT, UPDATE, and DELETE statements, querying data using SELECT, and applying analytic functions for reporting. By the end of this book, you'll be able to build stored procedures and functions to return data sets, making you a proficient Snowflake pro.

View AllClose