Advanced Analytics: Performing Analytics Using Snowflake

Snowflake    |    Intermediate
  • 16 videos | 1h 49m 32s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 48 users Rating 4.6 of 48 users (48)
Data analytics is the systematic, computational analysis of data or statistics used to discover and communicate meaningful patterns. In business, analytics can be used to extract insights for a business strategy or identify new business opportunities. Snowflake is a managed data platform for big data storage, processing, and analytics that allows for common SQL operations and additional operations. In this course, explore various types of Snowflake join operations and data sampling. Next, learn how to use common table expressions (CTEs) and construct queries. Finally, work with functions related to partitioning, windowing, and ranks. Upon completion, you'll be able to use joins, perform row-based and block-based sampling, construct CTEs, and perform windowing and partitioning operations in Snowflake.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Recognize snowflake’s support for big data analytics
    Perform inner, left, and right joins
    Execute full outer, natural, and cross joins
    Use subqueries and set operators
    Identify how sampling works in snowflake
    Perform row and block sampling
    Use ctes within queries
  • Employ self-joins and recursive ctes
    Use the connect by clause
    Recall how windowing functions work in snowflake
    Utilize the row_number, rank, and dense_rank functions
    Use ranking and windowing functions with partitioned data
    Perform windowing operations to create unbounded preceding and unbounded following windows
    Utilize sliding windows and access data in partitions
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m
  • 3m 32s
  • Locked
    3.  Performing Join Operations in Snowflake
    7m 4s
  • Locked
    4.  Executing Additional Joins in Snowflake
    5m 11s
  • Locked
    5.  Using Subqueries
    10m 43s
  • Locked
    6.  Snowflake Sampling
    3m 54s
  • Locked
    7.  Performing Row and Block Sampling in Snowflake
    8m 30s
  • Locked
    8.  Using CTEs within Queries
    10m 16s
  • Locked
    9.  Employing Self-joins and Recursive CTEs
    9m 22s
  • Locked
    10.  Using the CONNECT BY Clause
    7m 22s
  • Locked
    11.  Snowflake Windowing
    7m 10s
  • Locked
    12.  Utilizing Rank-related Functions
    7m 19s
  • Locked
    13.  Using Ranking and Windowing Functions
    8m 22s
  • Locked
    14.  Performing Windowing Operations
    7m 8s
  • Locked
    15.  Utilizing Sliding Windows
    7m 24s
  • Locked
    16.  Course Summary
    5m 15s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Understanding Data Manipulation
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Queries in Snowflake: Search Optimization, External Table Partitions, & Views
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)
Course Software Product Management: The Product Management Team
Rating 4.3 of 18 users Rating 4.3 of 18 users (18)
Course Developing an AI/ML Data Strategy: The Data Analytics Maturity Model
Rating 4.6 of 260 users Rating 4.6 of 260 users (260)