Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 11 hours on-demand video
  • 24 articles
  • 24 downloadable resources
  • 1 practice test
  • Full lifetime access
  • Access on mobile and TV
IT & Software IT Certification Microsoft Certification

DP-200: Implementing Azure Data Solution Exam Preparation

Pass DP-200: Learn Azure SQL Database,CosmosDB, Data warehouse, Data Lake, Data Factory, Data Bricks in 10 hours
Rating: 3.8 out of 53.8 (104 ratings)
469 students
Created by Step2C Education
Last updated 11/2020
English
30-Day Money-Back Guarantee

What you'll learn

  • You Will Master Azure Data Factory
  • How To Create Data Flows And Control Flows In Azure Data Factory
  • How To Use Parameters and Variables In Azure Data Factory
  • How To Implement Different Data Storage Solutions In Azure
  • implement a solution that uses Data Lake Storage Gen2
  • How To Create Azure SQL Databases
  • How To Configure Azure Data Bricks( A Service To Perform Big Data Analysis Using Azure Cloud)
  • How To Access Azure Data Lake From Azure DataBricks (With Python Code)
  • How To Connect To Azure SQL Data Base From On premise Using SSMS
  • How To Execute Query Against Azure SQL Data Base Using Azure Query Editor
  • How Migrate Data Base From On Premise To Azure Using SSMS
  • How To Move Data To Azure Data Lake From On-premise Using Storage Explore
  • How To Access On premise Environment Using Self Hosted Integration Run time From ADF
  • How To Create Data Set and Connections In ADF (Azure Data Factory)
  • How To Create Pipeline In Azure Data Factory (ADF)
  • How To Implement a solution that uses Azure Blob storage
  • Implement Storage Systems With High Availability, Disaster Recovery, And Global Distribution With Geo Replications
  • How To Create Elastic Pool And Deploy Multiple Data Bases In single Server
  • Provide Access To Data To Meet Security Requirements
  • How To Create Azure SQL Data Warehouse (Azure Synapse Analytics)
  • configure elastic pools, configure geo-replication, implement PolyBase
  • Learn to use PolyBase external tables to load data from Azure Data Lake Storage
  • Create database objects required to load from Data Lake Storage
  • Connect to a Data Lake Storage directory (With Credential and secret)
  • implement Copy Activity within Azure Data Factory, create linked services and datasets
  • Develop batch processing solutions using Data Factory and Azure Databricks
  • Create pipelines and activities, implement Mapping Data Flows in Azure Data Factory
  • Learn to implement Azure Databricks clusters creations
  • Learn to ingest data into Azure Databricks
  • Learn to implement Azure Databricks notebooks, jobs, and autoscaling,

Requirements

  • Internet connection to watch this videos
  • Laptop or PC to practice this LAB (Optional)
  • Headphone For Audio

Description

Microsoft Azure (formerly Windows Azure) is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through Microsoft-managed data centers.

Azure Provides Three services:

  1. software as a service (SaaS),

  2. platform as a service (PaaS).

  3. infrastructure as a service (IaaS)


Azure supports many different programming languages, tools, and frameworks, including both Microsoft-specific and third-party software and systems. Azure was announced in October 2008, started with the codename "Project Red Dog", and released on February 1, 2010, as "Windows Azure" before being renamed "Microsoft Azure" on March 25, 2014.

In this course, you will learn :

  1. How To Use The Azure Data Factory.

  2. How To Use The Azure SQL Database.

  3. How To Use Azure Blob Storage.

  4. How To Use Azure Data Lake.

  5. How To Use Azure DataBricks.

  6. How To Use Different Azure Data Services In Different applications.

Exam DP-200: Implementing an Azure Data Solution:

Candidates for this exam must be able to implement data solutions that use the following Azure services:

  • Azure Cosmos DB.

  • Azure SQL Database.

  • Azure Synapse Analytics (formerly Azure SQL DW).

  • Azure Data Lake Storage.

  • Azure Data Factory.

  • Azure Stream Analytics.

  • Azure Databricks.

  • Azure Blob storage.

Topics We Cover In This Course:

  • Azure SQL Database.

  • Azure Cosmos DB.

  • Azure Data Lake Storage.

  • Azure Data Factory.

  • Azure Databricks.

  • Azure Blob storage.

  • Azure Synapse Analytics (formerly Azure SQL DW).


Upcoming Modules;

  • Azure SQL failover groups

  • Azure Data Lake Analytics

  • Introduction To Power BI

  • HDinsight.


Candidates for Exam DP-200: Implementing an Azure Data Solution are Microsoft Azure data engineers who identify business requirements and implement proper data solutions that use Azure data services like Azure SQL Database, Azure Cosmos DB, Azure Data Factory, Azure Databricks, Azure data warehouse (Azure Synapse Analytics)

This course covers, how to provisioning data storage services like Azure SQL, Storage account, Data lakes. In the Azure Data factory section, we cover how to transform your data, identifying performance bottlenecks, and accessing external data sources including on-premise SQL server and file systems.


Azure Data Factory (ADF):

The Azure Data Factory service is a fully managed service for composing data storage, processing, and movement services into streamlined, scalable, and reliable data production pipelines. The Azure Data Factory (ADF) is a service designed to allow developers to integrate disparate data sources. ADF or Azure Data Factory is a platform somewhat like SSIS or Alteryx in the Azure environment to manage the data you have both on-prem and in the cloud.

It provides access to on-premises data with the help of a software. By using this link we could connect to the on-premise file system as well as to on-premise SQL databases. From Azure Data Factory, you could access almost all azure services without any difficulties.

Access to on-premises data is provided through a data management gateway that connects to on-premises SQL Server databases and we will show you how to install this software and how to connect your on-premises environment with Azure cloud.

If you ever created any data transfer activities in Azure, or in SSIS, you will find it a similar tool. If you use ADF, you could focus on your data—the serverless integration service does the rest.


Topics In Azure Data Factory:

  • Append Variable Activity

  • Execute Pipeline activity

  • ForEach activity

  • Get Metadata activity

  • If Condition activity

  • Lookup activity

  • Set variable activity

  • Until activity

  • Validation activity

  • Data Flow activity

  • Mapping data flow

    • Aggregate transformation.

    • Alter row transformation.

    • Conditional split transformation.

    • Derived column transformation.

    • Exists transformation.

    • Join transformation.

    • Lookup transformation.

    • The new branch mapping data flow transformation.

    • Select transformation.

    • Sink transformation.

    • Source transformation.

    • Azure Data Factory union transformation.

  • Parameterizing

  • Trigger In Azure Data Factory.

    • Manual Trigger.

    • Scheduled Trigger.

    • Tumbling window

    • Event Trigger.

      • Dynamic Data processing And Pipeline Execution Based on External Event.

  • and many more (with real-life scenarios). Check out our course descriptions for updated information.

SQL Database -Cloud Database as a Service:

Azure SQL Database is a fully managed relational database with built-in intelligence supporting self-driving features such as performance tuning and threat alerts. According to Wiki, Microsoft Azure SQL Database is a managed cloud database provided as part of Microsoft Azure. A cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. Managed database services take care of scalability, backup, and high availability of the database.

Azure SQL Database: Azure SQL Database is a relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server. It is a fully managed Platform as a Service (PaaS) Database Engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

In this course, we will show you how to launch the Azure SQL database in five minutes, with and without sample data.  We will show you, how to use SQL elastic pools.

Elastic pools help you manage and scale multiple Azure SQL databases. According to Azure documentation, SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. With an elastic pool, you determine the amount of resources that the elastic pool requires to handle the workload of its databases, and the amount of resources for each pooled database.

Azure SQL Database is always running on the latest stable version of the SQL Server Database Engine and patched OS with 99.99% availability.

The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price. By the end of this course, you will have a clear idea about how to configure SQL elastic pool.

Geo-Replication:

Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a SQL Database server in the same or different data center (region). We will show you how you could configure a Geo-replication and force failover to the secondary database manually.

Azure Cosmos DB:

Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. With a click of a button, Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure regions worldwide. In our course, we will see.

  • How you could create a cosmos DB account,

  • How to Create Databases inside your cosmosDB account

  • How to insert data into CosmsoDB containers.

  • How to Restive data that you saved in cosmos DB tables or containers by using SQL

Introduction to Azure Storage:

Azure Storage is Microsoft's cloud storage solution for modern data storage scenarios. Azure Storage offers a massively scalable object store for data objects, a file system service for the cloud, a messaging store for reliable messaging, and a NoSQL store.

In this course, we will cover how to create a storage account, how to create containers and file systems and how to upload data into these services and how to access these storage services from different azure data solutions services like data factory, data bricks, and SQL databases.

Azure Data Lake Storage:

Azure Data Lake Storage, is a fully-managed, elastic, scalable, and secure file system that supports HDFS semantics and works with the Hadoop ecosystem. ‎Azure Data Lake Storage Gen2 is a set of capabilities dedicated to big data analytics, built on Azure Blob storage. Data Lake Storage Gen2 is the result of converging the capabilities of our two existing storage services, Azure Blob storage and Azure Data Lake Storage Gen1.

In this course we will see, how to create data lakes, How to move CSV data from azure blob storage to azure data lake using azure data factory. How to read your data (Azure Data lake) using azure Databricks.

Azure Databricks:

Azure Databricks provides the latest versions of Apache Spark and allows you to seamlessly integrate with open source libraries. Spin up clusters and build Bigdata applications. According to Databricks documents, Azure Databricks is a fast, easy, and collaborative Apache Spark™ based analytics platform optimized for Azure. Azure Databricks supports Python, Scala, R, Java, and SQL, as well as data science frameworks and libraries including TensorFlow, PyTorch, and scikit-learn.

In this course, we will show you how to configure Azure Data bricks, How to launch a cluster, how to create notebooks.

Azure Synapse Analytics (Azure SQL Data Warehouse):

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. Azure Synapse is Azure SQL Data Warehouse evolved. In this course, you will learn how to create an Azure SQL pool, access a data lake storage account (how to use PolyBase external tables to load data from Azure Data Lake Storage). Will demonstrate how to create a master key and database scoped credential. How to create external tables and external data sources. Finally, we will see how to load data into Azure Data Warehouse from an external table by using the create table as a select command.

Demo 1:

  1. Create a Pipeline in Azure Data Factory.

  2. Create Input Connections to a source.

  3. Create Input Data Set.

  4. Create Output Connections to destinations.

  5. Create an Output Data set.

  6. Create A copy Activities to copy data from on-premise to Azure Blob storage.

  7. Create A copy Activities to copy data from Blob to Azure SQL Database.

  8. Create A copy Activities to copy data from on-premise to SQL Database.

  9. Run Your Copy Activities and validate all the settings

Demo-2:

  1. Migrate Data from On-premise SQL Server to Azure SQL database Without any external services.

Demo 3:

  1. Create An Azure DataBricks.

  2. Connect To Azure Data Lake.

  3. Create a Cluster To Run our notebook

  4. Configure Azure Databricks Data lake configurations.

  5. Assign permission to your external Applications.

  6. Read CSV data saved inside Azure Data lake using a Python notebook.

Demo 4:

  1. Create Your First Data Flow In Azure Data Factory.

  2. Configure The Source Data flow.

  3. Learn To use Filter Conditions.

  4. Learn To configure Sink (Destinations) in Azure.

  5. Run your Azure Data flow and copy data from Azure Blob Data Store And Save filtered result In Azure Data lake.

Demo 5:

  1. Access On-premise SQL Server.

  2. Create Different  Data Set by Executing Custom Stored Procedure By Passing Dynamic Parameter

  3. Save This Data Set Into Data Lake By Creating Custom Filename.

  4. Trigger this action Azure Data Factory.

Demo 6:

  1. Create dynamic result with help of custom parameters and in for each activity.

  2. Save the result into Azure Data lake with a dynamic name.

Demo 7;

Run your activities N times with the help of Until loop (Do loop concepts of programming language)

Demo 8:

  • Create an Azure Data warehouse Pool by using Azure Portal.

  • Create an Azure Data warehouse by using SQL statements from SSMS.

  • Connect and execute SQL statements against  Azure SQL Data warehouse.

  • Execute SQL statements against Data in Azure Data lake using PolyBase external tables And load data from Azure Data Lake Storage into Azure Data warehouse.

  • Learn to use external tables and external data sources in Azure SQL Data warehouse.



Who this course is for:

  • Any student Who Plan To Take DP 200 Certifications
  • Any Student Who Want To Implement Data Solutions In Azure Cloud

Course content

24 sections • 155 lectures • 11h 7m total length

  • Preview05:18
  • How To Use Azure Account -- After Free Trial ,Without Spending Money
    03:46
  • How To Use Udemy
    03:32

  • How to Claim your Virtual Training Day Exam Discount (100%) For Any Azure Exam
    00:26

  • Definition Of Cloud Computing
    00:19
  • What Is Cloud Computing ?
    01:33
  • Definition Of Scalability
    00:07
  • What is Scalability?
    02:44
  • Definition Of Elasticity
    00:32
  • What Is Elasticity?
    01:32
  • Definition Of Agility
    00:11
  • What is agility?
    01:27
  • Definition : Fault Tolerance
    00:13
  • What is Fault Tolerance
    02:06
  • Definition: Disaster Recovery
    00:38
  • What is Disaster Recovery?
    01:56
  • What Is High Availability ?
    01:44
  • Economies of Scale
    00:25
  • What is Economies of Scale?
    01:05
  • Capital Expenditure Vs Operational Expenditure
    00:07
  • Difference Between Capital Expenditure (Capex) Vs Operational Expenditure (Opex)
    01:30
  • IaaS Vs PaaS Vs SaaS
    05:56
  • Public Cloud Vs Private Cloud Vs Hybrid Cloud
    03:01

  • Sample Question & Answer Set 1
    07:29

  • Azure Data Factory
    00:33
  • Preview04:32
  • What Is RDBMS?
    11:22
  • What is Azure SQL Database?
    01:24
  • Preview08:44
  • What is Azure Storage Account ?
    00:16
  • Preview05:09
  • What is Azure Data Factory ?
    00:30
  • Preview03:03
  • Connect To Azure SQL Data Base From On-Premise Using SSMS & Create New Tables
    06:52
  • Azure Data Factory For The First Time
    03:10
  • Create Linked Service (Connection To Source & Destinations)
    07:25
  • Create Data Set
    03:26
  • Copy Data From Azure SQL To Storage Account
    05:02
  • Clean Your Azure Resources
    01:35

  • Check Your Knowledge
    4 questions

  • Introduction To RDBMS (What is Relational Data base management Systems & Use)
    03:49
  • Three Deployment Options Supported By Azure SQL DB
    03:20
  • Azure SQL Database: Deployment
    00:39
  • Single DB Deployment Vs Elastic Pool Deployment In Details
    02:40
  • Azure SQL Purchasing Models (DTU / V Core & Serverless )
    04:41
  • Demo: How To Create Azure SQL Databases?
    07:32
  • Demo: How To Connect To a Database From A SSMS (SQL server management studio)
    03:46

  • What is SQL Data Sync for Azure?
    01:26
  • Learn More About Azure SQL Data Sync
    01:02
  • Why We need AzCopy?
    01:24
  • How To Use AZCopy ?
    00:32
  • Azure Stream Analytics Related Questions
    01:08
  • Azure Stream Analytics
    01:08

  • Demo: How To Create A Storage Account In Azure
    05:52
  • Different Types Of Configuration In Azure Storage Account
    02:52
  • Data Replications In Azure Storage Account (What is Availability and Durability)
    09:08
  • Azure Storage Redundancy
    01:16

  • What Is Azure CosmosDB
    05:59
  • How To Create A CosmosDB Account
    04:05
  • How To Create Database and Containers In A CosmosDB account
    06:03
  • How To Insert Data Into CosmosDB And Retrieve Data From CosmosDB Using SQL
    08:50
  • How To Access Cosmos DB From .NET (Create DB & Containers , Insert/Update Items)
    14:33
  • Replication & Failover In CosmosDB
    03:18

Instructor

Step2C Education
50,000+ Enrollments | 4+ Rated | 190+ Countries
Step2C Education
  • 3.9 Instructor Rating
  • 1,328 Reviews
  • 58,188 Students
  • 17 Courses

This account is managed by Step2c Education. We create high-quality technology training content. We aim to teach technology the right way but at the same time putting emphasis on each of our students.

Our instructors have over 10 years of experience so our courses include their practical experience that can help students to learn and master cloud computing and ETL process.

We've been teaching for 10+ years. Now my focus is on Udemy. It's our mission to bring you the best training for cloud computing.

We have a team that includes a web developer, database developer, database architecture, data scientist, data visualization expert. software engineers, python developers.

For more information and for any one on one training please visit our website.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.