Professional Training

Course Objectives

Through a combination of instructor-led training and hands-on activities you will learn how to use Visual Studio
2019 and the integrated SQL Server Data Tools (SSDT) to manage the development and delivery of high-quality
SQL Server databases.

Who Should Attend

This course is intended for database developers and administrators working with modern versions of SQL Server
or SQL Azure. Application developers who are involved with writing and testing T-SQL code and working with test
data will also find value from this course. It would also be beneficial if the student has worked on a team-based
software development project and is familiar with their organization’s development lifecycle and practices.

Agile Database Development

Agile database development overview
Agility challenges and blockers
SQL Server Data Tools overview
Connected vs. disconnected development
Imperative vs. declarative development
Agile database techniques

SQL Server Database Projects

Creating a SQL Server database project
Treating schema as source code
Working with SQL Server Object Explorer
Importing database schema
Importing data-tier applications (.dacpac)
Importing scripts
Managing cross-database dependencies
Referencing a database and .dacpac file

Managing Schema Changes

Introduction to Azure DevOps
Azure Repos overview
Using Git to manage schema changes
Cloning, committing, pushing, and pulling
Comparing schemas and sync’ing changes
Comparing data and sync’ing changes
Rolling back changes using Git
Rolling back changes using project snapshots

Assuring a High-Quality Design

Database unit testing principles
Levels of database unit testing
SQL Server unit tests
Database unit test designer
T-SQL assertions vs. test conditions
Using tSQLt for SQL Server unit testing
Static code analysis
Database refactoring tools

Building and Deploying

Building the database project
Using pre-build and post-build events
Including additional build scripts
Using script build actions
Using the LocalDB isolated sandbox
Deploying changes to SQL Server
Creating and using publishing profiles
Using pre and post deployment scripts
Using SQLCMD variables within scripts
Building/deploying composite projects
Building/deploying SQL CLR objects
Azure Pipelines overview
Using an automated build pipeline
Practicing Continuous Integration (CI)
Using an automated release pipeline
Running tests in the release pipeline
Practicing Continuous Delivery (CD)