Skip to content
eBooks › Azure
AzureMicrosoft Dataverse: From Zero to ExpertIndeep Sidhu

Microsoft Dataverse: From Zero to Expert

Azure
By Indeep Sidhu Updated Nov 12, 2026 PDF · 364.7 KB
Dataverse tutorial for VS Code, Power Apps and Dynamics 365
Sign in or create a free account to download the PDF. Sign in Register

What's inside

20 sections
  • How to use this guide
  • Learning path
  • Conventions
  • What Dataverse Is
  • Core vocabulary
  • Architecture at a glance
  • Why use Dataverse instead of a plain database?
  • Table types you will meet
  • Exercise
  • Setting Up Your Workshop
  • Get an environment
  • Install the developer tools
  • First connection from VS Code
  • Tour of the maker portals
  • Exercise
  • Data Modelling in Practice
  • The model
  • Names: display, schema, logical
  • Create the solution and tables in the portal
  • Column types
  • Relationships
  • Alternate keys
  • Views, forms and the model-driven shell
  • Define the same table in code
  • Exercise
  • Solutions and the VS Code Workflow
  • Unmanaged vs managed
  • The VS Code workflow
  • Clone an existing solution
  • Start a solution from scratch
  • Day-to-day commands
  • Source control layout
  • Environment variables and connection references
  • Exercise
  • The Security Model
  • Authentication and licensing
  • Business units, users and teams
  • Security roles and privileges
  • Design pattern: ticket access
  • Sharing and column security
  • Test security properly
  • Exercise
  • Querying and Changing Data
  • Prepare VS Code for the Web API
  • OData: read
  • OData: create, update, delete
  • Batch and associations
  • FetchXML
  • SQL with the TDS endpoint
  • Query performance basics
  • Exercise
  • Writing Code Against Dataverse
  • Authentication for code
  • Python with the Web API
  • Dataverse SDK for Python (preview)
  • .NET: ServiceClient
  • Early-bound classes with the model builder
  • TypeScript / Node
  • Exercise
  • Business Logic
  • The event pipeline
  • Build a plug-in
  • Custom API
  • JavaScript on model-driven forms
  • Power Automate and Dataverse
  • Exercise
  • Power Apps on Dataverse
  • Model-driven apps
  • Canvas apps with Dataverse
  • PCF code components
  • Power Pages (brief)
  • Choosing the right app type
  • Exercise
  • Dynamics 365 CRM on Dataverse
  • Key tables
  • Extend, do not modify
  • Call the CRM operations from code
  • Typical CRM customization projects
  • Exercise
  • Integration and Data Movement
  • Choose the pattern
  • Idempotent integration with upsert
  • Change tracking
  • Events: webhooks and Service Bus
  • Working with files and images
  • Exercise
  • ALM, CI/CD and Environments
  • Environment strategy
  • GitHub Actions pipeline
  • Quality gates
  • Backup, restore and copy
  • Exercise
  • Performance, Limits and Troubleshooting
  • API limits you must design for
  • Performance checklist
  • Diagnosing problems
  • Observability
  • Storage and cost awareness
  • Exercise
  • Database Design: What to Focus On
  • Start from requirements, not from tables
  • Design principles
  • Tables, columns and naming
  • Relationships and cascade behavior
  • Security-aware design
  • Performance-aware design
  • Data quality and integrity
  • Common design anti-patterns
  • Design review checklist
  • How to Secure Dataverse (Defense in Depth)
  • Identity: who is calling
  • Network: where the call comes from
  • Authorization: what the caller may do
  • Data protection
  • Application security: your code
  • Power Pages and external users
  • Monitoring, audit and response
  • Threat to control map
  • Exercise
  • Rate Limiting, Throttling and Resilience
  • Why rate limit at all
  • What Dataverse already enforces
  • Client-side patterns: be a good citizen
  • Rate limiting your own API (server side)
  • Other places throttling appears
  • Test your limits
  • Exercise
  • Mandatory Precautions and Production Checklists
  • Identity and access
  • Data protection and privacy
  • Application and API
  • Resilience and operations
  • Change management and ALM
  • Compliance and governance
  • Incident response runbook (summary)
  • The twenty most common mistakes
  • Sign-off template
  • Capstone: The Contoso Service Desk
  • Requirements
  • Build plan
  • Acceptance tests (copy into your repo)
  • Stretch goals
  • Expert Roadmap, Cheat Sheets and Sources
  • What "expert" looks like
  • PAC CLI cheat sheet
  • Web API cheat sheet
  • Common design decisions
  • Sources and further reading

Code & supporting files

No supporting links for this eBook yet.

More in Azure