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
eLearning | Skill level: Intermediate


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


Download from Turbobit

Download from DepositFiles

Download from Rapidgator