Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    Snowflake Masters Brochure

    Uploaded by

    prashanthreddy270894

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Snowflake Masters Brochure

    Uploaded by

    prashanthreddy270894
    24 views7 pages

    Original Title

    Snowflake-Masters-Brochure

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    24 views7 pages

    Snowflake Masters Brochure

    Uploaded by

    prashanthreddy270894

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 7

    SNOWFLAKE TRAINING

    WITH

    100% PLACEMENT
    ASSISTANCE
    CERTIFICATION DUMPS
    INTERVIEW QUESTIONS
    DAILY RECORDINGS
    RESUME PREPARATION
    SNOWFLAKEMASTERS.IN

    REGISTER FOR MORE INFORMATION


    9640 5380 67
    NOW
    Snowflake Masters Course Modules
    Snowflake Advanced
    01 15
    Architecture Topics

    Introduction Query Caching,


    to Cloud
    02 14
    Performance techniques

    Introduction to Time travel &


    03 13
    Data Warehousing Failsafe

    Introduction
    to Snowflake 04 12 Cloning

    Understand Secure Data


    05 11
    Cloud platforms sharing

    Data Loading 10 Scheduling with


    06 Snowflake
    and Unloading

    SnowPipe 07 09 Handling JSON and


    Trend analytics
    Semi structured data

    Partner connect
    with snowflake 08
    SNOWFLAKE MASTERS COURSE
    CURRICULUM
    Snowflake Architecture and Overview
    Snowflake Overview
    01 Architecture
    How to use the Snowflake UI & ecosystem

    Introduction to Cloud
    What is Cloud
    Different Cloud Vendors
    02 Advantages of Cloud over On-Premise

    Introduction to Data Warehousing Concepts


    What is a Data Warehouse, and Why do we need a Data
    Warehouse?
    Database Vs Data Warehouse.
    03 Data Warehouse Architecture
    OLTP Vs OLAP
    What is ETL

    Introduction to Snowflake
    How different from traditional DB
    Quick start to the snowflake and accessing trial account
    04 Creating warehouse, DB, Schema, and tables
    Accessing different roles and using it
    Working with worksheets
    Understanding different type of accounts

    Understand Cloud platforms


    05 AWS and understanding S3 storage
    Snowflake architecture and caching
    AZURE and understanding blob storage
    GCP and understanding Bucket storage
    Data Loading and Unloading
    File formats
    Internal and external storage
    06 Internal and external stage
    Copy into usage
    Snowflake internal storage
    Accessing Cloud storage data into Snowflake
    (GCP, AZURE and AWS)
    Data unloading

    SnowPipe
    07 Accessing Snowpipe
    PUT and GET commands
    Bulk loading from cloud storage
    Continuous loading

    Partner connect with snowflake


    08 Snowflake Connector and use cases Python
    BI connectors use cases
    Other connectors hands-on

    Handling JSON and Semi structured data


    Variant Data Type
    09 File format options
    Creating stages
    Loading JSON semi-structured data into SF tables
    Accessing JSON with select statement

    Scheduling with Snowflake


    Creating Tasks
    Streams
    10 Accessing procedures with tasks
    Scheduling as per time with Different time zones
    Automate loading process Daily and Weekly
    Secure Data sharing
    Usage of sharing data
    Sharing data with different accounts
    Sharing data with non-SF accounts using reader accounts
    Importance of reader accounts
    11 Privileges in data sharing
    Challenges with cross-region sharing and understanding replication
    Connecting shared objects with BI tools
    Limitations with Data sharing

    Cloning
    Access Control Privileges for Cloned Objects
    12 Cloning and Snowflake Objects
    Impact of DDL on Cloning
    Impact of DML and Data Retention on Cloning

    Time travel & Failsafe


    Introduction to Time Travel
    13 Querying Historical Data
    Enabling and Disabling Time Travel
    Data Retention Period
    Cloning Using Time Travel (Databases, Schemas, and Tables Only)

    Query Caching, Clustering, and Performance techniques


    Creating multi-users on large tables
    Performance techniques
    14 Result set cache
    Metadata cache
    Query data cache
    Best practices of using caching for performance and cost
    optimization

    Advanced Topics
    Error Handling and Validations
    Snowflake Pricing model and selecting best Edition and Calculation of
    Credits usage
    15 Resource Monitoring
    Data Masking
    Partitioning and Clustering in snowflake
    Materialized View and Normal View
    Integration with Python
    Integration with AWS, Azure and Google Cloud
    The Key points of
    Snowflake Masters
    01 Our experienced trainer, Mr. Dinesh Reddyvari (certified Trainer), offers the best snowflake online live training sessions.

    02 We are proud to have trained over 200 Snowflake professionals in the previous three months

    We provide Individual Trainings, Group Trainings, and Corporate Trainings. We have taught over 3000+ profiles on
    03
    Snowflake, combining all the trainings.

    04 Our trainers have at least 15 years of industry expertise and about 5 years of exclusive snowflake experience.

    We have relationships with various training partners across various locations, beginning with corporations in the United
    05
    States and expanding to include many more.

    06 We focus not only on theoretical instruction, but also on live interactive sessions with practical experience.

    07 Before registering for the course, you can choose to attend a couple of free demo sessions.

    Our placement assistance programme is 100% guaranteed. Sample resumes, certification dumps, interview questions,
    08 and project updates for resumes are all available.

    There are three different training options: self-paced recorded videos, online training, and classroom instruction.
    09
    Available offline at the Bangalore location.

    Unlike others, we provide practical real-time project training together with a few case studies and training dataset
    10
    examples.

    11 We record every lesson, and you will have lifetime access to these recordings via our LMS and Google Drive.

    Batch Repeat Facility: You can watch the video recordings if you missed a few sessions, but you can also join the
    12 upcoming batch's live training at no extra cost.

    www.snowflakemasters.in
    SNOWFLAKE
    MASTERS
    Snowflake Masters is one of the top
    Snowflake training institutes in
    Ameerpet, Hyderabad, with industry
    expert trainers

    ENROLL FOR FREE DEMO


    +91 9640538067

    www.Snowflakemasters.in

    #207, 2nd Floor, Manjeera trinity Corporate,


    Besides Manjeera Cinepolis mall, KPHB Colony,
    Kukatpally, Hyderabad. 500072

    You might also like