# Module 2: Managing Databases

MODULE OVERVIEW

This module introduces the fundamental database management operations in MySQL.



Learners will explore how to create new databases, select databases for use,
view available databases and remove databases when they are no longer required.



These operations provide the foundation for organising and managing database
environments used in business applications, reporting systems and data
management activities.




WHAT WILL BE COVERED


2.1 CREATE DATABASE

 * Understanding the purpose of database creation in MySQL.

 * Using the CREATE DATABASE statement.

 * Defining database names and creating new databases.

 * Understanding database creation syntax.

 * Creating separate databases for different business applications and data
   requirements.


2.2 SELECT DATABASE

 * Understanding how to select a database for use.

 * Using the USE statement in MySQL.

 * Switching between available databases.

 * Selecting the appropriate database before executing SQL queries.

 * Working within the correct database environment to manage business
   information.


2.3 SHOW DATABASES

 * Understanding how to view available databases in MySQL.

 * Using the SHOW DATABASES statement.

 * Listing databases available on the MySQL server.

 * Identifying databases within a database environment.

 * Reviewing database availability before performing management operations.


2.4 DROP DATABASE

 * Understanding when and why databases may need to be removed.

 * Using the DROP DATABASE statement.

 * Identifying the database to be removed.

 * Understanding the impact of dropping a database.

 * Applying caution when removing databases containing important business
   information.


SKILLS YOU WILL GAIN

 * Creating databases using MySQL commands.

 * Selecting and switching between databases.

 * Viewing available databases on a MySQL server.

 * Removing databases using SQL statements.

 * Understanding basic database management operations.

 * Managing database environments for different application requirements.


LEARNING OUTCOMES

By the end of this module, learners will be able to:

 * Create databases to organise information for different business applications
   and operational requirements.

 * Select the appropriate database before performing data management and SQL
   operations.

 * View and identify available databases to understand the structure of a MySQL
   server environment.

 * Remove unnecessary databases while understanding the importance of protecting
   existing business data.

 * Perform essential database management operations to maintain organised
   database environments.

 * Apply basic database administration commands when supporting application and
   reporting requirements.


CERTIFICATION ALIGNMENT

This module develops foundational database management skills that support the
Oracle MySQL Database Administrator certification pathway.



The concepts covered help learners understand how databases are created,
accessed, reviewed and managed within a MySQL server environment.


CONTINUE TO THE NEXT MODULE

Continue to Module 3: MySQL Data Types
[https://teamacademy.help.center/article/1365-module-3-mysql-data-types] to
learn about numeric, date and time, character, binary and other data types used
to define and store information in MySQL databases.