+91 99893 03344
[email protected]
Follow Us:

Snowflake Certification Training

4.6

2000+ Learners

Snowflake database is where an organization's uploaded structured and semistructured data sets are held for processing and analysis. Snowflake automatically manages all parts of the data storage process, including organization, structure, metadata, file size, compression, and statistics.

snowflake

Key Highlights

Learn from industry experts who are passionate about teaching.

Instructor-led live sessions.

Industry-Specific Curriculum.

Flexible schedules for working professionals.

Real-life Case Studies.

24 x 7 Lifetime Support & Access.

60 Hrs Project Work & Exercises.

Certification and Job Assistance.

Curriculum

  • What is a Database?
  • What is a Data Warehouse
  • Challenges with traditional Data Warehouses
  • What is Cloud Computing?
  • Software as a Service (SAAS)
  • Platform as a Service (PAAS)
  • Infrastructure as a Service (IAAS)
  • Introduction to Snowflake
  • Advantages of Snowflake
  • Snowflake Architecture
  • Cloud Services Layer
  • Metadata Manager
  • Infrastructure Manager
  • Optimizer Service
  • Authentication and Security
  • Compute Layer
  • Storage Layer
  • Billing for Storage, Compute and Cloud Services Layers
  • Life cycle of a query
  • Ways to connect to Snowflake
  • Availability Zones
  • Snowflake Regions
  • Snowflake Editions
  • Register for free trial account in Snowflake
  • Snowflake Web Interface (UI) Overview
  • Loading SQL scripts to Snowflake
  • Introduction to Snowflake Sample Data
  • Practice Lab for creating Databases, Warehouses, etc.
  • Introduction to SnowSQL
  • Installation and setup of SnowSQL
  • Practice Lab for running SQL Commands using SnowSQL
  • Running a SQL script using SnowSQL
  • Introduction to Snowsight
  • Practice Lab for creating charts and dashboards in Snowsight
  • Metadata Cache
  • Query Result Cache
  • Data Cache
  • Life cycle of a query in terms of caching
  • Practice Lab to work with all 3 types of caching
  • Snowflake Data Objects
  • Types of Tables
  • Permanent Table
  • Temporary Table
  • Transient Table
  • External Table
  • View Types
  • Standard View
  • Secure View
  • Materialized View
  • Snowflake Data Types
  • Practice Lab for working with all table and view types
  • Querying and Filtering Commands
  • Collations
  • Subqueries
  • Practice Lab for working with query fundamentals
  • Query Tags
  • Explain Plan
  • Query Profile
  • Data Loading
  • What is a Stage?
  • Types of Stages
  • What is a File Format?
  • Data Loading commands
  • Data Loading recommendations
  • Bulk Loading Vs Continuous Loading
  • Snowpipe Introduction
  • Loading data through Load Data Wizard
  • Practice Lab for loading data from S3 to Snowflake
  • Data Unloading
  • Data Unloading Tips
  • Data Unloading commands
  • Practice Lab for unloading data from Snowflake to Local File System
  • Introduction to Streams
  • Introduction to Tasks
  • Practice Lab for creating tasks
  • Snowflake Defined Functions
  • User-Defined Functions (UDF)
  • SQL UDF
  • JavaScript UDF
  • Practice Lab for working with various types of functions
  • Stored Procedures
  • User-Defined Functions Vs Stored Procedures
  • Practice Lab for creating Stored Procedures and UDFs
  • Users and Roles Overview
  • System Roles
  • Custom Roles
  • Ownership Vs Grants
  • Practice Lab for creating and configuring Roles
  • Introduction to Semi-Structured Data
  • Supported File Formats
  • Flattening Data
  • Querying Semi-Structured Data
  • Practice Lab for working with Semi-Structured Data
  • Cloning
  • Time Travel
  • Failsafe
  • Database Replication
  • Practice Lab for Cloning and Time Travel
  • Data Share Offerings
  • Secure Direct Data Share
  • Snowflake Data Exchange
  • Snowflake Data Marketplace
  • What is a Share?
  • Data Providers
  • Data Consumers
  • Reader Accounts
  • SQL Performance Tips
  • Resolving Pruning Issues
  • Clustering Keys
  • Virtual Warehouse Scaling
  • Scaling Up
  • Scaling Out
  • Practice Lab on Warehouses Scaling
  • Controlling Costs
  • Resource Monitors
  • INFORMATION_SCHEMA
  • SNOWFLAKE Database
  • ACCOUNT_USAGE
  • Demo on setting up a Resource Monitor
  • Practice Lab on monitoring warehouse usage, billing, querying INFORMATION_SCHEMA and ACCOUNT_USAGE
  • Preview Features overview
  • Releases
  • Tableau Introduction
  • Establishing connection between Snowflake and Tableau
  • Practice Lab for creating reports in Tableau on data present in Snowflake
  • Python Introduction
  • Creating Google Colab account
  • Establishing connection between Snowflake and Python
  • Practice Lab for executing Snowflake queries through Python
  • Certification Exam overview
  • Resources and Reference links
  • Links for practice quizzes
  • Exam tips
  • 40 Theory-based Questions
  • 20 Scenario-based Questions
  • Security Protocols
  • Access
  • Authentication
  • Authorization
  • Data Protection
  • Infrastructure
  • Demo on MFA setup, Network Policy creation, etc.
    • 40
    Hrs of Extensive Training
    8+ 12
    Modules/Tools
    Free Career Guidance



    Snowflake job demand increased to 50% from previous years
    Snowflake are preferred by Global Tech firms
    Snowflake prediction will increase by 70% by the end of 2025
    30% of the cloud job postings ask for skills in Snowflake
    Average salary of Snowflake $2018,052

    Bodhi IT

    3rd Floor, Block A,
    Plot No:532, Above 3M Car Care,
    100 Feet Road, Ayyappa Society, Madhapur, Hyderabad, Telangana-500081.

    +91 99893 03344

    [email protected]

    Services

    Online Training Corporate Training

    Quick Links

    About Us Courses Instructor Reg Contact

    Newsletter

    Get In Touch...

    © 2023 Bodhi IT, All Right Reserved.
    Designed By Teamminds Software Pvt Ltd