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
AzureAZ-900 Azure Fundamentals Cheat SheetAzureAZ-900 Azure Fundamentals Cheat SheetAzureAZ-900 400 Practice QuestionsAzure › AZ-900AZ-900 400 Practice QuestionsAzureExam AI-200 Developing AI Cloud Solutions on AzureAzure › AI-200Exam AI-200 Developing AI Cloud Solutions on AzureAzureAZ-900 Complete Exam Guide 2026Azure › AZ-900AZ-900 Complete Exam Guide 2026