petees / mysql_database_administration

Examples & Solutions from database administration courses

Examples & Solutions from database administration courses

📌 Course 1:
MySQL database administration: Basics

📝 Description:

➥ Creating, Altering, and Deleting Schemas & Tables
Firstly, learning how to create schemas and tables using SQL code and with the Workbench UI tools. Then, learing how to alter tables by adding and removing columns. Finally, walking through dropping schemas and tables.

➥ Inserting, Updating, and Deleting Records
Learning how to populate those tables with records of data, and update and delete records as needed.

➥ Database Design
Learning how tables relate to one another optimally, and discussing best practices for database design. Exploring the EER Diagram Editor.

➥ Advanced Concepts
Getting into concepts like adding an index to a column, imposing constraints, and creating stored procedures and triggers.

➥ Server & User Management
Learning how to monitor servers to make sure they are running, and how to restart them when needed. Using user management tools to assign roles and manage permissions.

📌 Course 2:
MySQL database administration: Advanced

📝 The most important topics:

➥ Importing Data to the Database

➥ Altering, Updating & Mapping Keys

➥ Replication, Backup & Recovery

➥ Trigger Automation

➥ Creating Views

➥ The EER Diagram Editor

➥ Stored Procedures & Scheduled Events

➥ Automating Data from Website Activity

➥ Database Security