MySQL: Database Concepts, Design, and Installation

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
MySQL is fast, reliable, easy to use, free to download and supports standard SQL. In this course, you’ll be introduced to MySQL and learn how to initially configure My SQL using the MySQL Workbench. You’ll also be introduced to the core concepts of relational database management systems (RDBMS) as well as core design concepts including table and column design.

Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

MySQL: Database Concepts, Design, and Installation

start the course

recognize the database platform and its implementations

acquire the correct edition of MySQL and select the correct download options

install and configure of MySQL

define the Workbench

configure the Workbench

create and maintain database connections

configure the server

define status and system variables

create user accounts

manage user permissions

define relational database management systems (RDBMS)

define the standards used in tables for data storage such as, removing duplicates, breaking down fields and the use of primary keys

define the standards used in column design and its properties such as auto increment columns, default and null values and modifying size and format

define the table and column properties such as collation, data type, and field properties

define relationships in a database such as one-to-many, one-to-one and many-to-many

install and design a MySQL database

Course Number:
df_mysq_a01_it_enus

Expertise Level
Beginner