HOT
blank

Streamlit for Snowflake Masterclass Hands-On

Development

Rating4.8
Enroll Now

Streamlit for Snowflake Masterclass Hands-On, available at $19.99, has an average rating of 4.79, with 58 lectures, 5 quizzes, based on 38 reviews, and has 2726 subscribers.

You will learn about Build, debug and deploy data-driven applications with Streamlit Deploy Streamlit web apps into Snowflake, as Streamlit in Snowflake Apps Share and deploy Streamlit web apps as Snowflake Native Apps Deploy Python code with Snowpark as Snowflake stored procedures and UDFs Connect to Snowflake from a Streamlit web application Build real-life applications with Streamlit and Snowflake Design and deploy to Snowflake data science, data analysis and ML apps with Streamlit Process and access hierarchical data and metadata in Snowflake This course is ideal for individuals who are Data Engineers looking to improve their programming skills with data-driven applications or Data Scientists looking to learn fast prototyping with Streamlit or Software Developers looking to learn a rapid data application development framework or Snowflake Admins looking to master the new Streamlit App and Snowflake Native App frameworks or Data Architects looking to learn about deploying Snowflake Native Apps with Streamlit or Data Analysts looking to learn about using Streamlit to build instant dashboards or Any other technical person looking to learn about using Streamlit to build Snowflake connected applications or Machine Learning Engineers looking for data science projects in Snowflake It is particularly useful for Data Engineers looking to improve their programming skills with data-driven applications or Data Scientists looking to learn fast prototyping with Streamlit or Software Developers looking to learn a rapid data application development framework or Snowflake Admins looking to master the new Streamlit App and Snowflake Native App frameworks or Data Architects looking to learn about deploying Snowflake Native Apps with Streamlit or Data Analysts looking to learn about using Streamlit to build instant dashboards or Any other technical person looking to learn about using Streamlit to build Snowflake connected applications or Machine Learning Engineers looking for data science projects in Snowflake.

Enroll now: Streamlit for Snowflake Masterclass Hands-On

Summary

Title: Streamlit for Snowflake Masterclass Hands-On

Price: $19.99

Average Rating: 4.79

Number of Lectures: 58

Number of Quizzes: 5

Number of Published Lectures: 58

Number of Published Quizzes: 5

Number of Curriculum Items: 63

Number of Published Curriculum Objects: 63

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

  • Build, debug and deploy data-driven applications with Streamlit
  • Deploy Streamlit web apps into Snowflake, as Streamlit in Snowflake Apps
  • Share and deploy Streamlit web apps as Snowflake Native Apps
  • Deploy Python code with Snowpark as Snowflake stored procedures and UDFs
  • Connect to Snowflake from a Streamlit web application
  • Build real-life applications with Streamlit and Snowflake
  • Design and deploy to Snowflake data science, data analysis and ML apps with Streamlit
  • Process and access hierarchical data and metadata in Snowflake

Who Should Attend

  • Data Engineers looking to improve their programming skills with data-driven applications
  • Data Scientists looking to learn fast prototyping with Streamlit
  • Software Developers looking to learn a rapid data application development framework
  • Snowflake Admins looking to master the new Streamlit App and Snowflake Native App frameworks
  • Data Architects looking to learn about deploying Snowflake Native Apps with Streamlit
  • Data Analysts looking to learn about using Streamlit to build instant dashboards
  • Any other technical person looking to learn about using Streamlit to build Snowflake connected applications
  • Machine Learning Engineers looking for data science projects in Snowflake

Target Audiences

  • Data Engineers looking to improve their programming skills with data-driven applications
  • Data Scientists looking to learn fast prototyping with Streamlit
  • Software Developers looking to learn a rapid data application development framework
  • Snowflake Admins looking to master the new Streamlit App and Snowflake Native App frameworks
  • Data Architects looking to learn about deploying Snowflake Native Apps with Streamlit
  • Data Analysts looking to learn about using Streamlit to build instant dashboards
  • Any other technical person looking to learn about using Streamlit to build Snowflake connected applications
  • Machine Learning Engineers looking for data science projects in Snowflake

Why You Can Trust Me

  • I was the only Snowflake technical expert from Canada selected for their Data Superhero program in Jan 2022.

  • Former SnowPro Certification SME (Subject Matter Expert) – many exam questions have been created by me.

  • Passed four SnowPro certification exams to date (with no retakes): Core, Architect, Data Engineer, Data Analyst.

  • Dozens of other certifications in Data Science and Machine Learning, Cloud Solution Architectures, Databases, etc.

  • Dozens of apps designed and implemented with Streamlit and Snowflake on my blog on Medium.

  • Specialized in Snowflake for several years, I served dozens of clients and implemented many real-life projects.

What You Will Learn

  • How to create simple to complex web applications in Streamlit.

  • How to deploy for free local Streamlit web apps to the Streamlit Community Cloud.

  • How to connect to Snowflake from Streamlit apps, through either the Python Connector or a Snowpark session.

  • How to use the DataFrame API and push Python code as stored procedure with Snowpark.

  • How to extend Snowflake’s capabilities, with a hierarchical data viewer and a hierarchical metadata viewer.

  • How to prototype with Streamlit apps data science, machine learning and data analysis scenarios.

  • How to deploy a Streamlit web app as a Streamlit in Snowflake App.

  • How to deploy a Streamlit web app as a Snowflake Native App.

  • How to use the Snowflake Native App Framework to build or use apps with Streamlit.

  • We’ll build several apps in Python from scratch, we’ll then convert them to local single or multi-page Streamlit web apps, deploy and share them on the Streamlit Community Cloud, deploy them in Snowflake as stored procs or Streamlit Apps, share them as Native Apps with other Snowflake accounts…

What Streamlit Areas You Will Learn About

  • Input and Output Controls (Interactive Widgets, Display Text controls, etc.).

  • Layout Components (sidebar, container, expander, tabs, etc.) and Forms.

  • Events and Page Reruns.

  • Data Caching, Session State and Callbacks.

  • Theming and Configuration, TOML Secrets.

  • First half of the course will be an end-to-end complete Streamlit bootcamp, with everything you need to know about Streamlit.

What Snowflake Areas You Will Learn About

  • Creating a free Snowflake account and using the Snowflake web UI at the basic level.

  • Connecting to Snowflake with SnowSQL, and executing SQL scripts with this command-line interface.

  • Connecting to Snowflake with the Snowflake Connector for Python.

  • Connecting to Snowflake with Snowpark for Python.

  • Using Snowpark to push Python code as stored procedures.

  • Using Snowpark to generate SQL queries with the DataFrame API.

  • Writing and deploying Streamlit in Snowflake Apps.

  • Writing and deploying Snowflake Native Apps, with the Snowflake Native App Framework.

  • Integrating Snowflake with ChatGPT, external dashboards, data science and machine learning libraries.

  • Second half of the course will be all about Snowflake client apps, Snowpark, Streamlit in Snowflake Apps and Native Apps.

What is NOT Included in This Course

  • In-depth knowledge of Snowflake.

  • In-depth data science, data analytics and machine learning.

  • Programming in languages other than Python and SQL.

  • Main focus will be on all sorts of applications in Python using Streamlit, to connect and deploy the code to Streamlit Cloud or Snowflake in all possible ways.

Real-Life Applications You Will Learn To Build

  • Hierarchical Data Viewer, for CSV files and Snowflake tabular data, using JSON, graphs, animations, recursive queries.

  • Hierarchical Metadata Viewer, for Snowflake object dependencies and data lineage.

  • Entity-Relationship Diagram Viewer for Snowflake.

  • Chatbot Agent with OpenAI’s ChatGPT, used as a SQL query generator for Snowflake Marketplace datasets.

  • Dashboards for Snowflake data, with Vega-Lite, Altair and Plotly charts.

  • Machine Learning scenarios, with Model Training and Predictions.

  • Data enrichment of IP addresses using external free services.

  • I sold tools similar to many of these to real-life clients and Snowflake partners!

Enroll today, to keep this course forever!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Structure and Content

Lecture 2: Best Ways to Benefit from this Course

Lecture 3: SnowPro Snowflake Certifications: Added Material!

Lecture 4: All Slides and Resources

Lecture 5: Initial Requirements and Project Setup

Chapter 2: Testing Local Streamlit Web Apps

Lecture 1: Introduction and Section Summary

Lecture 2: Build a Simple Hierarchical Data Viewer in Python

Lecture 3: Convert the Hierarchical Data Viewer to a Streamlit Web App

Lecture 4: Hierarchical Data Charts in Streamlit with Plotly

Lecture 5: Streamlit Layout Components

Lecture 6: Add Hierarchical Formats and Animation

Lecture 7: Improve Original Data Viewer App and Make It More Generic

Lecture 8: Use Streamlit Input Controls

Lecture 9: Cache Data Between Page Reruns

Lecture 10: Save State Data Between Page Reruns

Lecture 11: Use Control Callbacks on Page Reruns

Lecture 12: Finalize the Hierarchical Data Viewer as a Streamlit Web App

Chapter 3: Sharing Streamlit Web Apps in Streamlit Cloud

Lecture 1: Introduction and Section Summary

Lecture 2: Deploy Your Local Web App to Streamlit Cloud

Lecture 3: Use Data Caching with a Generated Session ID

Lecture 4: Make App Private and Protect Public App Access

Lecture 5: Data Analysis of Real-Estate Properties with a BI Streamlit App

Lecture 6: ML Object Detection with a CNN Data Science Streamlit App

Chapter 4: Connecting Streamlit Apps to Snowflake

Lecture 1: Introduction and Section Summary

Lecture 2: Upload Data into a New Snowflake Account through the Web UI

Lecture 3: Connect to Snowflake with SnowSQL CLI

Lecture 4: Connect to Snowflake with the Connector for Python

Lecture 5: Connect to Snowflake with Snowpark for Python

Lecture 6: Build a Complex Query with the Python Client and Snowpark

Lecture 7: Build a Complex Query with the Snowpark DataFrame API

Lecture 8: Push Python Code as a Stored Procedure with Snowpark

Lecture 9: Connect to Snowflake with Streamlit Connector in Multi-Page App

Lecture 10: Connect the Hierarchical Data Viewer to Snowflake

Lecture 11: Enhance the Hierarchical Data Viewer with Recursive Queries

Lecture 12: Deploy the Connected Hierarchical Data Viewer to Streamlit Cloud

Lecture 13: Create a Hierarchical Metadata Viewer as a Streamlit Multi-Page App

Lecture 14: Create an Entity-Relationship Diagram Viewer with Streamlit

Lecture 15: Create a NLP Sentiment Analysis App with the IMDB Reviews

Lecture 16: Integrate Snowflake with ChatGPT

Lecture 17: Create a ChatGPT Agent for Your Web Pages

Chapter 5: Deploying Streamlit Apps to Snowflake

Lecture 1: Introduction and Section Summary

Lecture 2: Create and Deploy a Streamlit in Snowflake App

Lecture 3: Deploy the Hierarchical Data Viewer in Snowflake as a Streamlit App

Lecture 4: Deploy the Hierarchical Metadata Viewer in Snowflake as a Streamlit App

Lecture 5: Create a Multi-Page Dashboard with Vega-Lite Charts as a Streamlit App

Lecture 6: Create a Multi-Page Dashboard with Altair Charts as a Streamlit App

Lecture 7: Train a Linear Regression ML Model and Predict with UDF

Lecture 8: Deploy the Hierarchical Metadata Viewer as a Snowflake Native App

Lecture 9: Deploy the Hierarchical Data Viewer as a Snowflake Native App

Lecture 10: Review the Snowflake Native App Framework

Lecture 11: Enrich IP Address Data with a Snowflake Native App

Lecture 12: Install and Run a Free Snowflake Native App from the Marketplace

Chapter 6: The SnowPro Core Certification

Lecture 1: About this Added Material

Lecture 2: General Info about all SnowPro Snowflake Certifications

Lecture 3: Overview of the SnowPro Core Certification

Lecture 4: Sample Questions for the SnowPro Core Exam

Chapter 7: Wrapping Up

Lecture 1: Congratulations, You Made It!

Lecture 2: Bonus Lecture

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 2 votes
  • 4 stars: 7 votes
  • 5 stars: 29 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024