Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

DevOps for the Database with TFS 2018

via LinkedIn Learning

Go to class Write review

Overview

Learn how to use Team Foundation Server 2018, SQL Server, and Git for development operations, including version control, deployments, release management, and more.

Syllabus

Introduction
  • Welcome
  • What you should know
1. Tooling Overview
  • DevOps overview
  • DevOps for databases
  • Team Foundation Server (TFS) 2018 overview
  • SQL Server Data Tools (SSDT) overview
  • Supporting tools
  • End-to-end demo
2. Version Control Your Database
  • Why version control?
  • Tracking your work
  • Team project setup: Demo
  • Backlog: Demo
  • Team Foundation Version Control (TFVC) vs. Git
  • Version control your SQL Server database
  • Sample database installation
  • Version control your SQL DB with Git: Demo set up
  • Version control your SQL DB with Git: Demo import database
  • Version control your SQL DB with Git: Demo set up another user
  • Version control your SQL DB with Git: Demo share changes
  • Version control your SQL DB with TFVC: Demo set up and import
  • Version control your SQL DB with TFVC: Share changes
  • Branching and merging
  • Local deployments
  • Local deployments: Demo
  • Dealing with drift
  • Dealing with drift: Demo
3. Build Your Database
  • Team build
  • Agents
  • Pipelines
  • Build your database for SQL Server
  • Agents and pipelines: Demo
  • Build your database for SQL Server: Demo
  • Continuous integration
  • Continuous integration: Demo
4. Release Your Database
  • Why release management?
  • Agents and pipelines?
  • Deployment groups
  • Deployment groups: Demo
  • Release your database to SQL Server
  • Release your database to SQL Server: Demo
  • Continuous deployment
  • Continuous deployment: Demo
  • Multiple deployment groups: Demo
  • Multiple environments: Demo
5. Test Your Database
  • Why test?
  • Database testing frameworks
  • Testing locally with SSDT: Demo
  • Testing as part of release
  • Sharing unit projects with a team: Demo
  • Testing and release: Demo
6. Real-World Issues
  • Real-world issues overview
  • Data motion
  • Static data
  • Data motion and static data: Demo
  • Database drift at scale
  • Testing at scale
  • Versioning the database
  • Apps and databases
  • Add website to project: Demo
  • Deploy app to shared dev: Demo
Conclusion
  • Next steps

Taught by

Brian Randell

Reviews

4.8 rating at LinkedIn Learning based on 25 ratings

Start your review of DevOps for the Database with TFS 2018

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.