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.
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
Arrow right icon
Author (1):
Arrow left icon
Marcelo Leite Marcelo Leite
Author Profile Icon Marcelo Leite
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

Use cases

An RDBMS uses SQL as its default language. In general, use cases that can be applied to Azure SQL Database can also be applied to Azure Database for MySQL, PostgreSQL, and MariaDB, depending on which technology you want to use or what your application has already been developed on.

Therefore, instead of showing use cases of each of these technologies, in this section, I will present the reasons for opting for Azure SQL Database.

Important note

Whether you use a SQL or NoSQL database for a particular use case is one of the most important questions for a data architect. You will complete your knowledge in Chapter 9, Exploring Non-Relational Data Offerings in Azure, where we will discuss Azure NoSQL databases and list the main reasons for using a NoSQL database.

The big difference between a relational database and a non-relational database is the schema definition, which is defined at the beginning of the project on the relational database.

Before you start using...

lock icon The rest of the chapter is locked
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.
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
Renews at $19.99/month. Cancel anytime