MySQL: Getting Started

MySQL    |    Intermediate
  • 11 videos | 1h 8m 45s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 363 users Rating 4.6 of 363 users (363)
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

  • 1m 50s
  • 7m 31s
    In this video, find out how to identify requirements that a database management system must satisfy. FREE ACCESS
  • Locked
    3.  Installing MySQL
    8m 44s
    This video will show you how to install MySQL on different platforms. FREE ACCESS
  • Locked
    4.  The MySQL CLI
    6m 14s
    In this video, you will learn how to connect to a MySQL server using a command line interface. FREE ACCESS
  • Locked
    5.  Getting Started with MySQL
    5m 39s
    In this video, you will learn how to create a database and view a list of databases on a MySQL server. FREE ACCESS
  • Locked
    6.  Installing MySQL Workbench
    8m 7s
    Find out how to install MySQL Workbench and connect to a MySQL server. FREE ACCESS
  • Locked
    7.  Entities in Database Design
    7m 37s
    In this video, you will create models of entities in a real-world scenario to use in a database system. FREE ACCESS
  • Locked
    8.  Getting Started with MySQL Workbench
    9m 14s
    During this video, you will learn how to execute commands from the MySQL Workbench environment. FREE ACCESS
  • Locked
    9.  Insert and Query Operations
    7m
    In this video, you will learn how to perform basic database operations, such as inserting and querying data. FREE ACCESS
  • Locked
    10.  Describing and Truncating Tables
    6m
    Learn how to view table metadata and delete data from tables. FREE ACCESS
  • Locked
    11.  Course Summary
    51s
    In this video, you will find a course summary. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Book Job Ready SQL
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)
Course Java SE 11: Inheritance, Lists, Inference, & Lambda Expressions
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Course MySQL: Understanding & Implementing Joins
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)