Microsoft - Azure Academy: Data Platform

Duration

Duration:

Only 4 Days

Method

Method:

Classroom / Online / Hybrid

Next date

Next date:

6/2/2023 (Monday)

Overview

Get a deeper understanding of Azure Data Platform, Analytics and Internet of Things (IoT) in this Azure Academy programme. Firebrand has been working with Microsoft and partners to bring together three deep-dive Azure courses, which include more than 80% in-depth technical content not found in Microsoft Official Curriculum.

During the four days you'll be immersed in Azure, covering all current Data and Analytics components as well as taking a detailed look at Redis Cache and Azure Search. The course will focus on a core set of Azure features, so you have the time to learn the detail you need:

  • Implementing Azure SQL Database
  • Implementing an Azure SQL Data Warehouse
  • DocumentDB
  • Azure Redis Cache
  • Azure Search
  • Azure Data Factory Service
  • Azure Data Lake Store
  • Azure Data Catalog
  • Azure HDInsight
  • Azure Machine Learning
  • Azure BizTalk Service

Click the Curriculum tab to see a detailed break-down of the modules included. The other two Azure Academy deep-dive programmes are Azure Infrastructure and Networking and Azure Cloud Application Development.

Six reasons why you should sit your Azure Data Platform course with Firebrand Training

  1. You'll be Azure Data Platform trained in just 4 days.
  2. Our Azure Data Platform course is all-inclusive. A one-off fee covers all course materials, accommodation and meals. No hidden extras
  3. You’ll learn more Azure Data Platform. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  4. You’ll learn Azure Data Platform faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  5. You’ll be studying Azure Data Platform with the best. We’ve been named in Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified 134561 professionals, and we’re partners with all of the big names in the business
  6. You'll do more than study Azure Data Platform courseware. We use practical exercises to make sure you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging

Benefits

Seven reasons why you should sit your course with Firebrand Training

  1. Two options of training. Choose between residential classroom-based, or online courses
  2. You'll be certified fast. With us, you’ll be trained in record time
  3. Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
  4. Pass first time or train again for free. This is our guarantee. We’re confident you’ll pass your course first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  5. You’ll learn more. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  6. You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  7. You’ll be studying with the best. We’ve been named in Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 100,000 professionals
  • * For residential training only. Doesn't apply for online courses
  • ** Some exceptions apply. Please refer to the Exam Track or speak with our experts

Curriculum

Module 1 Implementing Azure SQL Database

  • Introduction to Relational Data in the Windows Azure Platform: In this topic you will learn the options for Relational Data in Windows Azure and learn the strengths about each model, looking at the differences between the benefits of VMs that host databases in Azure and Azure SQL Databases.
  • Deploying an Azure SQL Database: In this topic you will learn the performance tiers available for Azure SQL Databases and Provision and Connect to an Azure SQL Database.
  • Managing an Azure SQL Database: In this topic you will learn about the security model in Azure SQL Database, how to manage firewall rules, logins, users, roles and permissions. You will also learn about the tools you can use to manage and restore a database to a previous point in time.
  • Migrating an On-Premises Database to Azure SQL Database: In this topic you will learn the Azure SQL Database compatibility options and evaluate the migration options for moving an on-premises database to Azure SQL Database.

Module 2 Implementing an Azure SQL Data Warehouse

  • Advantages of Azure SQL Data Warehouse: In this topic you will learn the features of an Azure SQL Data Warehouse, understand the resource types and how they scale and their associated costs, the security and availability features, how to query unstructured data with PolyBase and find out what is possible in the hybrid cloud environment.
  • Implementing an Azure SQL Data Warehouse Database: In this topic you will learn how to implement an Azure SQL Data Warehouse database. As part of the process, you must also create a logical server for the database. To be able to connect to the database, you must configure the firewall settings of the server to allow the IP address of your computer
  • Developing an Azure SQL Data Warehouse: In this topic you will learn how to manage concurrency and memory allocation, types of data distribution, understand how to apply temporary tables and apply user defined schemas to organize your data.
  • Migrating to an Azure SQL Data Warehouse: In this topic, you will learn how to use the Microsoft Data Warehouse Migration Utility to migrate data. You will also see the table features and data types that are not supported in Azure SQL Data Warehouse, and learn how to check if a database contains any of these features.
  • Copying Data with the Azure Data Factory: In this topic you will be introduced to the Azure Data Factory and how you can use it to set up a scheduled activity to copy data from one table to another. You will see that the activities can reference data that is on-premises or in the cloud.

Module 3 DocumentDB

  • Introduction to DocumentDB: In this topic you will learn what DocumentDB is and what value it provides to modern applications. You will also see how data is managed and how you can access it.
  • Creating a DocumentDB Database: In this topic you will learn how to create a DocumentDB database using the Azure Portal, Azure Resource Manager templates or Azure command-line interface (CLI). You will also learn how to import, model, query, sort, and partition your data, customize indexes, choose a consistency level, and secure access to data.
  • Advanced DocumentDB: In this topic you will learn how to manage and monitor an account, manage performance levels, capacity and resource limits and requests.
  • DocumentDB and Other Services: In this topic you will learn how about common use cases for DocumentDB, deploying a website with DocumentDB, analysing data with Hadoop, integrating with Azure Search, and supporting multi-tenancy.

Module 4 Azure Redis Cache

  • Introduction to Azure Redis Cache: In this topic you will learn what Azure Redis Cache is and its key features and target scenarios.
  • Planning and Choosing a Cache Tier: In this topic you will learn the Redis Cache Tiers, performance benefits, Redis persistence using the RDB model, security and network isolation
  • Configure and Manage the Cache: In this topic you will learn how to automate creating and managing of Azure Redis Cache using PowerShell, Azure Command-Line Interface (CLI), monitoring and troubleshooting in the portal
  • How to use Azure Redis Cache: In this topic you will learn how to use Azure Redis Cache using .NET. ASP.NET, Node.js, Java and Python

Module 5 Azure Search

  • Introduction to Azure Search: In this topic you will learn what Azure Search is and its key features and target scenarios.
  • Managing and Scaling your Search Service: In this topic you will learn how to use the Azure Portal to manage and scale Azure Search and manage and configure API access.
  • Implementing Search Features, Such As Suggestions, Faceting, Hit Highlighting and Filtering: In this topic you will learn how to extend your data by enabling Full-Text Search, use the search features of Azure Search to improve user experience and navigation, and use the .NET SDK to leverage search features.
  • Tuning and Scoring your Search Index to Improve the User Search Experience: In this topic you will learn what is search index tuning and why it is important, different type of scoring function and integrating scoring into an Azure Search index.
  • Adding Geospatial Search to your Search Application: In this topic you will learn what is Geospatial Search, the types of spatial queries and how to add Geospatial search to your applications.

Module 6 Azure Data Factory Service

  • Introduction to Data Factory Concepts: In this topic you will learn what Azure Data Factory is and its key concepts.
  • Data Factory Operations: In this topic you will learn how to create datasets, understand data pipelines and activities to construct end-to-end data driven workflows, use the scheduling and execution aspects of Azure Data Factory application model, move data between stores.
  • Transform and Analyze Azure Data Factory: In this topic you will learn about data transformation activities in Azure Data Factory and how ADF transforms and processes raw data into predictions and insights using Hadoop, Azure Machine Learning, Stored Procedures, and Azure Data Lake Analytics.

Module 7 Azure Data Lake Store

  • Introduction to Data Lake Store: In this topic you will learn what Azure Data Lake Store is and its key concepts and capabilities making it easy for developers, data scientists and analysts to store data of any size, shape and speed, and do all types of processing and analytics across platforms and languages.
  • Create an Azure Data Lake Store: In this topic you will learn how to create an Azure Data Lake Store using the Azure Portal, PowerShell, .NET SDK, Java SDK, Visual Studio, and the Command-Line Interface (CLI), and how to enable diagnostic logs.
  • Data Lake Store Security: In this topic you will learn how Azure Data Lake Store provides industry-standard availability and reliability, redundant copies of data to guard against unexpected failures, Azure Active Directory for authentication and access control lists to manage access to data.
  • Data Lake Store and Other Services: In this topic you will learn how about common use cases for Azure Data Lake Store such as Hadoop clusters, Data Lake Analytics, Stream Analytics, Data Catalog and Power BI.

Module 8 Azure Data Catalog

  • Introduction to Azure Data Catalog: In this topic you will learn what Azure Data Catalog is and how users can discover the data sources they need enabling Analysts, Data Scientists and Developers to discover, understand and consume data sources.
  • How to create an Azure Data Catalog: In this topic you will learn the how to provision and setup an Azure Data Catalog, Register Data Assets, Manage Data Assets configuring security, Annotating Data Assets and Removing Data Assets.
  • Discover and Manage Data Sources: In this topic you will learn how to use the Azure Data Catalog portal to discover data assets and connect to data assets using client tools such as Excel, SQL Server Data Tools and SQL Server Management Studio.
  • Azure Data Catalog and Big Data: In this topic you will learn how Azure Data Catalog supports the registration of Azure Blob Storage blobs and directories, and Hadoop HDFS files and directories.

Module 9 Azure HDInsight

  • Introduction to Big Data: In this topic you will be introduced to Big Data and some of the most common technologies that are used to build Big Data Solutions
  • Microsoft Azure HDInsight: In this topic you will learn how to use Microsoft Azure HDInsight to process Big Data and consume the results in Microsoft Excel.
  • Managing HDInsight by using Microsoft Azure PowerShell: In this topic you will learn how to install and configure Microsoft Azure PowerShell, Manage files in HDFS and use PowerShell to run MapReduce jobs
  • Processing Big Data by using Pig: In this topic you will learn how to process data by using Pig and run Pig jobs in Windows PowerShell
  • Processing Big Data by using Hive: In this topic you will learn how to create Hive tables, load data into Hive tables, Query Hive tables, run Hive jobs in PowerShell, and use the Hive Open Database Connectivity (ODBC) Driver to query Hive table from Microsoft Excel
  • Automating Big Data Processing Tasks: In this topic you will learn techniques for creating and automating robust Big Data processing solutions by using Microsoft Azure HDInsight.
  • Integrating Microsoft Azure HDInsight with Enterprise Data: In this topic you will learn various options for integrating Microsoft Azure HDInsight into an enterprise BI infrastructure for reporting and analysis

Module 10 Azure Machine Learning

  • Introduction to Machine Learning and Azure ML Studio: In this topic you will learn about Azure Machine Learning and its strengths, an exploring the Azure Machine Learning Studio.
  • Create an Azure Machine Learning Workspace: In this topic you will learn how to use Storage Accounts and create an Azure Machine Learning Workspace
  • Designing a Predictive Analytics Solution with Azure ML: In this topic you will learn how to define the problem you want to solve, create an experiment adding transformation and filters, save and run the model, publish and use the model.

Module 11 Azure BizTalk Service

  • Introduction to Azure BizTalk Services: In this topic you will learn about Azure BizTalk Services and the supporting tools to build solutions to connect services and systems with disparate data formats and protocols
  • Create an Azure BizTalk Service: In this topic you will learn how to create a BizTalk service in the Azure Portal and register the deployment
  • Connect to an Azure BizTalk Service: In this topic you will learn how to connect to an on-premises Line-of-Business system
  • Manage and Monitor an Azure BizTalk Service: In this topic you will learn how to monitor health of a BizTalk Service, including performance metrics, manage artefacts and track messages, and create a backup plan

What's Included

Your accelerated course includes:

  • Accommodation *
  • Meals, unlimited snacks, beverages, tea and coffee *
  • On-site exams **
  • Exam vouchers **
  • Practice tests **
  • Certification Guarantee ***
  • Courseware
  • Up-to 12 hours of instructor-led training each day
  • 24-hour lab access
  • Digital courseware **
  • * For residential training only. Doesn't apply for online courses
  • ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
  • *** Pass first time or train again free (just pay for accommodation, exams and incidental costs)

Prerequisites

It is recommended that you have already gained the Microsoft MCSD: Azure Solutions Architect certification, or have the equivalent knowledge.

Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.

Reviews

Here's the Firebrand Training review section. Since 2001 we've trained exactly 134561 students and asked them all to review our Accelerated Learning. Currently, 96.55% have said Firebrand exceeded their expectations.

Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.


"Really enjoyed the course. The instructor was extremely knowledgeable and delivered the course in an engaging manor. The rooms were nice and clean and the other facilities and food were also very good."
Anonymous. (17/10/2022 (Monday) to 23/10/2022 (Sunday))

"was very good experience overall, well organized and very easy access to labs and test exams, nice helpful staff with excellent and capable teacher."
Muhannad Al Harthi, Oman environmental services holding company. (17/10/2022 (Monday) to 22/10/2022 (Saturday))

"The Instructor was great! Really clear."
Anonymous, Deloitte. (4/10/2022 (Tuesday) to 4/10/2022 (Tuesday))

"Was very interesting and helpful in readying me for the Azure Cloud fundamentals exam."
JD. (4/10/2022 (Tuesday) to 4/10/2022 (Tuesday))

"The Instructor was brilliant and so charismatic! She kept engagement high the whole day and made the learning fun on a jam packed-course!"
BS. (4/10/2022 (Tuesday) to 4/10/2022 (Tuesday))

Course Dates

Start

Finish

Status

Location

Book now

22/8/2022 (Monday)

25/8/2022 (Thursday)

Finished - Leave feedback

-

 

 

6/2/2023 (Monday)

9/2/2023 (Thursday)

Limited availability

Nationwide

 

20/3/2023 (Monday)

23/3/2023 (Thursday)

Open

Nationwide

 

1/5/2023 (Monday)

4/5/2023 (Thursday)

Open

Nationwide

 

12/6/2023 (Monday)

15/6/2023 (Thursday)

Open

Nationwide

 

Latest Reviews from our students