DevOps for the Database with TFS 2018


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

Download rapidgator

Tags: , , ,

Leave a Reply