Delivering High-Quality Databases Using Visual Studio 2022

The Delivering High-Quality Databases Using Visual Studio 2022 course is a focused 14-hour training program on SQL Server database development with Visual Studio 2022. Covering schema management, Git integration, unit testing, code analysis, and CI/CD with Azure Pipelines, this course teaches you to treat database code with the same rigor as application code. Duration: 14 hours | Price: €1,497. Provider: Esamatic srl, Microsoft Learning Partner in Milan, delivered by Microsoft Certified Trainers.

• Schema Management: Use SQL Server Database Projects for structured, version-controlled schema development
• Version Control: Manage database code with Git workflows and collaborative branching
• Unit Testing: Write and execute database unit tests to ensure data integrity and logic correctness
• Code Analysis: Apply static analysis rules to catch issues before deployment
• Automated Deployment: Build CI/CD pipelines for database changes using Azure Pipelines

Course Overview: Delivering High-Quality Databases Using Visual Studio 2022

Database development often lags behind application development in adopting modern engineering practices. This course bridges that gap, teaching you how to use Visual Studio 2022 and SQL Server Database Projects to bring version control, automated testing, code analysis, and CI/CD to your database development workflow.

Learning Objectives

1. Project-Based Development — Structure database code using SQL Server Database Projects for maintainable schemas
2. Version Control Integration — Manage database changes through Git with effective branching and merge strategies
3. Quality Assurance — Implement unit tests and static code analysis to catch defects early
4. Deployment Automation — Create CI/CD pipelines with Azure Pipelines for safe, repeatable database deployments

Who Should Attend

Database developers, DBAs, data engineers, and software developers who work with SQL Server databases and want to adopt modern DevOps practices for database development.

Career Benefits

Database DevOps is a rapidly growing discipline. Professionals who can apply software engineering practices to database development are increasingly valued as organizations seek to reduce deployment risk and accelerate delivery.

Prerequisites

• Working knowledge of SQL Server and T-SQL
• Basic familiarity with Visual Studio
• Understanding of version control concepts

Frequently Asked Questions

Which SQL Server versions are supported?

The techniques apply to SQL Server 2016 and later, including Azure SQL Database. The course uses the latest tooling in Visual Studio 2022.

Do I need Azure DevOps for the CI/CD portion?

The course uses Azure Pipelines for CI/CD demonstrations. Lab environments are provided, so no personal subscriptions are needed.

Is this course relevant for Azure SQL Database?

Yes, SQL Server Database Projects and the associated DevOps practices work with both on-premises SQL Server and Azure SQL Database.

Will I learn about data migration strategies?

Yes, the course covers schema comparison, data migration scripts, and strategies for deploying changes to existing databases safely.