
Dataverse Course
All sessions start at 9.00am and end at 12.30pm (UK time)
Course Content
Module 1: The Power Platform
-
Power Platform overview
-
Brief history of Dataverse
-
Dataverse and environments
-
Managed environments
Module 2: Relational database concepts
-
Relational databases
-
Tables
-
Relationships
Module 3: Dataverse tables
-
Create tables
-
Table properties
-
Activity, virtual and elastic tables
Module 4: Dataverse columns
-
Create columns
-
Column properties
-
Calculated, rollup and formula columns
Module 5: Relationships
-
Relationship types in Dataverse
-
Cascading behaviours
-
Mapping in relationships
-
Hierarchical relationships
-
Connections
Module 6: Security model
-
Add users to Dataverse
-
Business Units
-
Security roles and privileges
-
Column-level security
-
Teams
-
Sharing
-
Hierarchy Security
Module 7: Import and export data
-
Import wizards
-
Use Power Query
-
Export to Excel
-
Excel and Word templates
Module 8: Logic and validation
-
Business rules
-
JavaScript
-
Power Fx
-
Low-code plugins
Module 9: Automation
-
Classic workflows
-
High-level overview of Power Automate
Module 10: Dataverse settings
-
Environment settings
-
Search
-
Auditing
-
Duplicate detection
-
Bulk delete
-
Long term data retention
-
Recycle bin
Module 11: Solutions
-
Overview of solutions
-
Unmanaged and managed solutions
-
Overview of Application Lifecycle Management in Dataverse
Pre-requisites and target audience
A proficiency in basic computer skills using Microsoft Office 365 products is required. Database skills are useful but not required.
This course is suitable for:
-
Database administrators
-
Dynamics 365 and Power Platform end-users, power users, and administrators
-
IT Professionals
-
Consultants
You need access to a Power Apps Developer Plan. If you don't have one already, please follow the steps at this Microsoft Learn article to provision one.
Live course delivered on-line​
This is an instructor-led course delivered online over six 3.5 hour sessions.
​​
The course is for anyone who wants to learn about Microsoft Dataverse. This is a deep-dive course covering only Dataverse and does not cover Power Automate or Power Apps.
The course includes presentations, demos and exercises for students to perform.
The course will be recorded and you will have access to the recordings.
