About this Event
This event has been UPDATED since it was first published. View the UPDATED & Detailed Snowflake cloud data platform Training course for beginners Information here.
4 Weeks Snowflake cloud data platform training course is Instructor-led and guided and is being delivered from February 1, 2021 - February 24, 2021 for 16 Hours over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.
- Instructor-led and guided training
- Practical Hands-On, Highly Interactive training
- This course will be taught in English language
- All Published Ticket Prices are in US Dollars
4 Weeks Only Snowflake cloud data platform Training Course Schedule
- February 1, 2021 - February 24, 2021 US Pacific time
- 4 Weeks | 2 Hours on Mondays, 2 Hours on Wednesdays every week US Pacific time
- 5:30 PM - 7:30 PM US Pacific time each of those days
- Please click here to add your city name and check your local date and time for the first session to be held on February 1, 2021 at 5:30 PM US Pacific Time.
Features and Benefits
- 16 Hours, 8 sessions, 4 weeks of total Instructor-led and guided training
- Training material, instructor handouts and access to useful resources on the cloud provided
- Practical Hands-on Lab exercises provided
- Actual code and scripts provided
- Real-life Scenarios
Course Objectives
- Initial configuration
- security and data management
- creating snowflake objects
- stage the data files
- query the loaded data
- Data sharing and validations in different formats
- implementing standard and extended SQL support,
- hands-on in SnowSql (Python-based web-client).
Prerequisites
If you do not have any of these prerequisite skills we will be happy to teach you these skills for additional cost before you take this training course.
- Database
- Beginner level Python
Who can take Snowflake cloud data platform Training Course?
- Data Engineers
- Database management professionals
Course Outline
1. Cloud Data Warehouse
- Data warehousing: past to present
- Understanding the benefits of a cloud data warehouse
- Recognizing where cloud data warehousing fits in today's economy
2. 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
3. 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
4. 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
- 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
5. Introduction and Connecting to Snowflake
- 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
6. 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
7. Using and Sharing Data in Snowflake
- 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
8. 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
Event Venue & Nearby Stays
IT Training Center, Tech Training Solutions, Elk Grove, United States
USD 700.00 to USD 800.00