Implement CI/CD by using SQL Database Projects
Intermediate
Database Administrator
Developer
Data Engineer
Azure
Azure SQL Database
SQL Server
Implement CI/CD for SQL Database Projects with source control, branching, schema drift detection, automated pipelines, and testing strategies using GitHub Actions and Azure DevOps.
Learning objectives
By the end of this module, you're able to:
- Create, build, and validate database models by using SQL Database Projects, including SDK-style.
- Configure source control for SQL Database Projects and manage reference data with predeployment and post-deployment scripts.
- Manage branching, pull requests, and conflict resolution for database code.
- Detect schema drift by using schema comparison tools and SqlPackage.
- Implement CI/CD pipelines with GitHub Actions and Azure DevOps, including secrets management and deployment controls.
- Design and implement a testing strategy with unit tests and integration tests.
Prerequisites
- Basic understanding of SQL and Transact-SQL.
- Familiarity with Azure SQL Database or SQL Server.
- Experience with Git version control concepts such as commits, branches, and pull requests.
- Basic understanding of CI/CD concepts and YAML pipeline syntax.
Get started with Azure
Choose the Azure account that's right for you. Pay as you go or try Azure free for up to 30 days. Sign up.