Refactor a MySQL Database: Evolve Database Schema via Versioned Scripts

preview_player
Показать описание
This video shows you how to refactor a database schema using versioned database scripts. I'll show you how to create a new table in an existing database and add a new column to an existing table and add a foreign key relationship between the tables.

Chapters:
--------------------------------------------------------------------------------------------------------------
00:00 Intro and Rational
1:46 Database Folder and Script Organization
2:44 Review the Results
3:30 New Feature Request
3:44 DB Version 2 Scripts Walkthrough
4:03 Review README.md Documentation for Script Execution Order
11:19 Run initialize_database to evolve to DB Version 2
12:36 Query modified database from command line
15:05 Summarize Benefits of Refactoring
16:11 Clean Architecture Python Application Preview
  1. Pulp Free Press
  2. Adding Foreign Key Column and
  3. Create database with bash scri
  4. Database Scripting
  5. MySQL
  6. MySQL Database Scripting
Рекомендации по теме
Refactor a MySQL 0:17:53

Refactor a MySQL Database: Evolve Database Schema via Versioned Scripts

How To Refactor 0:09:14

How To Refactor Database Schema With Entity Framework Core

Database Evolution Mondays 1:06:21

Database Evolution Mondays - Episode 1 - Getting into the book 'Refactoring Databases'.

Refactoring Query Processing 1:10:55

Refactoring Query Processing in MySQL (Norvald H. Ryeng, Oracle)

Software and Database 0:50:19

Software and Database Refactor Patterns - Bill Penberthy - NDC London 2021

POV - Windows 0:00:37

POV - Windows User Tries MacOS 😂

How much does 0:00:34

How much does a SOFTWARE DEVELOPER make?

How to Handle 0:12:09

How to Handle the Database Migrations with Alembic | Flask and Python Backend 10

[VDT18] How SQL 0:50:27

[VDT18] How SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder

What is Refactoring? 0:07:48

What is Refactoring? (as a software developer)

MySql Database | 0:26:10

MySql Database | DDL (Alter- Rename column name & Add Constraint)) Implementation || Lecture No ...

How to Refactor 0:49:23

How to Refactor Legacy Code - Webinar

Using sp_rename Rename 0:01:00

Using sp_rename Rename Table Column SQL Server Interview Questions

TypeDB 2.0: a 0:51:37

TypeDB 2.0: a Database Evolution | Haikal Pribadi, CEO of Vaticle @ Orbit 2021

The Evolution of 0:10:55

The Evolution of Facebook's Software Architecture

Refactor Monolithic Application 0:46:44

Refactor Monolithic Application with Konveyor Data Gravity Insights

Database Refactoring Patterns 0:49:06

Database Refactoring Patterns with Pramod Sadalage - Episode 22

MySQL Basics: How 0:10:09

MySQL Basics: How to Create Tables, Insert Data & Rename Columns – Easy Tutorial for Beginners&a...

SQL Tutorial for 3:10:19

SQL Tutorial for Beginners [Full Course]

What is Cloud 0:04:34

What is Cloud Refactoring?

What's your #cloud 0:09:26

What's your #cloud #migration #strategy?

Microservices Evolution: How 1:00:30

Microservices Evolution: How to break your monolithic database by Edson Yanaga

SQL vs NoSQL 0:11:37

SQL vs NoSQL Explained

Rename Statement in 0:07:21

Rename Statement in MySQL| Drop Statement in MySQL | Truncate Statement in MySQL |MySQL Tutorial

Комментарии
Автор

Chapters:

00:00 Intro and Rational
1:46 Database Folder and Script Organization
2:20 Run initialize_database.sh to Create DB Version 1
2:44 Review the Results
3:30 New Feature Request
3:44 DB Version 2 Scripts Walkthrough
4:03 Review README.md Documentation for Script Execution Order
6:27 Review initialize_database.sh bash script
11:19 Run initialize_database to evolve to DB Version 2
12:36 Query modified database from command line
15:05 Summarize Benefits of Refactoring
16:11 Clean Architecture Python Application Preview

PulpFreePress