Course Details

Previous Page


MySQL: Database Concepts, Design, and Installation


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



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