Scripting MySQL Database: Automate Repetitive Database Development Tasks

Published: 13 November 2022
on channel: Pulp Free Press

438

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

On this page of the site you can watch the video online Scripting MySQL Database: Automate Repetitive Database Development Tasks with a duration of hours minute second in good quality, which was uploaded by the user Pulp Free Press 13 November 2022, share the link with friends and acquaintances, this video has already been watched 438 times on youtube and it was liked by 6 viewers. Enjoy your viewing!