E-Book, Englisch, 300 Seiten
Leite Microsoft Certified Azure Data Fundamentals (Exam DP-900) Certification Guide
1. Auflage 2024
ISBN: 978-1-80323-509-7
Verlag: De Gruyter
Format: EPUB
Kopierschutz: 0 - No protection
The comprehensive guide to passing the DP-900 exam on your first attempt
E-Book, Englisch, 300 Seiten
ISBN: 978-1-80323-509-7
Verlag: De Gruyter
Format: EPUB
Kopierschutz: 0 - No protection
Passing the DP-900 Microsoft Azure Data Fundamentals exam opens the door to a myriad of opportunities for working with data services in the cloud. But it is not an easy exam and you'll need a guide to set you up for success and prepare you for a career in Microsoft Azure.
Absolutely everything you need to pass the DP-900 exam is covered in this concise handbook. After an introductory chapter covering the core terms and concepts, you'll go through the various roles related to working with data in the cloud and learn the similarities and differences between relational and non-relational databases. This foundational knowledge is crucial, as you'll learn how to provision and deploy Azure's relational and non-relational services in detail later in the book. You'll also gain an understanding of how to glean insights with data analytics at both small and large scales, and how to visualize your insights with Power BI. Once you reach the end of the book, you'll be able to test your knowledge with practice tests with detailed explanations of the correct answers.
By the end of this book, you will be armed with the knowledge and confidence to not only pass the DP-900 exam but also have a solid foundation from which to embark on a career in Azure data services.
Autoren/Hrsg.
Fachgebiete
Weitere Infos & Material
Table of Contents - Understanding the Core Data Terminologies
- Exploring the Roles and Responsibilities in Data Domain
- Working with Relational Data
- Working with Non-Relational Data
- Exploring Data Analytics Concepts
- Integrating Relational Data on Azure
- Provisioning and Configuring Relational Database Services in Azure
- Querying Relational Data in Azure
- Exploring Non-Relational Data Offerings in Azure
- Provisioning and Configuring Non-Relational Data Services in Azure
- Components of a Modern Data Warehouse
- Provisioning and Configuring Large-Scale Data Analytics in Azure
- Working with Power BI
- DP-900 Mock Exam
Preface
Today, the world’s leading companies are data-driven, and a good strategy for using data is one of the key success factors for organizations worldwide. Following this trend, there is a growing demand for professionals trained to work with this data, orchestrating, processing, and generating intelligence from it.
will introduce you to the fundamental knowledge required to ensure successful data projects in Azure, preparing you for the DP-900 certification test.
Going through basic concepts of data as well as hands-on exercises with Azure data services, this book will teach you about the different technologies offered in Azure and when to use each one.
The book is structured in four parts. The first covers core data concepts, the second relational data in Azure, the third covers non-relational data in Azure and the fourth part covers analytics workloads on Azure, ending with a mockup of the DP-900 test evaluating the knowledge acquired.
Who this book is for
This book is for data engineers, database administrators, or aspiring data professionals getting ready to take the DP-900 exam. It will also be helpful for those looking for a bit of guidance on how to be better equipped for Azure-related job roles such as Azure database administrator or Azure data engineer. A basic understanding of core data concepts and relational and non-relational data will help you make the most out of this book, but they're not a pre-requisite.
What this book covers
, , is all about creating a knowledge foundation around data types, transactional databases, analytical databases, data ingestion, and data stores.
, , continues your introduction to the different job roles associated with creating, managing, and using databases. You will learn about the key responsibilities of these roles and the tools that these roles use on the Azure and Microsoft cloud portfolios.
, , explores the relational model for databases, how tables are structured, how you can use indexes to improve query performance, and how you can use views to simplify complex queries.
, , explores non-relational databases and how they compare to relational databases. You will learn about the different types of non-relational databases commonly used by applications.
, , covers how to generate insights by processing data into a data analytics system, enabling the business to carry out data-driven operations.
, , covers the Azure data services for relational databases, including Azure SQL Database, Azure Database for PostgreSQL, Azure Database for MySQL, and Azure Database for MariaDB. You will explore scenarios for using these database management systems.
, , teaches you how to provision and configure Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL.
, , explores Structured Query Language (SQL) and how you can use it to query, insert, update, and delete data in Azure SQL Database.
, , explores Azure data services for non-relational data, including Azure Table storage, Azure Blob Storage, Azure Files, and Azure Cosmos DB, as well as situations for using them.
, , looks at how to provision and configure Azure Cosmos DB and Azure Data Lake Storage.
, , examines the components of a modern data warehouse. You will understand the role of services such as Azure Databricks, Azure Synapse Analytics, and Azure HDInsight. You will also see how to use Azure Synapse Analytics to load and process data.
, , explores data ingestion options to build a data warehouse with Azure, services to perform data analytics, and features of Azure Synapse Analytics. You will create a Synapse Analytics workspace and use it to ingest and analyze data.
, , is where you will learn what Power BI is, including its building blocks and how they work together.
, , provides practice tests to prepare you for the DP-900 exam.
To get the most out of this book
You will need a computer with Windows or macOS with internet access to download the Azure Data Studio and Power Bi Desktop software, as well as access to the Azure portal and the Azure service websites. All code examples have been tested using Azure Data Studio on the Windows 11 operating system. However, they should work with macOS, Linux, and future version releases too.
Power BI Desktop and the mobile app can be downloaded from here:
https://powerbi.microsoft.com/en-us/downloads/
Azure Data Studio can be downloaded from here:
https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio
If you are using the digital version of this book, we advise you to type the code yourself or access the code from the book’s GitHub repository (a link is available in the next section). Doing so will help you avoid any potential errors related to the copying and pasting of code.
Download the example code files
You can download the example code files for this book from GitHub at https://github.com/PacktPublishing/Microsoft-Certified-Azure-Data-Fundamentals-Exam-DP-900-Certification-Guide. If there’s an update to the code, it will be updated in the GitHub repository.
We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!
Download the color images
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here: https://packt.link/LTQeN.
Conventions used
There are a number of text conventions used throughout this book.
Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: “Mount the downloaded WebStorm-10*.dmg disk image file as another disk in your system.”
A block of code is set as follows:
html, body, #map { height: 100%; margin: 0; padding: 0 }Bold: Indicates a new term, an important word, or words that you see onscreen. For instance, words in menus or dialog boxes appear in bold. Here is an example: “Select System info from the Administration panel.”
Tips or important notes
Appear like this.
Get in touch
Feedback from our readers is always welcome.
General feedback: If you have questions about any aspect of this book, email us at customercare@packtpub.com and mention the book title in the subject of your message.
Errata: Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you have found a mistake in this book, we would be grateful if you would report this to us. Please visit www.packtpub.com/support/errata and fill in the form.
Piracy: If you come across any illegal copies of our works in any form on the internet, we would be grateful if you would provide us with the location address or website name. Please contact us at copyright@packt.com with a link to the material.
If you are interested in becoming an author: If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, please visit authors.packtpub.com.
Share your thoughts
Once you’ve read , we’d love to hear your thoughts!...
