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

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 دقیقه
    تاریخ انتشار: 28 مرداد 1402
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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