Database Delivery Best Practices

Keeping track of your application's database is never an easy task. You will learn different approaches to database delivery and best practices that will help you avoid running into common pitfalls in this area.
Course info
Rating
(71)
Level
Intermediate
Updated
June 7, 2016
Duration
2h 15m
Table of contents
Introduction
18m 5s
Description
Course info
Rating
(71)
Level
Intermediate
Updated
June 7, 2016
Duration
2h 15m
Description

While such topics as source code versioning and continuous delivery are pretty well-known, many programmers still struggle with the process of database delivery, which, if left without proper management, may lead to significant maintainability issues down the road. If you ever found your database delivery process unreliable or you are willing to avoid falling into such situation in the future, this course is for you. In Database Delivery Best Practices, you will learn different approaches to database delivery and best practices that will help you avoid running into common pitfalls in this area. First, you'll learn how to build a reliable, evolutionary process of the database delivery. The course covers such topics as state-based and migration-based approaches to database delivery: which of them is suitable in what circumstances; patterns for refactoring the database in case it is used by multiple applications. You will also go through building your own light-weight database versioning tool which will help you better understand the whole database delivery process. In the end, you'll be able to keep better track of your app's database and maintain it for future use.

About the author
About the author

Vladimir Khorikov is a Microsoft MVP and has been professionally involved in software development for more than 10 years.

More from the author
Specification Pattern in C#
Intermediate
1h 27m
27 Jun 2017
Building a Pragmatic Unit Test Suite
Intermediate
3h 42m
7 Oct 2016
More courses by Vladimir Khorikov
Transcript
Transcript

Hi everyone, my name is Vladimir Khorikov and welcome to my course Database Delivery Best Practices. I am a backend developer and very excited to share this course with you.

Database deployment is a quite challenging process.This course will guide you through different approaches to database delivery and best practices that will help you avoid running into common pitfalls in this area.

Some of the major topics that we will cover include:

  • Basic database deployment principles
  • The state-based approach to database delivery
  • The migration-based approach
  • Building your own migration tool
  • Refactoring integration databases

By the end this course, you will know how to choose the approach to database delivery that best suits your project needs.

Before beginning the course you should be familiar with the SQL programming language and have at least basic understanding of C#. Please join me on this journey to learn Database Delivery Best Practices, here, at Pluralsight.