**Get New Year Discount of 40% on Snowflake Training ***

*Register by Jan 10th for course Starting from Jan 15 2023**

Getting Up To Speed On Cloud Data Warehousing
  • Data warehousing: past to present
  • Understanding the benefits of a cloud data warehouse
  • Recognizing where cloud data warehousing fits in today‚Äôs economy
Why The Modern Data Warehouse Emerged
  • Adapting to increasing demands for data access and analytics
  • Adjusting to how data is created and used today
  • Tackling the challenges with new and improved technologies
The Criteria For Selecting A Modern Data Warehouse
  • Choosing the right data warehouse solution
  • Getting a high performance-to-price ratio
  • Making data security and protection a priority
Comparing Cloud Data Warehouse Solutions
  • Evaluating differences between cloud data warehouse options
  • Considering factors that affect performance
  • Choosing a solution that ensures data protection and security
  • Gauging your savings in administrative costs
Six Steps To Getting Started With Cloud Data Warehousing
  • Listing your data warehouse needs and success criteria
  • Considering all factors in the total cost of ownership
  • Taking your data warehouse for a test drive before you buy
Introduction To Snowflake
  • Key Concepts & Architecture
  • Cloud Platforms
  • Snowflake Editions
  • Overview of Key Features
  • Overview of the Data Lifecycle
  • Continuous Data Protection
Connecting To Snowflake
  • Overview of the Ecosystem
  • SnowSQL (CLI Client)
  • Installing SnowSQL
  • Configuring SnowSQL
  • Connecting Through SnowSQL
  • Using SnowSQL
  • JDBC Driver
  • Downloading / Integrating the JDBC Driver
  • Configuring and Using the JDBC Driver
  • JDBC Driver Diagnostic Service
  • ODBC Driver
  • Downloading the ODBC Driver
  • Installing and Configuring the ODBC Driver for Windows
  • ODBC Configuration and Connection Parameters
  • ODBC Driver API Support
  • ODBC Driver Diagnostic Service
  • Client Considerations
  • Diagnosing Common Connectivity Issues
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
Using Snowflake
  • Using the Web Interface
  • Virtual Warehouses
  • Databases, Tables & Views
  • Queries
  • Date & Time Data
  • Semi-structured Data
  • Binary Data
  • Snowflake Time Travel & Fail-safe
Sharing Data In Snowflake
  • Introduction to Data Sharing
  • Data Providers
  • Getting Started with Data Sharing
  • Working with Shares
  • Using Secure Objects to Control Data Access
  • Managing Reader Accounts
  • Configuring a Reader Account
  • Data Consumers
Managing Your Snowflake Account
  • System Usage & Billing
  • Understanding Snowflake Credit and Storage Usage
  • Understanding Snowflake Data Transfer Billing
  • Monitoring Account-level Credit and Storage Usage
  • Working with Resource Monitors
  • Parameter Management
  • User Management
Customer Specific Topics
  • Informatica Cloud Services and Snowflake Integration
  • Introduction to Snowflake Connector
  • Snowflake Connector Task and Object Types
  • Informatica Cloud Hosted Agent
  • Snowflake Connections
  • Snowflake Connection Properties
  • Mappings and Mapping Configuration Tasks with Snowflake Connector
  • Snowflake Objects in Mappings
  • Pushdown Optimization
  • Snowflake Sources in Mappings
  • Key Range Partitioning
  • Snowflake Targets in Mappings
  • Snowflake Lookups in Mappings
  • Rules and Guidelines for Snowflake objects
  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube

Popular Posts

Online Live Instruct

Students attend well-structured Video sessions by certified instructors and SME's. ...

Self Paced Video Tra

Students learn from pre-recorded videos of the Live sessions. Learn ...

Live Instructor Led

Students attend well structured Live Interactive sessions by certified instructors. ...