Course Description
What is Snowflake ?
Snowflake is cloud based data warehouse and analytical tool. With so many SAAS based Data warehouse applications available currently that are competing against one another, Snowflake stands out among the crowd for it uniqueness in design and approach. Snowflake works on an application that is faster and easier to handle. Unlike other data warehouse systems Snowflake is not built on Big data platforms rather it works on new SQL engine that is best suited for cloud. Having one of the best ACID (atomicity, consistency, isolation, and durability) complaint solutions. One of the USPs of Snowflake’s unique capabilities is in its table structures wherein Micro–Partitions and Data–Clustering are adopted Snowflake allows user to “time travel” i.e., track data changes overtime and view changes made anytime in the past up to a 90–days Some of the other features of Snowflake are
- Cloning – the clone feature create instant copy of any snowflake object
- Undrop – any dropped object (Databases, schemas, tables etc) can be undroped
- Fail safe – In the event of any disaster like hardware or disk failures. Snowflake engineers can recover the data upto a 7 day period post failure
Analytics Solution - Snowflake architecture helps in dealing with data and analytics alongside with data warehousing capabilites
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
ExcelR's Expertise
ExcelR solutions a leader in corporate trainings across India and the globe with its headquarters in the US and offices in Bangalore and Hyderabad conducts training programs on snowflake across various locations for diverse clients. ExcelR solutions have conducted a myriad training programs for various clients and is specialized team of trainers for engaging in corporate trainings. Our pool of trainers are experts in their said fields and have in – depth expertise in various cloud platforms especially snowflake warehouse. Experiences gained over time from training and implantation across different clients form a crucial part of our case study based training
Snowflake Online Training
ExcelR offers live online Snowflake training where participants can attend instructor led live training. Online Snowflake training sessions would be very interactive where trainer and participants will login at the same time and the sessions will be delivered. Every live online Snowflake session will be recorded and access will be provided on our state-of-the-art e-learning Learning Management System (LMS). Participants can revise and recap the Snowflake training sessions at their own pace and convenience.
Support
While in our Snowflake training program our curriculum and trainers will impart all the necessary knowledge to the participants, it is however when the time for actual application arises, do the participants realize that there are certain gaps that need to be filled up. We at ExcelR solutions have been addressing this issue with a dedicated post training support network. The trainer remains in continuous contact with the participants. And issues related to going live with the implementation or migration as the case maybe is closely monitored remotely to minimize delays. ExcelR solutions is leader on snowflake training because of the multimodal training and support that we provide to our clients
Customized Training
ExcelR Solutions is a leading Snowflake training service provider in the space of niche programs from across the world. For the training program on “Snowflake adoption” a comprehensive curriculum has been designed keeping the unique needs of our corporates in mind. Snowflake training program will guide the participants through the key features of Snowflake , moving on to explain about the snowflake architecture, work with the virtual warehouse feature of snowflake, learn about querying and loading on the database. The last module of the Snowflake training will be the hands on wherein the setting up, loading data and querying process will be explained in detail. We at ExcelR understand that different corporates will need different takeaways form the same course and therefore the training shall provide emphasis on pain and often used area of the any warehousing application that our client has.
Contact Our Team of Experts
