Learn about database projects in a day

Software development and software deployment has changed drastically over the 25 years I have been in the IT industry. Software is deployed to test and production at a pace that requires automation of pretty much everything. Unit tests run in build pipelines, integration tests are automated and deployment to production happens with a click on an approve button.

Why should databases be treated any different?

On this training day, you will learn how SQL Server database projects and Azure DevOps pipelines can be used to build, change, test and deploy databases pretty much the same way all other code is.

Topics covered:

- State based vs migration based deployment
- Introduction to SQL Server Projects (SSDT and SDK Style projects)
- Advanced SQL Server Project concepts: Refactcoring database objects, configurations for test and prod, overcoming cross database dependencies.
- Introduction to tSQLt for unit testing database objects.
- tSQLt and SQL Server projects.
- Build, Test and Deploy SQL Server projects using Azure DevOps pipelines.

The day will be a mix of theory, practical examples (demos) and hands-on labs.

Prerequisites: Experience with Transact-SQL DDL statements.

Learn how to work with SQL Server database projects in Visual Studio and VSCode for building and changing SQL Server databases. Learn how to work with tSQLt and to integrate tSQLt unit tests within your Visual Studio database project. Learn how implement a full CI/CD process for your SQL Server database using multi-job Azure DevOps pipelines