This is the code repository for Microsoft Certified Azure Data Fundamentals (Exam DP-900) Certification Guide , published by Packt.
The comprehensive guide to passing the DP-900 exam on your first attempt
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.
This book covers the following exciting features:
- Explore the concepts of IaaS and PaaS database services on Azure
- Query, insert, update, and delete relational data using SQL
- Explore the concepts of data warehouses in Azure
- Perform data analytics with an Azure Synapse Analytics workspace
- Upload and retrieve data in Azure Cosmos DB and Azure HDInsight
- Provision and deploy non-relational data services in Azure
- Contextualize the knowledge with real-life use cases
- Test your progress with a mock exam
If you feel this book is for you, get your copy today!
All of the code is organized into folders.
The code will look like the following:
html, body, #map {
height: 100%;
margin: 0;
padding: 0
}
Following is what you need for this book: 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.
With the following software and hardware list you can run all code files present in the book (Chapter 1-14).
| Chapter | Software required | OS required |
|---|---|---|
| 1-14 | Azure Data Studio | Windows, macOS , or Linux |
| 1-14 | Power BI Desktop | Windows or macOS |
| 1-14 | Power BI mobile app | Windows or macOS |
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. Click here to download it.
-
Azure Data Engineer Associate Certification Guide [Packt] [Amazon]
-
Azure Data Engineering Cookbook - Second Edition [Packt] [Amazon]
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.
If you have already purchased a print or Kindle version of this book, you can get a DRM-free PDF version at no cost.
Simply click on the link to claim your free PDF.