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.
More
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.
More
Introduction
18m 5s
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.

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: 1. Basic database deployment principles, 2. The state-based approach to database delivery, 3. The migration-based approach, 4. Building your own migration tool, and5. 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.

Table of Contents
Introduction
18m 5s
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.
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: 1. Basic database deployment principles, 2. The state-based approach to database delivery, 3. The migration-based approach, 4. Building your own migration tool, and5. 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.

Course info
Level
Intermediate
Rating
(45)
Duration
2h 15m
Updated
8 Jun 2016
Course authors

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

Share course