MySQL: Database Concepts, Design, and Installation

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

Prerequisite
None

Expected Duration
119 minutes

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.

Objective

Concepts 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

Configure MySQL Using MySQL Workbench

  • 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

Core Design Concepts

  • 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

Practice: Installing and Designing MySQL

  • install and design a MySQL database

SUBSCRIPTION COST


$1,295.00

 

NEED HELP OR NOT SURE?