DevOps for the Database with TFS 2018

MP4 | Video: 720p | Duration: 3:34:10 | English | Subtitles: VTT | 502.6 MB

Having well-managed SQL Server databases is critical to the successful operation of business applications. In this course, learn how to add version control to a database using Team Foundation Server (TFS) 2018. This course covers the end-to-end DevOps life cycle of putting a database under version control and carrying out deployments through a release pipeline. First, an overview of tooling solutions is discussed. Next, configuring a database for version control is shown. Then, building a database is demonstrated, followed by release management and making deployments. Additionally, testing databases and troubleshooting real-world issues are each explored.

Topics include:

Team Foundation Server (TFS) 2018

SQL Server Data Tools (SSDT)

Configuring version control of a SQL database

Installing and importing a database

Setting up users, team build, agents, and pipelines

Handling changes, branching, and merging

Making local deployments

Building a database for SQL Server

Continuous integration

Continuous deployment

Working with multiple groups and environments

Testing databases using frameworks

Working with static data and data motion

Versioning a database