Snowflake Training

Trusted By Companies Worldwide & 32,052+ Learners

Duration

30 Hrs

Live Projects

2

Next Batch

Monday

Snowflake Course Curriculum

  • Data warehousing: past to present
  • Understanding the benefits of a cloud data warehouse
  • Recognizing where cloud data warehousing fits in today’s economy
  • 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
  • Choosing the right data warehouse solution
  • Getting a high performance-to-price ratio
  • Making data security and protection a priority
  • 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
  • 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
  • Key Concepts & Architecture
  • Cloud Platforms
  • Snowflake Editions
  • Overview of Key Features
  • Overview of the Data Lifecycle
  • Continuous Data Protection
  • 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
  • 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 the Web Interface
  • Virtual Warehouses
  • Databases, Tables & Views
  • Queries
  • Date & Time Data
  • Semi-structured Data
  • Binary Data

Snowflake Time Travel & Fail-safe

  • 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
  • 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
  • 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
Connect with Advisor

Course FAQ's

Have questions? We’ve got the answers. Get the details on how you can grow in this course.

We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth. 

We will share you the missed session from our recordings. We at US IT Skills maintains a recorded copy of each live course you undergo.

Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.

We provide all the training sessions LIVE using either GoToMeeting or WebEx, thus promoting one-on-one trainer student Interaction.

Live training uncovers distinct benefits as they are mighty to reach your desired audience converting your prospects into customers in less time. Pre-recorded videos offer plenty of advantages for entrepreneurs to educate entertain and inspire your audience as long as you want.

Yes. We provide the course materials available after course completion.

If you are enrolled in classes and/or have paid fees but want to cancel the registration for a certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of the prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

Join a Free Business Analyst Demo Session

Attend a Demo Session | Meet the Expert
Who Can Kickstart Your Career in Business Analyst