DevOps for the Database with TFS 2018

Free download DevOps for the Database with TFS 2018. This tutorial/course is created by Brian Randell and it has been retrieved from Lynda which you can download for absolutely free. Development Tools and Developer skills are covered in this course.

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 includes:

  • 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

Welcome to DevOps for the Database with TFS 2018. I’m Brian Randell and through this course, I’m going take you on a DevOps journey where we can take care of our SQL server 2017 databases. As a database developer, it’s important that we take care of the database, yet also continuously deliver value for our users. We’re going to learn how to take our database offline and put it under version control. We’ll use TFS’s server’s work item tracking to get just enough traceability so we can find issues in production as quickly as possible and get things fixed.

We’re going to learn how to use Team Build and continuous integration as well as release management and continuous delivery. We’re going to wrap up the course with a bit on testing and real-world issues that you might run into when you try and implement a DevOps practice for your databases in your organization. Let’s go learn about DevOps for databases with TFS 2018.

Free Download DevOps for the Database with TFS 2018

  Download devops-for-the-database-with-tfs-2018-udemy.rar (701.40 MB)

You might also like