Alan Beaulieu
Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data
Learning Snowflake SQL and Scripting: Generate, Retrieve, and Automate Snowflake Data
YOU SAVE £19.84
- Condition: Brand new
- UK Delivery times: Usually arrives within 2 - 3 working days
- UK Shipping: Fee starts at £2.39. Subject to product weight & dimension
Couldn't load pickup availability
Excellent- 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
This item can be found in:
UK and International shipping information
UK and International shipping information
UK Delivery and returns information:
- Delivery within 2 - 3 days when ordering in the UK.
- Shipping fee for UK customers from £2.39. Fully tracked shipping service available.
- Returns policy: Return within 30 days of receipt for full refund.
International deliveries:
Shulph Ink now ships to Australia, Belgium, Canada, France, Germany, Ireland, Italy, India, Luxembourg Saudi Arabia, Singapore, Spain, Netherlands, New Zealand, United Arab Emirates, United States of America.
- Delivery times: within 5 - 10 days for international orders.
- Shipping fee: charges vary for overseas orders. Only tracked services are available for most international orders. Some countries have untracked shipping options.
- Customs charges: If ordering to addresses outside the United Kingdom, you may or may not incur additional customs and duties fees during local delivery.
