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
Resolve the captcha to access the links!