MySQL: Getting Started

MySQL 8:0
  • 11 Videos | 1h 13m 15s
  • Includes Assessment
  • Earns a Badge
Likes 61 Likes 61
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 50s
    UP NEXT
  • Playable
    2. 
    Introducing Database Systems
    7m 31s
  • Locked
    3. 
    Installing MySQL
    8m 44s
  • Locked
    4. 
    The MySQL CLI
    6m 14s
  • Locked
    5. 
    Getting Started with MySQL
    5m 39s
  • Locked
    6. 
    Installing MySQL Workbench
    8m 7s
  • Locked
    7. 
    Entities in Database Design
    7m 37s
  • Locked
    8. 
    Getting Started with MySQL Workbench
    9m 14s
  • Locked
    9. 
    Insert and Query Operations
    7m
  • Locked
    10. 
    Describing and Truncating Tables
    6m
  • Locked
    11. 
    Course Summary
    51s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 22 Likes 22  
Likes 20 Likes 20  
Likes 22 Likes 22  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 152 Likes 152  
Likes 7 Likes 7  
Likes 27 Likes 27