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

Data Engineering on Microsoft Azure: The Definitive Guide

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

Hands-On Introduction to Azure Data Services. Learn Data Factory, Synapse Analytics, SQL Database, and more


01 - Introduction - Understanding Core Data Concepts
  • 001 Introduction
  • 002 What is Data - A simple definition
  • 003 What is Structured Data
  • 004 What is Non Relational Data
  • 005 What is Data Ingestion
  • 006 What is Data Processing
  • 007 Batch Processing vs Stream Processing
  • 008 What is Data Analytics

  • 02 - Azure SQL - Introduction
  • 001 Create a Single Instance Database
  • 002 What is a Resource Group
  • 002 weblinks.pdf
  • 003 Azure Data Studio - Introduction
  • 003 weblinks.pdf
  • 004 Create a Virtual Machine
  • 005 Connect to Azure Database from an Azure Virtual Machine
  • 005 mssql-cli-guide.txt
  • 006 Authentication and Authorization
  • 007 Create a SQL Login and User
  • 007 azsql-createuser.zip
  • 008 SQL Server Management Studion - Introduction
  • 008 weblinks.pdf
  • 009 Understanding Tables and Views
  • 010 How to Create a Database Diagram in SSMS
  • 011 Azure Cost Management - How to Create a Budget in Azure

  • 03 - Azure Blob Storage - Introduction
  • 001 Introduction to Azure Storage
  • 002 Create an Azure Storage Account
  • 003 AzureStorage-WebResources.pdf
  • 003 Upload Data using the Azure Portal
  • 003 blobs.zip
  • 004 Upload Data using Azure Storage Explorer
  • 004 blobs.zip
  • 005 AzureStorage-WebResources.pdf
  • 005 Connect a Storage Account with a Shared Access Signature
  • 006 AzureStorage-WebResources.pdf
  • 006 Azure CLI - Generate a Shared Access Signature
  • 006 generate-sas-cli.txt
  • 007 AzureStorage-WebResources.pdf
  • 007 Understanding Data Redundancy
  • 008 AzureStorage-WebResources.pdf
  • 008 Azure Storage Account - Redundancy Options

  • 04 - Azure Data Factory - Core Concepts
  • 001 Section Intro
  • 002 Create Data Store and Target
  • 002 wideworldimporters-standard.zip
  • 003 Create Data Factory and Linked Services
  • 003 Section-ADF-Important-Links.pdf
  • 004 Create Datasets
  • 005 Create Pipeline and Activities
  • 006 Create Mapping Data Flow and Adding Sources
  • 007 Mapping Data Flow - Joining Sources
  • 008 Mapping Data Flow - Aggregate Data
  • 009 Mapping Data Flow Execution
  • 010 Mapping Data Flow and Apache Spark Execution

  • 05 - Practice Section Build an ETL Pipeline with Azure Data Factory
  • 001 Introduction
  • 002 Cost Warning - Data Pipeline Pricing
  • 003 BuildingEnd2EndPipelineResources.zip
  • 003 IMPORTANT Download Resources Before Starting.html
  • 004 Azure SQL - Contained Users
  • 005 Azure Key Vault - Store SQL Server Secrets
  • 006 Azure Key Vault - Linked Service
  • 007 Create Azure Storage Account
  • 008 Azure Managed Identity - Create a Linked Service To Azure Blob Storage
  • 009 Azure Role Based Access Control - Grant Access To Managed Identity
  • 010 Create a Dataset for the Lookup Activity
  • 011 Azure Data Factory - Lookup Activity
  • 012 Azure Data Factory - ForEach Activity And Pipeline Expressions
  • 013 Azure Data Factory - ForEach Activity - Part II
  • 014 Parameterize a Dataset Part I - Container Name
  • 015 Parameterize a Dataset Part II - Directory Name
  • 016 Parameterize a Dataset Part III - File Name
  • 017 Mapping Data Flow - JSON Source
  • 018 Mapping Data Flow - Parquet Source
  • 019 Mapping Data Flow - JOIN And Derived Column Transformations
  • 020 Mapping Data Flow - Aggregate Transformation
  • 021 Mappind Data Flow - Parameterized CSV File Sink
  • 022 Azure Data Factory - Store SAS In Azure Key Vault
  • 023 Azure Data Factory - Copy Activity Merge Behaviour
  • 024 Azure Data Factory - End To End Pipeline Execution
  • 025 Azure Data Factory - Storage Event Triggers

  • 06 - Azure Synapse Analytics - Serverless SQL pool
  • 001 IMPORTANT Download Resources Before Starting.html
  • 001 Section-6-Resources.zip
  • 002 Data Processing - OLAP vs OLTP
  • 003 Azure Synapse Analytics - Create a Synapse workspace
  • 004 Azure Synapse Analytics - Serverless SQL Pool Introduction
  • 005 Serverless SQL pool - Connect with Azure AD User And Azure Data Studio
  • 006 Serverless SQL pool - Server Level Credential
  • 007 Openrowset - Read Parquet Files
  • 008 Openrowset - Read CSV Files
  • 009 Openrowset - Read JSON - Line Delimited JSON
  • 010 Openrowset - Read JSON - Array of Objects
  • 011 Serverless SQL pool - Introduction to External Tables
  • 012 Serverless SQL pool - Create External Table - Part I
  • 013 Serverless SQL pool - Create External Table - Part II
  • 014 Serverless SQL pool - Create External Table III - How to Handle Dirty Records
  • 015 Serverless SQL pool - CETAS - Create External Table As Select

  • 07 - Azure Synapse Analytics - Serverless Apache Spark pool
  • 001 Apache Spark - Architecture
  • 001 Spark-Architecture.pdf
  • 001 useful-links.pdf
  • 002 Create a Serverless Apache Spark Pool
  • 003 Create and Run a Spark Notebooks
  • 003 synapse-intro-notebook.zip
  • 004 Scaling a Serverless Apache Spark Pool
  • 005 Azure Synapse Analytics - Workspace Quotas
  • 006 Working with Azure Data Lake Storage
  • 007 Working with Azure Blob Storage
  • 008 Working with Azure SQL
  • 009 Practice - Configure your favorite IDE tool.html

  • 08 - Azure Synapse Analytics - Dedicated SQL Pool
  • 001 Dedicated SQL pool - Introduction
  • 001 Dedicated-SQL-Pool-Uselful-Links.pdf
  • 001 notebooks.zip
  • 001 tpcds-onegb.zip
  • 002 Synapse - Create a dedicated SQL pool
  • 003 Load data - Copy Statement
  • 004 Load data - CREATE TABLE AS SELECT (CTAS)
  • 005 Star Schema - Architecture of a Data Warehouse
  • 006 Hash-distributed table
  • 007 Hash-distributed table - Choose the Distribution Column
  • 008 Round-robin distributed table
  • 009 Practice Create and Load Data into a Dedicated SQL Pool
  • 010 Workload Management - How to managed query performance.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 17513
    حجم: 4406 مگابایت
    مدت زمان: 715 دقیقه
    تاریخ انتشار: ۲۸ مرداد ۱۴۰۲
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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