Master Snowflake with Hands On (Sep 2023)

Focused View

Proton Expert Systems & Solutions

2:19:01

21 View

1. Introduction

1. Overview.mp4

05:50

2. Lesson 1

1. Lesson 1 Introduction to snowflake and its architecture.mp4

13:48

2.1 AG 1.1.pdf

2. Practice 1-1 Creating a Snowflake account, knowing the interface and components.mp4

05:15

3.1 AG 1.2.pdf

3. Practice 1-2 Creating and Using Virtual Warehouses, altering the warehouse and.mp4

08:06

3. Lesson 2

1. Lesson 2 Introduction to Snowflake Database Objects.mp4

11:10

2.1 AG 2.1.pdf

2.2 Employees Managers.csv

2.3 Employees Status.csv

2.4 Employees.csv

2. Practice 2.1 - Creating database, schema, and table from UI and using command.mp4

09:48

3.1 AG 2.2.pdf

3. Practice 2.2 - Insert data into table, perform SQL queries with joins.mp4

08:38

4.1 AG 2.3.pdf

4. Practice 2.3 - Creating views, stages and file formats. Creating simple UDF and.mp4

04:05

4. Lesson 3

1. Lesson 3 Query Development, Data Types, Data Loading & Unloading.mp4

10:43

2.1 AG 3.1.pdf

2.2 employees2.csv

2. Practice 3.1 - Data Loading using External stage (bulk loading) and Snowpipe (co.mp4

17:11

3.1 AG 3.2.pdf

3. Practice 3.2 Data Unloading.mp4

01:56

5. Lesson 4

1. Lesson 4 Snowflake Access Control.mp4

11:08

2.1 AG 4.1.pdf

2. Practice 4.1 - Creating user defined role, grant that role to other role and ass.mp4

03:34

6. Lesson 5

1. Lesson 5 Snowflake Security & Governance.mp4

11:38

2.1 AG 5.1.pdf

2. Practice 5.1 - Enable multifactor authentication, apply data masking to table da.mp4

05:39

7. Lesson 6

1. Lesson 6 Snowflake Account Costs.mp4

04:26

2.1 AG 6.1.pdf

2. Practice 6.1 - Check the cost incurred and calculate charges based on credit con.mp4

02:41

3.1 AG 6.2.pdf

3. Practice 6.2 - Trigger alerts based on credit quota and resource monitor..mp4

03:25

Description

Unfolding Snowflake: Unlocking the Art of Cloud Data Warehousing

What You'll Learn?

Utilize Snowflake's scalable architecture to efficiently manage and analyse large volumes of data.
Perform advanced data loading techniques, including batch loading and real-time streaming.
Execute complex SQL queries to extract meaningful insights from diverse datasets
Maximize Snowflake's performance by optimizing query execution and resource allocation
Implement robust security measures to protect data and ensure compliance with industry standards
Implement data governance practices, including access controls, permissions, and data lineage
Implement best practices for data governance and compliance in Snowflake
Leverage the power of stored procedures and user define functions
Execute Streams on top of table to leverage change data capture feature and tasks to ingest changes
Utilize Snowflake's time travel and data versioning features for historical data analysis and auditing

Who is this for?

Data Analysts

Data Engineers

Database Administrators

Business Intelligence Professionals

What You Need to Know?

Basic Knowledge of SQL and databases

Understanding of Data Warehousing

Familiarity with Cloud Computing

More details

Description
Explore the power of Snowflake, the cutting-edge cloud data warehousing platform that changes the way you manage and analyze your data. With its unparalleled scalability, lightning-fast performance, and secure architecture, Snowflake empowers businesses to unlock valuable insights and make data-driven decisions like never before. Join our Snowflake course today and embark on a transformative journey to harness the full potential of this game-changing technology.

Discover the immense power and versatility of Snowflake, the cutting-edge cloud data warehousing platform, through our comprehensive and immersive course. Designed for data professionals and enthusiasts alike, this course takes you on a deep dive into Snowflake's features and functionalities.

In this course, you will gain hands-on experience in harnessing Snowflake's unparalleled scalability, allowing you to seamlessly handle massive volumes of data with ease.

By the end of this course, you will be equipped with the skills and knowledge needed to become a proficient Snowflake user, capable of leveraging its power to drive data-driven innovation within your organization.

The course teaches you everything you need to know about Snowflake.

This course gives details about Mastering Snowflakes with an emphasis on its activity lessons and hands on experience.

What are you waiting for?

Every day is a missed opportunity.

Enroll No!

Hurry up!
Who this course is for:
Data Analysts
Data Engineers
Database Administrators
Business Intelligence Professionals

User Reviews

Rating

average 0

Total votes0

Focused display

Proton Expert Systems & Solutions is an ISO 9001:2015 Certified IT Consulting and Services firm, specializing in Cloud Computing, Enterprise Applications, Data Science, Machine Learning, Block Chain, IOT, Web/Mobile App Designing and IT Consulting Solutions.SPECIALIZED IN SERVICES & SOLUTIONCloud Computing – AWS, GCP, OCI, Docker, Kubernetes, Devops, Ansible, TerraformData Science – Big Data – Hadoop full Stack , Spark, Python, R Programming, Machine Learning, Data VisualizationBlock Chain – Hyperledger and IOTOracle CPQ Cloud, Oracle Sales CloudMobile App, Web App Design, SEO and SMM

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.