Scripting MySQL Database: Automate Repetitive Database Development Tasks
In this video I show you how to create database scripts to automate the following tasks:
- Drop Database
- Drop User
- Create Database
- Create Tables
- Insert Test Data
Understanding how to drop and create a database via scripts and insert test data is a critical skill to add to your software developer toolbox.
Repository: https://github.com/pulpfreepress/it-5...
Refactoring: Improving The Design of Existing Code, Martin Fowler — https://www.amazon.com/Refactoring-Im...
Video Index:
0:00 Introduction and Overview
7:20 Creating Database Scripts
10:26 Create Project Structure and Create Script Files
17:54 Create Database with GUI Tool and Export Script
24:05 Examine Exported Database Script
25:11 Extract SQL Code for Individual Scripts
39:35 Create initialize_database.sh Bash Script
46:00 Set Execute Permissions (chmod +x) on initialize_database.sh Script
46:37 Test drop_database.sql
47:51 Test create_database.sql
49:20 Test create_tables.sql
51:11 Troubleshoot create_tables.sql
57:48 Test insert_test_data.sql
1:02:26 Text and Troubleshoot create_user.sql
1:05:24 Write Errors to Log Files