16 Hours Snowflake cloud data platform Training in Essen

Tech Training Solutions

16 Hours Snowflake cloud data platform Training is being delivered  from October 29, 2020 - November 24, 2020 US Pacific time.

IT Training Center

<p><a href="https://techtraining.solutions/training-products/ols/products/snowflake-cloud-data-platform-training-course" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">This event has been UPDATED since it was first published. View the UPDATED &amp; Detailed Snowflake cloud data platform  Training course for beginners Information here.</a></p><p>16 Hours Snowflake cloud data platform training course is Instructor-led and guided and is being delivered from  October 29, 2020 - November 24, 2020 for 16 Hours over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.</p><ul><li>Instructor-led and guided training</li><li>Practical Hands-On, Highly Interactive training</li><li>This course will be taught in English language</li><li>All Published Ticket Prices are in US Dollars</li></ul><h3></h3><h3>16 Hours Snowflake cloud data platform Training Course Schedule</h3><ul><li>October 29, 2020 - November 24, 2020 US Pacific time </li><li>16 Hours | 2 Hours on Tuesdays, 2 Hours on Thursdays every week US Pacific time</li><li>7:30 AM - 9:30 AM US Pacific time each of those days</li><li><a href="https://www.timeanddate.com/worldclock/converter.html?iso=20201029T143000&amp;p1=234" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Please click here to add your city name and check your local date and time for the first session to be held on  October 29, 2020 at 7:30 AM US Pacific Time.</a></li></ul><p></p><h3>Features and Benefits</h3><ul><li>16 Hours, 8 sessions, 4 weeks of total Instructor-led and guided training</li><li>Training material, instructor handouts and access to useful resources on the cloud provided</li><li>Practical Hands-on Lab exercises provided</li><li>Actual code and scripts provided</li><li>Real-life Scenarios</li></ul><p></p><h3>Course Objectives</h3><ul><li>Initial configuration</li><li>security and data management</li><li>creating snowflake objects</li><li>stage the data files</li><li>query the loaded data</li><li>Data sharing and validations in different formats</li><li>implementing standard and extended SQL support,</li><li>hands-on in SnowSql (Python-based web-client).</li></ul><p></p><h3>Prerequisites</h3><p>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.</p><ul><li>Database</li><li>Beginner level Python</li></ul><p> </p><h3>Who can take Snowflake cloud data platform Training Course?</h3><ul><li>Data Engineers</li><li>Database management professionals</li></ul><h3></h3><h3>Course Outline</h3><p>1. Cloud Data Warehouse</p><ul><li>Data warehousing: past to present</li><li>Understanding the benefits of a cloud data warehouse</li><li>Recognizing where cloud data warehousing fits in today&#x27;s economy</li></ul><p>2. Why the modern data warehouse emerged?</p><ul><li>Adapting to increasing demands for data access and analytics</li><li>Adjusting to how data is created and used today</li><li>Tackling the challenges with new and improved technologies</li></ul><p>3. Selecting a Modern Data Warehouse</p><ul><li>Choosing the right data warehouse solution</li><li>Getting a high performance-to-price ratio</li><li>Making data security and protection a priority</li></ul><p>4. Comparing Cloud Data Warehouse Solutions</p><ul><li>Evaluating differences between cloud data warehouse options</li><li>Considering factors that affect performance</li><li>Choosing a solution that ensures data protection and security</li><li>Gauging your savings in administrative costs</li><li>Listing your data warehouse needs and success criteria</li><li>Considering all factors in the total cost of ownership</li><li>Taking your data warehouse for a test drive before you buy</li></ul><p>5. Introduction and Connecting to Snowflake</p><ul><li>Key Concepts &amp; Architecture</li><li>Cloud Platforms</li><li>Snowflake Editions</li><li>Overview of Key Features</li><li>Overview of the Data Lifecycle</li><li>Continuous Data Protection</li><li>Overview of the Ecosystem</li><li>SnowSQL (CLI Client)</li><li>Installing SnowSQL</li><li>Configuring SnowSQL</li><li>Connecting Through SnowSQL</li><li>Using SnowSQL</li><li>JDBC Driver</li><li>Downloading / Integrating the JDBC Driver</li><li>Configuring and Using the JDBC Driver</li><li>JDBC Driver Diagnostic Service</li><li>ODBC Driver</li><li>Downloading the ODBC Driver</li><li>Installing and Configuring the ODBC Driver for Windows</li><li>ODBC Configuration and Connection Parameters</li><li>ODBC Driver API Support</li><li>ODBC Driver Diagnostic Service</li><li>Client Considerations</li><li>Diagnosing Common Connectivity Issues</li></ul><p>6. Loading/Unloading Data Into/from Snowflake</p><ul><li>Overview of Data Loading/Unloading</li><li>Data Loading/Unloading Considerations</li><li>Preparing to Load/Unload Data</li><li>Bulk Loading/Unloading from a Local File System</li><li>Bulk Loading/Unloading from Amazon S3</li><li>Bulk Loading /Unloading from Microsoft Azure</li><li>Loading Continuously Using Snowpipe</li><li>Loading Using the Web Interface (Limited)</li><li>Querying Data in Staged Files</li><li>Querying Metadata for Staged Files</li><li>Transforming Data During a Load</li></ul><p>7. Using and Sharing Data in Snowflake</p><ul><li>Using the Web Interface</li><li>Virtual Warehouses</li><li>Databases, Tables &amp; Views</li><li>Queries</li><li>Date &amp; Time Data</li><li>Semi-structured Data</li><li>Binary Data</li><li>Snowflake Time Travel &amp; Fail-safe</li><li>Introduction to Data Sharing</li><li>Data Providers</li><li>Getting Started with Data Sharing</li><li>Working with Shares</li><li>Using Secure Objects to Control Data Access</li><li>Managing Reader Accounts</li><li>Configuring a Reader Account</li><li>Data Consumers</li></ul><p>8. Managing your Snowflake Account</p><ul><li>System Usage &amp; Billing</li><li>Understanding Snowflake Credit and Storage Usage</li><li>Understanding Snowflake Data Transfer Billing</li><li>Monitoring Account-level Credit and Storage Usage</li><li>Working with Resource Monitors</li><li>Parameter Management</li><li>User Management</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

16 Hours Snowflake cloud data platform Training in Essen

More events from Tech Training Solutions

Discover more events from Tech Training Solutions, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Essen and filter by date, category, and more to find the perfect fit.

16 Hours Snowflake cloud data platform Training in Essen

More events from Tech Training Solutions

Discover more events from Tech Training Solutions, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Essen and filter by date, category, and more to find the perfect fit.