وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Snowflake – The Complete Masterclass (2023 Edition)

سرفصل های دوره

Master Snowflake & cloud data warehouse from the ground up


01 - Introduction
  • 001 Welcome!
  • 002 Course Outline
  • 003 How to benefit best from the course
  • 004 AllCourseSlides.pdf
  • 004 All course slides & resources.html
  • 004 All-resources.zip

  • 02 - Getting started
  • 001 Sign up for free trial
  • 002 Login to account
  • 003 Create-a-database.txt
  • 003 Getting to know the interface
  • 004 Snowflake architecture
  • 005 Setting up warehouse
  • 006 Setting up warehouse using SQL
  • 007 Scaling policy
  • 008 Exploring tables & databases
  • 009 Loading data in snowflake
  • 009 Loading-data.txt

  • 03 - Snowflake architecture
  • 001 What is a data warehouse
  • 002 Cloud computing
  • 003 Snowflake editions
  • 004 Snowflake pricing
  • 005 Monitor Usage
  • 006 Roles in snowflake

  • 04 - Loading data
  • 001 Loading methods
  • 002 Understanding stages
  • 003 Create-Stage.txt
  • 003 Creating stage
  • 004 COPY command
  • 004 COPY-Command.txt
  • 005 Transforming data
  • 005 Transforming-data.txt
  • 006 More transformations
  • 006 More-transformations.txt
  • 007 Copy option ON ERROR
  • 007 Copy-options-ON-ERROR.txt
  • 008 FileFormat.xlsx
  • 008 File format object
  • 008 File-Format.txt
  • 009 Summary

  • 05 - Copy options
  • 001 Understanding copy options
  • 002 VALIDATION MODE
  • 002 VALIDATION-MODE.txt
  • 003 Rejected-records.txt
  • 003 Working with rejected records
  • 004 SIZE LIMIT
  • 004 SIZE-LIMIT.txt
  • 005 RETURN FAILED ONLY
  • 005 RETURN-FAILED-ONLY.txt
  • 006 TRUCATECOLUMNS.txt
  • 006 TRUNCATECOLUMNS
  • 007 FORCE
  • 007 FORCE.txt
  • 008 Load history
  • 008 Load-history.txt

  • 06 - Loading unstructured data
  • 001 High-level steps
  • 002 Our data
  • 002 hr-data.zip
  • 003 Create-Stage-Load-raw-JSON-1.txt
  • 003 Creating stage & raw file
  • 004 Parse-Analyze-JSON-2.txt
  • 004 Parsing JSON
  • 005 Handling nested data
  • 005 Handling-nested-data-JSON-3.txt
  • 006 Dealing with hierarchy
  • 006 Dealing-with-hierarchy-JSON-4.txt
  • 007 Insert final data
  • 007 Insert-the-final-data-JSON-5.txt
  • 008 Parquet-data-1.txt
  • 008 Querying PARQUET data
  • 008 daily-sales-items-top105.zip
  • 009 Loading PARQUET data
  • 009 Parquet-data-2.txt
  • 009 daily-sales-items-top105.zip

  • 07 - Performance optimization
  • 001 Performance in Snowflake
  • 002 Create dedicated virtual warehouse
  • 003 Dedicated-VW.txt
  • 003 Implement dedicated virtual warehouse
  • 004 Scaling up
  • 005 Scaling out
  • 005 Scaling-Out.txt
  • 006 Caching - Theory
  • 007 Caching.txt
  • 007 Maximize Caching
  • 008 Clustering - Theory
  • 009 Clustering.txt
  • 009 Clustering - Practice

  • 08 - Loading from AWS
  • 001 Sign up for free trial
  • 002 Creating S3 bucket
  • 003 Upload files in S3
  • 003 musical-instruments-5.zip
  • 003 netflix-titles.csv
  • 004 Creating policy
  • 005 Create-Storage-integration.txt
  • 005 Creating integration object
  • 006 Loading from S3
  • 006 Load-data-from-S3.txt
  • 007 Handle JSON
  • 007 Handling-JSON.txt

  • 09 - Loading from Azure
  • 001 Sign up for free trial
  • 002 Create a storage account
  • 003 Create a container
  • 003 carmodels.zip
  • 003 world-happiness-report-2021.csv
  • 004 Create integration object
  • 004 Create-Integration.txt
  • 005 Create stage object
  • 005 Create-Stage.txt
  • 006 Load CSV file
  • 006 Load-CSV.txt
  • 007 Load JSON file
  • 007 Load-JSON.txt

  • 10 - Loading from GCP
  • 001 Sign up for free trial
  • 002 Create a bucket
  • 002 carmodels.zip
  • 002 world-happiness-report-2021.csv
  • 003 Create integration object
  • 003 Create-integration-object.txt
  • 004 Create stage
  • 004 Create-stage.txt
  • 005 Query & load data
  • 005 Query-Load-data.txt
  • 006 Unload data
  • 006 Unload-data.txt

  • 11 - Snowpipe
  • 001 What is Snowpipe
  • 002 High-level steps
  • 003 Creating stage
  • 003 Setting-up-stage-and-pipe.txt
  • 003 employee-data-1.csv
  • 004 Create-pipe.txt
  • 004 Creating pipe
  • 005 Configure pipe & notifications
  • 005 employee-data-2.csv
  • 006 Error handling
  • 006 Error-handling.txt
  • 006 employee-data-3.csv
  • 006 employee-data-4.csv
  • 007 Manage pipes
  • 007 Manage-pipes.txt

  • 12 - Snowpipe for Azure
  • 001 High-level steps
  • 002 Create stage & storage integration
  • 002 Create-Stage-and-integration.txt
  • 003 Create notification integration
  • 003 Create-notification-Integration.txt
  • 004 Create pipe and load data
  • 004 Create-Pipe.txt
  • 004 word-happiness-report-2021.csv

  • 13 - Time Travel
  • 001 Using time travel
  • 001 Using-time-travel.txt
  • 002 Restoring data
  • 002 Restoring-in-time-travel.txt
  • 003 UNDROP tables
  • 003 Undrop.txt
  • 004 Retention time
  • 005 Time travel cost
  • 005 Time-travel-cost.txt

  • 14 - Fail Safe
  • 001 Understanding Fail Safe
  • 002 Fail Safe storage
  • 002 Fail-Safe-Storage.txt

  • 15 - Types of tables
  • 001 Different table types
  • 002 Permanent tables & databases
  • 002 Permanent-tables.txt
  • 003 Transient tables & databases
  • 003 Transient-tables.txt
  • 004 Temporary tables & databases
  • 004 Temporary-tables.txt

  • 16 - Zero-Copy Cloning
  • 001 Understanding Zero-Copy Cloning
  • 002 Cloning tables
  • 002 Cloning-tables.txt
  • 003 Cloning schemas & databases
  • 003 Cloning-Schemas-Databases.txt
  • 004 Cloning with time travel
  • 004 Cloning-using-time-travel.txt
  • 005 Swapping tables

  • 17 - Data Sharing
  • 001 Understanding data sharing
  • 002 Using data sharing
  • 002 Using-data-sharing.txt
  • 003 Create share through the interface
  • 004 Sharing with non-snowflake users
  • 005 Create-reader-account.txt
  • 005 Creating a reader account
  • 006 Creating a database from share
  • 007 Set up users for share
  • 008 Share-entire-DB-or-schema.txt
  • 008 Sharing database & schema
  • 009 Secure vs. normal view
  • 009 Secure-view.txt
  • 010 Sharing a secure view
  • 010 Sharing-views.txt

  • 18 - Data Sampling
  • 001 Why data sampling
  • 002 Methods of data sampling
  • 003 Data-Sampling.txt
  • 003 Sampling data Hands-on

  • 19 - Scheduling Tasks
  • 001 Understanding tasks
  • 002 Creating tasks
  • 002 Creating-Tasks.txt
  • 003 Using CRON
  • 003 Using-CRON.txt
  • 004 Understand tree of tasks
  • 005 Creating trees of tasks
  • 005 Creating-tree-of-tasks.txt
  • 006 Calling a stored procedure
  • 006 Task-with-stored-procedure.txt
  • 007 Task history & error handling
  • 007 Task-history.txt
  • 008 Tasks with condition

  • 20 - Streams
  • 001 Understanding streams
  • 002 INSERT operation
  • 002 Insert.txt
  • 003 UPDATE operation
  • 003 Update.txt
  • 004 DELETE operation
  • 004 Delete.txt
  • 005 Process all data changes
  • 005 Process-all-data-changes.txt
  • 006 Combine streams & tasks
  • 006 Streams-tasks.txt
  • 007 Types of streams
  • 007 Types-of-stream.txt
  • 008 Changes clause
  • 008 Change-clause.txt

  • 21 - Materialized Views
  • 001 Understand materialized views
  • 002 Create-materialized-view.txt
  • 002 Using materialized views
  • 003 Refresh materialized views
  • 003 Refresh-in-materialized-views.txt
  • 004 Maintenance costs
  • 004 Maintenance-costs.txt
  • 005 When to use materialized views
  • 006 Limitations

  • 22 - Dynamic Data Masking
  • 001 Understanding data masking
  • 002 Create-masking-policy.txt
  • 002 Creating a masking policy
  • 003 Unset & replace policy
  • 003 Unset-replace-policy.txt
  • 004 Alter an existing policy
  • 004 Alter-existing-policies.txt
  • 005 Real life examples
  • 005 Real-life-examples.txt

  • 23 - Access Management
  • 001 Key concepts
  • 002 Roles overview
  • 003 ACCOUNTADMIN
  • 004 ACCOUNTADMIN.txt
  • 004 ACCOUNTADMIN in practice
  • 005 SECURITYADMIN
  • 006 SECURITYADMIN.txt
  • 006 SECURITYADMIN in practice
  • 007 SYSADMIN
  • 007 SYSADMIN.txt
  • 008 SYSADMIN.txt
  • 008 SYSADMIN in practice
  • 009 Custom roles
  • 010 Custom roles in practice
  • 010 Custom-roles.txt
  • 011 USERADMIN
  • 012 USERADMIN.txt
  • 012 USERADMIN in practice
  • 013 PUBLIC

  • 24 - Visualization - Power BI & Tableau
  • 001 Data Visualization
  • 002 Download & install Power BI
  • 003 Connect Power BI & Snowflake
  • 004 Working in Power BI
  • 005 Download & install Tableau
  • 006 Connect Tableau & Snowflake

  • 25 - Partner Connect - Connecting other tools
  • 001 Connecting to other tools
  • 002 Connect to ETL tool

  • 26 - Best Practises
  • 001 Best practices
  • 002 Virtual warehouses
  • 003 Table design
  • 004 Monitoring
  • 004 Monitoring-Resources.txt
  • 005 Retention period

  • 27 - Bonus
  • 001 Bonus lecture.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 19488
    حجم: 4736 مگابایت
    مدت زمان: 840 دقیقه
    تاریخ انتشار: ۱۳ مهر ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید