MySQL: Getting Started


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how database systems allow data to be stored and updated in a robust manner, and queried conveniently by using SQL language, and learn how MySQL can be installed and used from different operating environments. Key concepts covered in this 11-video course include requirements that a database management system needs to satisfy and the importance that consistency of the data in a system always be maintained; how to install MySQL on different platforms; and how to connect to a MySQL server by using a command-line interface. You will learn how to create a database and view a list of databases on a MySQL server; learn how to install MySQL workbench and connect to a MySQL server; and learn model entities in a real-world scenario for use in a database system. Next, explore how to execute commands from the MySQL Workbench environment; learn perform basic database operations such as inserting and querying data; and learn how to view table metadata and delete data from tables.



Expected Duration (hours)
1.1

Lesson Objectives

MySQL: Getting Started

  • discover the key concepts covered in this course
  • identify requirements that a database management system needs to satisfy
  • install MySQL on different platforms
  • connect to a MySQL server using a command line interface
  • create a database and view a list of databases on a MySQL server
  • install MySQL workbench and connect to a MySQL server
  • model entities in a real-world scenario for use in a database system
  • execute commands from the MySQL Workbench environment
  • perform basic database operations such as inserting and querying data
  • view table metadata and delete data from tables
  • Course Summary
  • Course Number:
    it_aplumgdj_01_enus

    Expertise Level
    Intermediate