Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag United Kingdom
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Argentina
Country selected
country flag Austria
Country selected
country flag Belgium
Country selected
country flag Bulgaria
Country selected
country flag Chile
Country selected
country flag Colombia
Country selected
country flag Cyprus
Country selected
country flag Czechia
Country selected
country flag Denmark
Country selected
country flag Ecuador
Country selected
country flag Egypt
Country selected
country flag Estonia
Country selected
country flag Finland
Country selected
country flag Greece
Country selected
country flag Hungary
Country selected
country flag Indonesia
Country selected
country flag Ireland
Country selected
country flag Italy
Country selected
country flag Japan
Country selected
country flag Latvia
Country selected
country flag Lithuania
Country selected
country flag Luxembourg
Country selected
country flag Malaysia
Country selected
country flag Malta
Country selected
country flag Mexico
Country selected
country flag Netherlands
Country selected
country flag New Zealand
Country selected
country flag Norway
Country selected
country flag Philippines
Country selected
country flag Poland
Country selected
country flag Portugal
Country selected
country flag Romania
Country selected
country flag Singapore
Country selected
country flag Slovakia
Country selected
country flag Slovenia
Country selected
country flag South Africa
Country selected
country flag South Korea
Country selected
country flag Sweden
Country selected
country flag Switzerland
Country selected
country flag Taiwan
Country selected
country flag Thailand
Country selected
country flag Turkey
Country selected
country flag Ukraine
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Certified Azure Data Fundamentals (Exam DP-900) Certification Guide

You're reading from   Microsoft Certified Azure Data Fundamentals (Exam DP-900) Certification Guide The comprehensive guide to passing the DP-900 exam on your first attempt

Arrow left icon
Product type Paperback
Published in Nov 2022
Publisher Packt
ISBN-13 9781803240633
Length 300 pages
Edition 1st Edition
Languages
Tools
Concepts
Arrow right icon
Author (1):
Arrow left icon
Marcelo Leite Marcelo Leite
Author Profile Icon Marcelo Leite
Marcelo Leite
LinkedIn
Marcelo Leite is a data and artificial intelligence specialist at Microsoft. He got the DP-900 in October 2020 and holds the advanced titles of Azure Data Engineer and Azure AI Engineer. He graduated in technology with a database specialization and has MBA in project and IT management. Marcelo has been working at Microsoft for over 5 years. He's also a professor of MBA courses for databases, data architecture, and cloud computing. With 17+ years of experience in roles such as software engineer, consulting manager, and solutions sales specialist, he shares his knowledge of data technologies on his YouTube channel "Dicas de Dados" and is very active on LinkedIn.
Read more
See other products by Marcelo Leite
Arrow right icon
View More author details
Toc

Table of Contents (21) Chapters Close

Preface 1. Part 1: Core Data Concepts
2. Chapter 1: Understanding the Core Data Terminologies FREE CHAPTER 3. Chapter 2: Exploring the Roles and Responsibilities in Data Domain 4. Chapter 3: Working with Relational Data 5. Chapter 4: Working with Non-Relational Data 6. Chapter 5: Exploring Data Analytics Concepts 7. Part 2: Relational Data in Azure
8. Chapter 6: Integrating Relational Data on Azure 9. Chapter 7: Provisioning and Configuring Relational Database Services in Azure 10. Chapter 8: Querying Relational Data in Azure 11. Part 3: Non-Relational Data in Azure
12. Chapter 9: Exploring Non-Relational Data Offerings in Azure 13. Chapter 10: Provisioning and Configuring Non-Relational Data Services in Azure 14. Part 4: Analytics Workload on Azure
15. Chapter 11: Components of a Modern Data Warehouse 16. Chapter 12: Provisioning and Configuring Large-Scale Data Analytics in Azure 17. Chapter 13: Working with Power BI 18. Chapter 14: DP-900 Mock Exam 19. Index 20. Other Books You May Enjoy

Summary

As we have observed, SQL commands are simple and intuitive but very scalable. Based on this, relational databases are the most used database format on the market.

In this chapter, we learned about the fundamentals of relational databases, table normalization, and the basics of SQL.

In the next chapter, we will address non-relational databases, considering so-called NoSQL (Not Only SQL).

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 7 of 8
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $19.99/month. Cancel anytime

Authors (1)

Profile icon Marcelo Leite
Marcelo Leite
LinkedIn icon Github icon
Marcelo Leite is a data and artificial intelligence specialist at Microsoft. He got the DP-900 in October 2020 and holds the advanced titles of Azure Data Engineer and Azure AI Engineer. He graduated in technology with a database specialization and has MBA in project and IT management. Marcelo has been working at Microsoft for over 5 years. He's also a professor of MBA courses for databases, data architecture, and cloud computing. With 17+ years of experience in roles such as software engineer, consulting manager, and solutions sales specialist, he shares his knowledge of data technologies on his YouTube channel "Dicas de Dados" and is very active on LinkedIn.
Read more
See other products by Marcelo Leite

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.
Read more
May 2024 27h 32m
Right arrow icon