Explore the fundamental building blocks essential for crafting effective solutions within the Microsoft Power Platform ecosystem.

1. Introduction
2. Describe Power Platform administration
3. Describe Power Platform security and governance
4. Explore Microsoft Dataverse
5. Examine Power Platform connectors
6. Build a Data Model

An environment serves as a dedicated realm for organizing and maintaining your company’s critical business data, all housed within a Dataverse database instance. You have the flexibility to establish a single or multiple environments, tailored to your organization’s requirements. Delve into this module to delve into the intricacies of these environments and their seamless integration with Dataverse database instances.

1. Environments in Microsoft Dataverse
2. Create and manage an environment
3. Create an instance of a Microsoft Dataverse database
4. Add users and roles within an environment
5. Manage settings in an environment

Think of Dataverse tables as akin to database tables, but with a unique twist. Each Dataverse database instance comes equipped with a foundational collection of tables that establish a solid framework for housing data frequently employed by business applications.

1. Identify tables and table types in Dataverse
2. Create a custom table
3. Enable attachments within a table
4. Licensing requirements for each table type

Are you looking to craft fresh data columns or tap into established standardized columns for your business solutions? This module is designed to guide you through the process of handling and generating new columns within a Dataverse table.

1. Define columns in Microsoft Dataverse
2. Column types in Microsoft Dataverse
3. Add a column to a table
4. Create a primary name column
5. Restrictions that apply to columns in a table
6. Create an auto numbering column
7. Create an alternate key

Are you interested in establishing uniform choice lists that can be applied throughout your Power Apps? This module will walk you through the steps of crafting new or utilizing existing standard choice lists, known as “choices,” within Dataverse.

1. Define choice column
2. Standard choices column
3. Create new choice or modify existing choices

Are you looking to establish connections between tables? This module will demonstrate the methods and rationales behind dividing data into tables and creating relationships between them, enabling the construction of intricate and resilient business solutions. Additionally, it will provide insights into the various types of relationships that can be established within Dataverse tables.

1. Relate one or more tables
2. Relationship types
3. Create a one-to-many relationship
4. Create a many-to-many relationship
5. Edit or delete relationships

Are you interested in utilizing rollup or calculation columns? This module will guide you through the process of constructing calculations or rollups that are defined and activated within Dataverse data, irrespective of the application interacting with that dataset.

1. Introduction to rollup columns
2. Create a rollup column
3. Introduction to calculation columns
4. Create a calculation column

Establishing business rules to maintain consistent business logic across various applications that access a dataset is crucial for a thriving business. This module will demonstrate how you can create business rules that are automatically triggered whenever they are applied within Dataverse.

1. Introduction to Business Rules
2. Define the components of a business rule
3. Create a business rule

Interested in implementing security roles to restrict user permissions? This module will guide you through the process of setting up permissions to control access within an environment. Learn how to manage user privileges, determine who can view, edit, or delete data in a Dataverse environment.

1. Introduction to environment roles
2. Understand environment roles
3. Adding or disabling an environment user
4. Understand user security roles and security role defaults
5. Create a custom role
6. Check the roles that a user belongs to
7. Configure Dataverse teams for security
8. Configure Dataverse group teams for security