Getting started with Microsoft Azure Data Fundamentals in 30 Minutes Brian Wu NetCom Learning
© 1998-2021 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
AGENDA
Basic understanding of core data concepts in Azure Explain concepts of relational data in Azure Explore the concepts of non-relational data in Azure Identify components of a modern data warehouse in Azure Q&A with the speaker
© 1998-2021 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
CORE DATA CONCEPTS IN AZURE • Collection of facts, numbers, descriptions, objects , stored in a structured, semi-structured, unstructured way Structured
Semi-structured
Unstructured
Table
© 1998-2021 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
TRANSACTIONAL VS ANALYTICAL DATA STORES Online Transactional Processing (OLTP)
Online Analytical Processing (OLAP)
Customer CustomerID
CustomerName
CustomerPhone
Orders OrderID
CustomerID
© 1998-2021 NetCom Learning
OrderDate
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
RELATIONAL DATA IN AZURE Customers
Orders
CustomerID
CustomerName
CustomerPhone
OrderID
CustomerID
SalesPersonID
100
Muisto Linna
XXX-XXX-XXXX
AD100
101
200
101
Noam Maoz
XXX-XXX-XXXX
AD101
101
200
102
Vanja Matkovic
XXX-XXX-XXXX
AD102
101
200
103
Qamar Mounir
XXX-XXX-XXXX
AX103
103
201
104
Zhenis Omar
XXX-XXX-XXXX
AS104
103
201
105
Claude Paulet
XXX-XXX-XXXX
AR105
105
200
106
Alex Pettersen
XXX-XXX-XXXX
MK106
105
201
In a normalized database schema: Primary Keys and Foreign keys are used to define relationships
© 1998-2021 NetCom Learning
No data duplication exists (other than key values in 3rd Normal Form (3NF)
Data is retrieved by joining tables together in a query
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
RELATIONAL DIAGRAM EXAMPLE
© 1998-2021 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
TRANSACTIONAL VS ANALYTICAL DATA STORES Online Transactional Processing (OLTP)
Online Analytical Processing (OLAP)
Customer CustomerID
CustomerName
CustomerPhone
Orders OrderID
CustomerID
© 1998-2021 NetCom Learning
OrderDate
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
COLUMNAR STORAGE
© 1998-2021 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
WHAT IS NOSQL?
Key-value stores
© 1998-2021 NetCom Learning
Document based
Column family databases
www.netcomlearning.com
• Graph Database s
| info@netcomlearning.com | 1-888-563-8266
EXPLORE CHARACTERISTICS OF NON-RELATIONAL DATA Entities ## Customer 1 ID: 1 Name: Mark Hanson Telephone: [ Home: 1-999-9999999, Business: 1-888-8888888, Cell: 1-777- 7777777 ] Address: [ Home: 121 Main Street, Some City, NY, 10110, Business: 87 Big Building, Some City, NY, 10111 ] ## Customer 2 ID: 2 Title: Mr Name: Jeff Hay Telephone: [ Home: 0044-1999-333333, Mobile: 0044-17545-444444 ] Address: [ UK: 86 High Street, Some Town, A County, GL8888, UK, US: 777 7th Street, Another City, CA, 90111 ]
Non-relational collections can have: Multiple entities in the same collection or container with different fields
© 1998-2021 NetCom Learning
Have a different, non-tabular schema
Are often defined by labeling each field with the name it represents
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
IDENTIFY NON-RELATIONAL DATABASE USE CASES IoT and Telematics: Often require to ingest large amounts of data in frequent burst of activity, data is either semi structured or structured, often requires real time processing
Retail and Marketing: Common scenarios for globally distributed data, document storage
Gaming: In-game stats, social media integration, leaderboards, low-latency applications
Web and Mobile: Commonly used with web click analytics, modern applications including bots
© 1998-2021 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com | 1-888-563-8266
AZURE SERVICES FOR THE MODERN DATA WAREHOUSE
Azure Data Factory
© 1998-2021 NetCom Learning
Azure Data Lake
Azure Databricks
Azure HDInsight
www.netcomlearning.com
Azure Synapse Analytics
| info@netcomlearning.com | 1-888-563-8266
RECORDED WEBINAR VIDEO To watch the recorded webinar video for live demos, please access the link: https://bit.ly/3leJDAo
© 1998-2021 NetCom Learning
www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
ABOUT NETCOM LEARNING
100K+
14K+
3500
Professionals trained
Corporate clients
IT, Business & Soft Skills courses
96%
8.6/9
20+
Of customers recommend us to others
Instructor evaluations
Leadingvendors recognitions
Microsoft’s
80%
Top 20
Worldwide training partner of the year
Trained of the Fortune 100
ITTraining Company
© 1998-2019 1998-2021NetCom NetCom Learning Learning
NetCom Learning is an award-winning global leader in managed learning services, training and talent development.
www.netcomlearning.com www.netcomlearning.com
Founded
: 1998
Headquarters
: New YorkCity
Delivery Capability
: Worldwide
CEO
: RussellSarder
|| info@netcomlearning.com || 1-888-563-8266
RECOMMENDED COURSES AND MARKETING ASSETS NetCom Learning offers a comprehensive portfolio for Cloud » AI-900T00: MICROSOFT AZURE AI FUNDAMENTALS– class scheduled at 18th Oct » DA-100T00: ANALYZING DATA WITH POWER BI– class scheduled at 19th Oct » AZ-900T00: MICROSOFT AZURE FUNDAMENTALS (2 DAY) – class scheduled at 21th Oct » DP-100T01: DESIGNING AND IMPLEMENTING A DATA SCIENCE SOLUTION ON AZURE (DATA SCIENTIST) – class scheduled at 1ST Nov » DP-900T00: MICROSOFT AZURE DATA FUNDAMENTALS– class scheduled at 8th Nov » DP-203T00: Data Engineering On Microsoft Azure Associate Certification Prep Session You can also access the below Marketing Assets » Free 2Hr Training - Microsoft Azure Administrator Master Class » Free 2Hr Training - Microsoft Azure Master Class » Free On-Demand Training - Master Microsoft Power Apps in 30 Minutes » Blog - Master Cloud Basics with Microsoft Azure Fundamentals Certifications
© 1998-2021 NetCom Learning
www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
UPCOMING WEBINARS • Microsoft Azure Administrator Master Class is a complimentary 3.5 Hour Instructorled Virtual session • Managing Cisco Secure Workload to Protect your Cloud-Native Applications • Architecting on AWS: Master Best Practices in 30 Minutes • AWS Discovery Day - An official introduction to the core concepts of cloud and AWS • How to Deploy Microsoft 365 Apps and Workloads • An Introduction to ITIL®4: Create, Deliver & Support • How to Manage your Projects with Disciplined Agile (DA) • CND First Look by NetCom Learning - Network Defender Free Course • AWS Discovery Day - An official introduction to the core concepts of cloud and AWS • AWS Migration Master Class - Live complimentary 2.5 Hours Instructor-led Virtual session • Tableau: Getting started with Mapping in 30 Minutes
& More © 1998-2019 1998-2021NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
PROMOTIONS
NetCom Unlimited is a limitless 12 month subscription program Attend over 500+ courses as from a range of authorized training courses. Get access to bundled offerings of Virtual Instructor-Led courses, e-Learning, Discovery Days, and On-Demand training via NetCom Unlimited training subscription. Learn More.
© 1998-2019 1998-2021NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
PROMOTIONS
Access Your Passport To A Year Full Of Learning! The NetCom Learning Passport is a flexible pre-pay training package allowing you to plan and manage your teams’ annual training needs. With our Learning Passport, organizations get special pricing and extended program options to simplify management. Equipped with this Passport, you make the most of your budget. It has been specifically designed to specialize for the number of learners you plan to train.. Unlock Now
© 1998-2019 1998-2021NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
PROMOTIONS
Worry-Free Training with Price Match Guarantee Our Price Match Guarantee ensures that we'll match the offers of any other authorized training provider if you succeed at finding anyone offering the same publicly scheduled class within 30 days of our schedule at a lower regular price. Learn More
© 1998-2019 1998-2021NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
FOLLOW US ON
© 1998-2019 1998-2021NetCom NetCom Learning Learning
YouTube
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
BUILDING AN INNOVATIVE LEARNING ORG.
A BOOK FROM RUSSELL SARDER,
CEO AT NETCOM LEARNING
A framework to build a smarter workforce, adapt to change and drive growth.
DOWNLOAD e-book
© 1998-2019 1998-2021NetCom NetCom Learning Learning
www.netcomlearning.com www.netcomlearning.com
|| info@netcomlearning.com || 1-888-563-8266
Thank you
© 1998-2019 NetCom Learning
www.netcomlearning.com
| info@netcomlearning.com
| 1-888-563-8266|