Querying Data with Snowflake from Pluralsight

In this course, you’ll learn how to query data in Snowflake using various query constructs and built-in functions - like Scalar, Aggregate, Analytic, Window, Table & Semi-structured functions - to clean up, transform, and analyze data.

Snowflake is one of the most popular cloud data platforms. It allows data storage, data processing, and analytics at a massive scale, with extremely less administrative effort. And one of the key areas is to effectively query the data. In this course, Querying Data with Snowflake, you’ll learn how to use various query constructs and built-in functions in Snowflake, to clean up, transform, and analyze data. First, you’ll learn about different querying options in Snowflake and how to explore data using SnowSQL and Snowsight. Then, you’ll discover how to perform common SQL operations - like using Scalar functions, working with subqueries and CTEs, using joins and set operations, building dynamic queries, and using table functions. Next, you’ll see how to work with various aggregate and analytic functions, including windows, rank-related, and window frame functions and working with various group by extensions. Finally, you’ll see the data protection lifecycle, and how to protect the data using time travel and some quick tips to improve query performance. By the end of this course, you’ll have the knowledge and skills, to Query Data with Snowflake, by using various query constructs and built-in functions.

What's inside

Syllabus

Course Overview

Querying with Snowflake – Getting Started

Performing Common SQL Operations

Working with Aggregate and Analytic Functions

Querying Semi-structured Data

Time Travel and Query Performance

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Examines query construction and function use in Snowflake, which is an industry standard

Taught by Mohit Batra, who is recognized for their work in data analysis and management

Teaches fundamental querying skills, which are core for data analysts and engineers

Develops proficiency in using scalar, aggregate, analytic, and other functions

Covers advanced topics like window functions and semi-structured data querying

Requires some prior SQL knowledge to fully benefit from the course

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Querying Data with Snowflake with these activities:

Snowflake Course Materials Compilation

Show steps

Organizes and consolidates your course materials for easy reference and review.

Show steps

Create a folder or notebook to store all course materials.
Add lecture videos, slides, assignments, and other relevant resources.

Review SQL Basics

Show steps

Refreshes your understanding of basic SQL syntax and concepts, providing a solid foundation for the course.

Browse courses on SQL

Show steps

Revisit key SQL concepts like data types, tables, and operators.
Practice writing simple SELECT, INSERT, UPDATE, and DELETE statements.

Join a Snowflake Community Forum

Show steps

Expand your knowledge and connect with other Snowflake users by actively participating in community forums.

Browse courses on Peer Support

Show steps

Find a relevant Snowflake community forum online.
Join the forum and create a profile.
Participate in discussions, ask questions, and share your experiences.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice Data Manipulation Exercises

Show steps

Sharpen your understanding of data manipulation techniques by completing exercises that cover the SQL functions and constructs taught in the course.

Browse courses on Data Manipulation

Show steps

Access the online Snowflake workspace or download the Snowflake client.
Review the course materials on data manipulation.
Attempt the practice exercises provided in the course or search for additional exercises online.

Build a Data Exploration Tool

Show steps

Reinforce your knowledge of Snowflake's capabilities by creating a tool that allows you to explore and visualize data.

Browse courses on Data Exploration

Show steps

Choose a specific dataset or business problem to focus on.
Design the tool's interface and functionality.
Implement the tool using Snowflake's SQL functions and constructs.
Test and refine the tool based on user feedback.

Develop a Snowflake ETL Pipeline

Show steps

Apply your skills in data querying and manipulation by building an ETL pipeline that automates data extraction, transformation, and loading into Snowflake.

Browse courses on ETL Pipelines

Show steps

Identify the source and target data sources.
Design the ETL process, including data extraction, transformation, and loading.
Implement the ETL pipeline using Snowflake's built-in tools and functions.
Monitor and maintain the ETL pipeline to ensure data integrity and performance.

Mentor Junior Snowflake Developers

Show steps

Reinforces your understanding of Snowflake concepts while supporting the growth of other developers.

Show steps

Volunteer as a mentor in a Snowflake community or online platform.
Provide guidance and support to junior Snowflake developers, answering questions and sharing knowledge.

Career center

Learners who complete Querying Data with Snowflake will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts use SQL-based tools and techniques to collect, clean, process, analyze, and present data. This course, Querying Data with Snowflake, teaches the skills and knowledge needed to construct queries to clean, transform, and analyze data. As such, it can help one to build the foundation for a career as a Data Analyst who uses Snowflake.

See salaries and explore the career path for Data Analyst

Database Administrator

Database Administrators ensure that organizations get the most out of their database systems. This can include designing and optimizing database structures and writing SQL queries to manage and analyze data. This course can help one to learn how to use Snowflake to manage and analyze data, which is an important skill for Database Administrators.

See salaries and explore the career path for Database Administrator

Data Engineer

Data Engineers build and maintain the infrastructure that allows organizations to collect, store, and analyze data. This includes designing and implementing data pipelines and writing SQL queries to transform and analyze data. This course can help one to learn how to use Snowflake to transform and analyze data, which is an important skill for Data Engineers.

See salaries and explore the career path for Data Engineer

Business Analyst

Business Analysts use data to help businesses make better decisions. This can include collecting, cleaning, and analyzing data, as well as presenting insights to stakeholders. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Business Analysts.

See salaries and explore the career path for Business Analyst

Data Scientist

Data Scientists use data to build models and solve problems. This can include collecting, cleaning, and analyzing data, as well as developing and deploying machine learning models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Data Scientists.

See salaries and explore the career path for Data Scientist

Software Engineer

Software Engineers design, develop, and maintain software applications. This can include writing code to manage and analyze data. This course can help one to learn how to use Snowflake to manage and analyze data, which is a useful skill for Software Engineers.

See salaries and explore the career path for Software Engineer

Statistician

Statisticians use data to make inferences about the world. This can include collecting, cleaning, and analyzing data, as well as developing and testing statistical models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Statisticians.

See salaries and explore the career path for Statistician

Actuary

Actuaries use data to assess risk and uncertainty. This can include collecting, cleaning, and analyzing data, as well as developing and testing actuarial models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Actuaries.

See salaries and explore the career path for Actuary

Financial Analyst

Financial Analysts use data to make investment decisions. This can include collecting, cleaning, and analyzing data, as well as developing and testing financial models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Financial Analysts.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers use data to understand consumer behavior. This can include collecting, cleaning, and analyzing data, as well as developing and testing market research models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Market Researchers.

See salaries and explore the career path for Market Researcher

Operations Research Analyst

Operations Research Analysts use data to solve business problems. This can include collecting, cleaning, and analyzing data, as well as developing and testing operations research models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Operations Research Analysts.

See salaries and explore the career path for Operations Research Analyst

Quantitative Analyst

Quantitative Analysts use data to make investment decisions. This can include collecting, cleaning, and analyzing data, as well as developing and testing quantitative models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Quantitative Analysts.

See salaries and explore the career path for Quantitative Analyst

Risk Analyst

Risk Analysts use data to assess risk and uncertainty. This can include collecting, cleaning, and analyzing data, as well as developing and testing risk models. This course can help one to learn how to use Snowflake to collect, clean, and analyze data, which is an important skill for Risk Analysts.

See salaries and explore the career path for Risk Analyst

Data Governance Specialist

Data Governance Specialists develop and implement policies and procedures to ensure that data is used in a consistent and ethical manner. This can include developing data quality standards, managing data access, and monitoring data usage. This course can help one to learn how to use Snowflake to manage data access and monitor data usage, which are important skills for Data Governance Specialists.

See salaries and explore the career path for Data Governance Specialist

Database Architect

Database Architects design and implement database systems. This can include designing data models, optimizing database performance, and ensuring data security. This course can help one to learn how to use Snowflake to design data models and optimize database performance, which are important skills for Database Architects.

See salaries and explore the career path for Database Architect

Querying Data with Snowflake

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses