Snowflake
Snowflake is a cloud-based data warehousing platform that is designed to help organizations manage and analyze large amounts of data. It is a highly scalable and flexible platform that allows organizations to store, manage, and analyze data from multiple sources in real-time.
Snowflake
Training Mode: Live Instructor-led (online) | Corporate Training | Job Support
Course Duration: 35-40 hours
Trainer: Certified and expert instructors
One of the unique features of Snowflake is its cloud-based architecture, which allows organizations to access and manage their data from anywhere in the world. This makes it easy for organizations to collaborate and share data with their partners, customers, and suppliers.
Snowflake is also designed to be highly secure, with built-in security features such as encryption, access controls, and data masking. This ensures that organizations can protect their sensitive data and comply with industry regulations and standards.
In addition, Snowflake provides a range of tools and services that allow organizations to analyze and visualize their data, create reports and dashboards, and integrate their data with other tools and applications. This makes it easy for organizations to gain insights from their data and make data-driven decisions that can drive business growth and success.
Overall, Snowflake is a powerful and innovative data warehousing platform that is designed to help organizations manage their data more effectively and gain valuable insights from their data.
We guarantee learning at your convenience & pace.
- Instant Access:
Get instant access to self-paced training after signup. - Streaming video recording:
Watch lessons any time at your schedule, free recording. - Exercises:
Practical exercises help you test what you are learning as you go. - Free Demo:
Sign up for free demo to check whether the course is right for you and interact with the faculty live. - Experienced Trainers:
We only hire the industry’s best trainers - Live free interactive web sessions:
Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course. - Structured Curriculum Schedule:
Progress with your complete daily interactive lessons and assignments. - Faculty Mentoring:
Turn in daily and weekly homework for personalized feedback from faculty. - Virtual Office Hours:
Live interaction with the faculty and other students around the world. - Hands on Live Projects:
Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.
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
Contact us
Got more questions?
Talk to our team directly. A program advisor will get in touch with you shortly.
We’re happy to answer any questions you may have and help you determine which of our services best fit your needs.
Schedule a Free Consultation