Shop all O'Reilly Media

Learning Snowflake SQL and Scripting - by Alan Beaulieu (Paperback)

Name: Learning Snowflake SQL and Scripting - by Alan Beaulieu (Paperback)
Brand: O'Reilly Media
SKU: 89294784
Price: 48.99 USD
Availability: InStock

undefined out of 5 stars with 0 reviews

5 Questions

$48.99Save $31.00 (39% off)

In Stock

Eligible for registries and wish lists

Save 5% every day

With Target Circle™ Card

About this item

Details

Highlights

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.
Author(s): Alan Beaulieu
398 Pages
Computers + Internet, Programming Languages

Description

Book Synopsis

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

Specifications

Dimensions (Overall): 9.1 Inches (H) x 6.9 Inches (W) x 1.0 Inches (D)

Weight: 1.45 Pounds

Suggested Age: 22 Years and Up

Number of Pages: 398

Genre: Computers + Internet

Sub-Genre: Programming Languages

Publisher: O'Reilly Media

Theme: SQL

Format: Paperback

Author: Alan Beaulieu

Language: English

Street Date: November 7, 2023

TCIN: 89294784

UPC: 9781098140328

Item Number (DPCI): 247-02-2051

Origin: Made in the USA or Imported

If the item details aren’t accurate or complete, we want to know about it.

Shipping & Returns

Shipping details

Estimated ship dimensions: 1 inches length x 6.9 inches width x 9.1 inches height

Estimated ship weight: 1.45 pounds

We regret that this item cannot be shipped to PO Boxes.

This item cannot be shipped to the following locations: American Samoa (see also separate entry under AS), Guam (see also separate entry under GU), Northern Mariana Islands, Puerto Rico (see also separate entry under PR), United States Minor Outlying Islands, Virgin Islands, U.S., APO/FPO, Alaska, Hawaii

Return details

This item can be returned to any Target store or Target.com.

This item must be returned within 90 days of the date it was purchased in store, delivered to the guest, delivered by a Shipt shopper, or picked up by the guest.

See the return policy for complete information.