MySQL Workbench Course

Welcome to our MySQL Workbench Course by Studyopedia.

In this Video Course, learn MySQL Workbench and its concepts. Workbench is a UI i.e. a graphical tool for working with MySQL Servers and Databases. MySQL is an open-source relational database management system. It is one of the most popular RDBMS, wherein records are stored in tables. We have covered the following lessons with live running examples:

Course Lessons

Section 1: MySQL Workbench – Introduction & Installation

1. Introduction to MySQL Workbench
2. How to install MySQL Workbench on Windows 10/ 11

Section 2: MySQL Workbench – Create a new Database and Table

3. How to create a new Database and Table in MySQL Workbench
4. How to create a new schema in MySQL Workbench
5. How to Drop a Schema in MySQL Workbench

Section 3: MySQL Workbench – Export/ Import the Data (CSV, SQL, etc.)

6. How to Export Data in MySQL Workbench
7. How to Import Data in MySQL Workbench
8. Export the Result to a CSV file

Section 4: MySQL Workbench – Script

9. Save the script to a file from the SQL Editor
10. Open a script file in the SQL Editor

Section 5: MySQL Workbench – Settings

11. Limit the number of rows in MySQL Workbench
12. Change the font of the SQL Editor
13. Adjust the Panels of the MySQL Workbench
14. Search the Table Data in MySQL Workbench
15. Clear the output window in MySQL Workbench

Section 6: MySQL Workbench – User Roles and Privileges

16. Create a new user in MySQL Workbench
17. Set account limits for users in MySQL Workbench
18. Reset the root password in MySQL Workbench

Note: The flow would be step-by-step and the explanations would include a tutorial-like format, to make it easier for beginners to understand a new database and table and its concepts, with live running queries as examples.

Let us begin!