MySQL: Getting Started
MySQL
| Intermediate
- 11 videos | 1h 8m 45s
- Includes Assessment
- Earns a Badge
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 31sIn this video, find out how to identify requirements that a database management system must satisfy. FREE ACCESS
-
3. Installing MySQL8m 44sThis video will show you how to install MySQL on different platforms. FREE ACCESS
-
4. The MySQL CLI6m 14sIn this video, you will learn how to connect to a MySQL server using a command line interface. FREE ACCESS
-
5. Getting Started with MySQL5m 39sIn this video, you will learn how to create a database and view a list of databases on a MySQL server. FREE ACCESS
-
6. Installing MySQL Workbench8m 7sFind out how to install MySQL Workbench and connect to a MySQL server. FREE ACCESS
-
7. Entities in Database Design7m 37sIn this video, you will create models of entities in a real-world scenario to use in a database system. FREE ACCESS
-
8. Getting Started with MySQL Workbench9m 14sDuring this video, you will learn how to execute commands from the MySQL Workbench environment. FREE ACCESS
-
9. Insert and Query Operations7mIn this video, you will learn how to perform basic database operations, such as inserting and querying data. FREE ACCESS
-
10. Describing and Truncating Tables6mLearn how to view table metadata and delete data from tables. FREE ACCESS
-
11. Course Summary51sIn 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.
