Ce que vous devez savoir avant
Vous commencez

Débute 5 June 2026 18:36

Se termine 5 June 2026

00 Jours
00 Heures
00 Minutes
00 Secondes
course image

Masterclass pratique Streamlit pour Snowflake

Débloquez le potentiel de Streamlit dans cette masterclass complète conçue pour vous emmener du développement d'applications web locales à l'utilisation de Streamlit dans les environnements Snowflake et la création d'applications natives. Idéale pour les professionnels cherchant à améliorer leurs compétences en intelligence artificielle et e.
via Udemy

4160 Cours


9 hours 22 minutes

Amélioration optionnelle disponible

Not Specified

Progressez à votre rythme

Paid Course

Amélioration optionnelle disponible

Aperçu

Deep dive into Streamlit, from local web application to Streamlit in Snowflake and Native Apps What you'll learn:

Build, debug and deploy data-driven applications with StreamlitDeploy Streamlit web apps into Snowflake, as Streamlit in Snowflake AppsShare and deploy Streamlit web apps as Snowflake Native AppsDeploy Python code with Snowpark as Snowflake stored procedures and UDFsConnect to Snowflake from a Streamlit web applicationBuild real-life applications with Streamlit and SnowflakeDesign and deploy to Snowflake data science, data analysis and ML apps with StreamlitProcess and access hierarchical data and metadata in Snowflake Why You Can Trust MeI 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 LearnHow 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 AboutInput 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 AboutCreating 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 CourseIn-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 BuildHierarchical 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!

Programme

  • Introduction au Cours
  • Aperçu de Streamlit et Snowflake
    Objectifs du Cours
    Prérequis
  • Configuration de Votre Environnement
  • Installation de Streamlit
    Création d'un Compte Snowflake
    Connexion de Streamlit à Snowflake
  • Bases de Streamlit
  • Introduction aux Fonctionnalités de Streamlit
    Création de Votre Première Application Streamlit
    Compréhension de l'API de Mise en Page de Streamlit
  • Introduction à Snowflake
  • Architecture et Principales Fonctionnalités de Snowflake
    Opérations de Base avec Snowflake
    Chargement et Interrogation de Données dans Snowflake
  • Intégration de Streamlit et Snowflake
  • Création d'un Tableau de Bord de Données Interactif
    Récupération de Données en Temps Réel depuis Snowflake
    Affichage de Données Snowflake avec des Composants Streamlit
  • Fonctionnalités Avancées de Streamlit
  • Personnalisation des Applications Streamlit avec des Widgets
    Déploiement et Partage d'Applications Streamlit
    Techniques d'Optimisation des Performances
  • Techniques Avancées de Snowflake
  • Concepts de Stockage de Données Snowflake
    Utilisation des Extensions SQL de Snowflake
    Sécurité et Contrôle d'Accès dans Snowflake
  • Étude de Cas : Construction d'une Application de Données
  • Aperçu du Projet et Exigences
    Mise en Œuvre Pratique avec Streamlit et Snowflake
    Analyse et Visualisation de Données en Temps Réel
  • Bonnes Pratiques et Conseils
  • Bonnes Pratiques de Développement Streamlit
    Gestion Efficace des Données Snowflake
    Résolution des Problèmes Courants
  • Conclusion du Cours
  • Résumé des Apprentissages Clés
    Présentation du Projet Final
    Étapes Futures et Ressources Supplémentaires
  • Q&R et Remarques de Clôture

Enseigné par

Cristian Scutaru


Matières

Business