Snowflake Training in Hyderabad

Learning objective: This chapter introduces you to the concept of cloud data warehousing and covers the below concepts.

Topics:

• • History of Data warehousing
  • Trends in Data warehousing
  • Introduction to cloud data warehousing
  • Benefits of Cloud data warehousing
  • Understanding the areas where cloud data warehousing is required.

Learning Objective: You will have gained a brief overview of cloud data warehouse and its areas of implementation.

Learning objective: This chapter will teach you the reasons and challenges behind the innovation of modern data warehouse systems.

Topics:

• • The desperate need for accessing data and analytics
  • The rate of data creation today and its role
  • Challenges associated with traditional data warehouse systems.

Learning Objective: Upon the completion of this chapter, you will have gained in-depth knowledge of the challenges and problems associated with traditional data warehouse systems.

Learning Objective:  This module teaches you how to evaluate and choose the best cloud data warehouse system for a business.

Topics:

• • The process to choose the right data warehouse
  • Performance delivery
  • Checking with data privacy and protection

Learning Outcome: you will gain insights on how to choose the right cloud data warehouse system for your business.

Learning Objective: In this chapter, you will learn the procedure to analyze the cloud Data Warehouse options.

Topics:

• • Examining cloud Data Warehouse options
  • Identifying the factors that impact performance
  • Selection of a solution that meets data protection and security standards

Learning Objective: Upon the completion of this module, you will have gained knowledge of how to check with the important factors of a data warehouse system.

Learning objective: This chapter introduces you to the key concepts of Snowflake and helps you gain a clear glance of key components of Snowflake.

Topics:

• • Key Concepts & Architecture
  • Snowflake Editions
  • Cloud Platforms
  • Key features of Snowflake
  • Brief glance of Data lifecycle
  • Continuous Data Protection

Learning outcome: By the end of this chapter, you will have gained a complete overview of Snowflake architecture and its key components.

Learning Objective: This chapter teaches you important concepts such as snowflake installation, configuration, installation of various drivers and much more.

Topics:

• • Introduction to Snowflake Ecosystem
  • SnowSQL (CLI Client)
  • SnowSQL Installation
  • Configuring SnowSQL
  • Connecting Through SnowSQL
  • JDBC Driver
  • Using SnowSQL
  • The process to download and integrate JDBC Driver
  • JDBC configuration and usage
  • Introduction to ODBC Driver
  • Downloading and installation of an ODBC Driver on Windows machine
  • Configuration of ODBC and its parameters
  • Client Considerations
  • Resolving general issues.

Learning Outcome: Upon finishing this module you will gain hands-on experience in Snowflake installation, configuration and integration with required drivers. 

Learning Objective: This is one of the essential chapters of Snowflake training and teaches you how data loading and unloading happens in Snowflake.

Topics:

• • Introduction to Data loading
  • Overview of Data unloading
  • The process to load and unload data in Snowflake
  • Loading and unloading bulk data into and out of local file system
  • Data loading and unloading from Amazon S3
  • Bulk data load into Azure and unloading data out of it
  • Continuous data loading using Snowpipe
  • Data Loading using the web interface
  • Querying Metadata for Staged Files
  • Querying Data in Staged Files
  • Data transformation during a load

Learning Objective: By the end of this module, you will gain practical exposure in handling data activities such as bulk data loading and unloading and also various other operations related to data loading.

Learning Objective: This chapter deals with the essential concepts of Snowflake and makes you knowledgeable in the following areas.

Topics:

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

Learning Objective: Upon finishing this chapter you will gain hands-on experience in all the above concepts through real-time applications.

Learning Objective: In Snowflake we can share databases through shares, and these shares are developed by data providers and “imported” by data consumers. In this chapter, you will come across the below concepts.

Topics:

• • A detailed overview of data sharing
  • Data Providers
  • Working with Shares
  • Using controllers to protect data access
  • Configuring a reader account
  • Managing Reader accounts
  • Data consumers

Learning Objective: By the end of this chapter, you will gain hands-on experience in data sharing in snowflake and managing data shares.

Learning Objective: This module teaches you the process to access historical data, restoring data objects, duplicating and backing up data etc. Moreover, you will also learn to protect historical data using Failsafe.

Topics:

• • What is Time travel?
  • Historical data querying
  • Data retention period
  • Activating and deactivating Time -travel
  • Cloning using Time-travel

Learning Outcome: Upon the completion of this module you will have gained hands-on experience in using time-travel and Failsafe.

Learning Objective: Cloning is referred to as “zero-copy cloning” which creates a copy of a database, table or schema. This chapter teaches you how to clone and things to consider while performing cloning.

Topics:

• • Cloning fundamentals
  • Access privileges for cloned objects
  • Impact of DDL and data retention on Cloning

Learning Outcome: Upon the completion of this module you will have acquired knowledge to handle all types of Cloning tasks in Snowflake.

Learning Objective: This module has been designed to help you learn the process to deal with JSON and semi-structured data sets in Snowflake.

Topics:

• • File format options
  • Creating stages
  • Loading JSON files into SF tables

Learning Outcome: By the end of this module you will have gained hands-on exposure in handling unstructured data.

Learning Objective: This module has been designed to teach you all the fundamental concepts required to make you expert in managing Snowflake accounts and various operations associated with it.

Topics:

• • System Usage & Billing
  • Overview of Snowflake Credit and data usage
  • A brief examination of Snowflake Data Transfer Billing
  • Working with Resource Monitors
  • User Management
  • Parameter Management

Learning Outcome: You will gain practical experience in system usage, data usage, user management, parameter management, etc.

Learning Objective: In this module, you are going to learn concepts related to Informatica and integration between Snowflake and Informatica.

Topics:

• • Snowflake integration with Informatica
  • Introduction to Snowflake Connector
  • Snowflake Connections
  • Informatica Cloud Hosted Agent
  • Snowflake Connection Properties
  • Mapping and its configuration
  • Snowflake Objects in Mappings
  • Snowflake Sources in Mappings
  • Pushdown Optimization
  • Snowflake Targets in Mappings
  • Key Range Partitioning
  • Snowflake Lookups in Mappings

Learning Outcome: Upon the completion of this module you will gain hands-on experience in integrating Snowflake with Informatica, mapping, using Snowflake connectors, etc.