Snowflake For Beginners

Published 2/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.23 GB | Duration: 6h 36m
Snowflake for Beginners

What you’ll learn
Snowflake Tutorial for Beginners
Snowflake Tutorial for Beginners
Snowflake Tutorial for Beginners
Snowflake Tutorial for Beginners
Requirements
Snowflake Tutorial for Beginners
Description
About Snowflake :Snowflake is a Cloud-based Data-Warehousing platform that offers advanced solutions for Organizational Data Storage, Processing and Analytical NeedsSnowflake is the Trending Platform used by thousands of Companies globallySnowflake Enables Most Critical Data Workloads in large CorporationsSection 1 : IntroductionIntroductionWhat is a data warehouse?Why cloud computing?The Snowflake StorySection 2 : Getting Started with SnowflakeSignup for SnowflakeUsing Snowflake UICreating our first Database, Schema & TableLoad Data into our first tableSetting up Required Snowflake toolsAssignment : Create, Load & query a tableSection 3 : Snowflake Warehouse for ComputeCreating our first Virtual WarehousesVirtual Warehouses sizes & ScalabilityWarehouse – Maximized vs Auto ScaleMulti-Cluster Warehouse Scaling Policy’sAssignment : Creating a new Virtual WarehouseSection 4 : Architecture, Features & PricingKey Concepts & ArchitectureSupported Cloud Platforms & RegionsSnowflake EditionsSnowflake ReleasesSnowflake PricingData IntegrationQuiz : Snowflake ConceptsSection 5 : Loading & Unloading Structured DataIngestion / Loading MethodsSteps to Managing LoadsPreparing your dataStaging your dataLoading data from an Internal stageLoading data from different Internal stagesLoading data from External S3 stagesWhat is Snowpipe?Loading data via Snowpipe – high level stepsSection 6 : Semi Structured DataLoading and Unloading JSON data – high level stepsAnalytics on JSON data – hands on labORC data handlingParquet data handlingAssignment : Load JSON data from an S3 bucketSection 7 : Stage data transformationsQuerying Data in Staged FilesQuerying Metadata for Staged FilesTransforming Data During a LoadSection 8 : Databases, Tables & ViewsWorking with Temporary, Transient & Permanent TablesWorking with Externals TablesOverview of ViewsWorking with Materialized ViewsTable Design Considerations
Overview
Section 1: Introduction
Lecture 1 Introduction to Snowflake
Lecture 2 Snowflake Session – 1
Lecture 3 Snowflake Session – 2
Lecture 4 Snowflake Session – 3
Lecture 5 Snowflake Session – 4
Snowflake Tutorial for Beginners

Homepage

https://www.udemy.com/course/snowflake-for-beginners/