Provisioning a MySQL Database

In this lab you will learn how to provision a database that contains a table used to store authorized user data. You will use the Structured Query language (SQL) to create a database, create a table, query from a table, and insert data into a table.  

outcomes

In this lab, you will learn to: 

  1. Install the MySQL database server in Linux.
  2. Create a database in MySQL.
  3. Create a table in MySQL.
  4. Query a table in MySQL.
  5. Insert data into a table in MySQL.

Videos:

Before you start this lab, review these videos.

Installation of MySQL

Creating a Database

Creating a Database Table

Inserting Data into the Database Table

Overview

The development of this document is funded by the Boston Area Advanced Technological Education Connections (BATEC) Grant No. NSF-0703097 thru Bunker Hill Community College.

A database (DB) is a container used to store data. MySQL describes the query language type and possible syntax (version dependent) used to interact with a MySQL DB. In this lab, we will provision a MySQL DB that will be used to store authorized user data.

image001.jpg

Provisioning a MySQL Database

Courses

Key terms and descriptions

SQL
Structured Query Language is the standard language for accessing data in relational databases.
MySQL
A MySQL database is a type of database that stores data in tables. It is a relational database management system (RDBMS) that provides both data storage and data manipulation.
RDBMS
A relational database management system, or RDMS, stores data in tables with rows and columns. Rows represent records or facts about an entity, and columns represent the different attributes of that entity.