What this book covers
Chapter 1, Understanding the Core Data Terminologies, is all about creating a knowledge foundation around data types, transactional databases, analytical databases, data ingestion, and data stores.
Chapter 2, Exploring the Roles and Responsibilities in Data Domain, 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.
Chapter 3, Working with Relational Data, 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.
Chapter 4, Working with Non-Relational Data, 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.
Chapter 5, Exploring Data Analytics Concepts, covers how to generate insights by processing data into a data analytics system, enabling the business to carry out data-driven operations.
Chapter 6, Integrating Relational Data on Azure, 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.
Chapter 7, Provisioning and Configuring Relational Database Services in Azure, teaches you how to provision and configure Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL.
Chapter 8, Querying Relational Data in Azure, explores Structured Query Language (SQL) and how you can use it to query, insert, update, and delete data in Azure SQL Database.
Chapter 9, Exploring Non-Relational Data Offerings in Azure, 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.
Chapter 10, Provisioning and Configuring Non-Relational Data Services in Azure, looks at how to provision and configure Azure Cosmos DB and Azure Data Lake Storage.
Chapter 11, Components of a Modern Data Warehouse, 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.
Chapter 12, Provisioning and Configuring Large-Scale Data Analytics in Azure, 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.
Chapter 13, Working with Power BI, is where you will learn what Power BI is, including its building blocks and how they work together.
Chapter 14, DP-900 Mock Exam, provides practice tests to prepare you for the DP-900 exam.
