UrbanPro
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

true
true

Snowflake

No Reviews Yet

Annojiguda, Hyderabad

Course ID: 371412

Annojiguda, Hyderabad

Students Interested 0 (Seats Left 0)

₹ 25,000 onwards

Trainer in Snowflake, Informatica Power Center,Bigdata

No Reviews Yet

About the Course

Author:  Raghava

Duration: 40 days

 

Snowflake Course Content

Table of Contents:

 

  1. Introduction to Cloud
  2. Data Warehousing Concepts
  3. Introduction to Snowflake
  4. Connecting to Snowflake
  5. Loading / Unloading Data into/from Snowflake
  6. Using Snowflake
  7. Snowflake Continuous Data Pipelines
  8. Sharing Data in Snowflake
  9. Managing Your Snowflake Account
  10. Understanding Snowflake Data Transfer Billing
  11. Managing Security in Snowflake
  12. Performance Tuning
  13. Real Time Scenarios, Real Time Interview Questions & FAQs

 

  1. Introduction to Cloud
  • What is Cloud
  • Different Cloud Vendors
  • Advantages of Cloud over On-Premise

 

  1. Data Warehousing Concepts
  • What is a Data Warehouse
  • Data Base Vs Data Warehouse
  • Data Ware House Architecture
  • Why do we need Data Warehouse
  • OLTP Vs OLAP
  • What is ETL

 

  1. Introduction to Snowflake
  • Key Concepts & Architecture
  • Cloud Platforms
  • Snowflake Editions
  • Overview of Key Features
  • Overview of the Data Lifecycle
  • Continuous Data Protection

 

  1. Connecting to Snowflake
  • Overview of the Ecosystem
  • Snowflake Partner Connect
  • SnowSQL (CLI Client) - Installation, Configuring and Usage
  • Lab – Snowsql Lab & Exercises

 

 

 

 

 

 

 

 

 

  1. Loading / Unloading Data into/from Snowflake
  • Overview of Data Loading/Unloading
  • Data Loading/Unloading Considerations
  • Preparing to Load/Unload Data
  • Bulk Loading/Unloading from a Local File System
  • Bulk Loading/Unloading from Amazon S3
  • Bulk Loading /Unloading from Microsoft Azure
  • Loading Continuously Using Snowpipe
  • Loading Using the Web Interface (Limited)
  • Querying Data in Staged Files
  • Querying Metadata for Staged Files
  • Transforming Data During a Load
  • Troubleshooting Bulk Data Loads
  • Lab – Data Loading / Unloading Lab & Exercises

 

  1. Using Snowflake
  • Web Interface
  • Virtual Warehouses
  • Databases, Tables & Views
  • Queries
  • Date & Time Data
  • Semi-structured Data
  • Binary Data
  • Snowflake Time Travel & Fail-safe
  • Lab & Exercises

 

  1. Snowflake Continuous Data Pipelines
  • Streams, Tasks & Snowpipe
  • Lab – Streams & Tasks Lab & Exercises

 

  1. Sharing Data in Snowflake
  • Introduction to Data Sharing
  • Data Providers
  • Data Consumers
  • Working with Shares
  • Using Secure Objects to Control Data Access
  • Configuring a Reader Account
  • Managing Reader Accounts
  • Lab – Streams & Tasks Lab & Exercises

 

  1. Managing Your Snowflake Account
  • System Usage & Billing
  • Understanding Snowflake Credit and Storage Usage

 

  1. Understanding Snowflake Data Transfer Billing
  • Monitoring Credit and Storage Usage
  • Resource Monitors
  • Parameter Management
  • User Management
  • Lab – Streams & Tasks Lab & Exercises

 

 

 

 

 

 

 

  1. Managing Security in Snowflake
  • Summary of Security Features
  • Network Policies
  • AWS Private Link & Snowflake
  • Multi-Factor Authentication (MFA)
  • Federated Authentication & SSO
  • Access Control in Snowflake (DAC & RBAC)
  • Data Encryption
  • Lab – Streams & Tasks Lab & Exercises

 

  1. Performance Tuning
  • Query Tuning
  • Clustering
  • Materialized Views
  • Performance Considerations
  1. Real Time Scenarios, Real Time Interview Questions & FAQs

 

 

Date and Time

Not decided yet.

About the Trainer

Avg Rating

0 Reviews

0 Students

2 Courses

Raju

BTech

3 Years of Experience

overall 12 years , 2 years in to snowflake

Reviews

No reviews currently Be the First to Review

Discussions

Raju

Trainer in Snowflake, Informatica Power Center,Bigdata

No Reviews Yet

Students Interested 0 (Seats Left 0)

₹ 25,000 onwards

Post your requirement and let us connect you with best possible matches for BTech Tuition Post your requirement now

Enquire

Submit your enquiry for Snowflake

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Ravi

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Choose Class Location

₹ 25,000
₹ 25,000

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more