DevOps for the Database with TFS 2018

DevOps for the Database with TFS 2018
DevOps for the Database with TFS 2018
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 34m | 502 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
Table of Contents

Introduction
1 Welcome
2 What you should know

Tooling Overview
3 DevOps overview
4 DevOps for databases
5 Team Foundation Server (TFS) 2018 overview
6 SQL Server Data Tools (SSDT) overview
7 Supporting tools
8 End-to-end demo

Version Control Your Database
9 Why version control
10 Tracking your work
11 Team project setup - Demo
12 Backlog - Demo
13 Team Foundation Version Control (TFVC) vs. Git
14 Version control your SQL Server database
15 Sample database installation
16 Version control your SQL DB with Git - Demo set up
17 Version control your SQL DB with Git - Demo import database
18 Version control your SQL DB with Git - Demo set up another user
19 Version control your SQL DB with Git - Demo share changes
20 Version control your SQL DB with TFVC - Demo set up and import
21 Version control your SQL DB with TFVC - Share changes
22 Branching and merging
23 Local deployments
24 Local deployments - Demo
25 Dealing with drift
26 Dealing with drift - Demo

Build Your Database
27 Team build
28 Agents
29 Pipelines
30 Build your database for SQL Server
31 Agents and pipelines - Demo
32 Build your database for SQL Server - Demo
33 Continuous integration
34 Continuous integration - Demo

Release Your Database
35 Why release management
36 Agents and pipelines
37 Deployment groups
38 Deployment groups - Demo
39 Release your database to SQL Server
40 Release your database to SQL Server - Demo
41 Continuous deployment
42 Continuous deployment - Demo
43 Multiple deployment groups - Demo
44 Multiple environments - Demo

Test Your Database
45 Why test
46 Database testing frameworks
47 Testing locally with SSDT - Demo
48 Testing as part of release
49 Sharing unit projects with a team - Demo
50 Testing and release - Demo

Real-World Issues
51 Real-world issues overview
52 Data motion
53 Static data
54 Data motion and static data - Demo
55 Database drift at scale
56 Testing at scale
57 Versioning the database
58 Apps and databases
59 Add website to project - Demo
60 Deploy app to shared dev - Demo

Conclusion
61 Next steps