MySQL Workbench Tutorial for Beginners

Learn MySQL Workbench in 40 minutes

4.67 (3 reviews)
Udemy
platform
English
language
Databases
category
MySQL Workbench Tutorial for Beginners
483
students
39 mins
content
Aug 2023
last update
$19.99
regular price

What you will learn

Learn how to work with Databases from scratch

Learn how to query SQL, since MySQL is SQL-based

Set the user roles

Get a MySQL Workbench crash course

Learn to Import and Export csv, sql, etc. files

Description

Welcome to our MySQL Workbench Course!

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

  1. Introduction to MySQL Workbench

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

  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

  6. How to Export Data in MySQL Workbench

  7. How to Import Data in MySQL Workbench

  8. Export the Result to a CSV file

  9. Save the script to a file from the SQL Editor

  10. Open a script file in the SQL Editor

  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

  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.

Content

MySQL Workbench - Introduction & Installation

Introduction to MySQL Workbench
Install MySQL Server and Workbench on Windows 10/ 11

MySQL Workbench - Create a new Database and Table

Create a new Database and Table
Create a new schema
Drop a Schema

Export/ Import the Data (CSV, SQL, etc.)

Export the Data in MySQL Workbench
Import the Data in MySQL Workbench
Export the Result to a CSV file

MySQL Workbench - Script

Save the script to a file from the Editor
Open a script file in the Editor

MySQL Workbench - Settings

Limit number of rows in MySQL Workbench
Change the font of the Editor in MySQL Workbench
Adjust the Panels of the MySQL Workbench
Search the Table Data in MySQL Workbench
Clear the output window in MySQL Workbench

MySQL Workbench - User Roles and Privileges

Create a new user in MySQL Workbench
Set the admin roles and account limits for users in MySQL Workbench
Reset the root password in MySQL Workbench

Screenshots

MySQL Workbench Tutorial for Beginners - Screenshot_01MySQL Workbench Tutorial for Beginners - Screenshot_02MySQL Workbench Tutorial for Beginners - Screenshot_03MySQL Workbench Tutorial for Beginners - Screenshot_04
5531370
udemy ID
8/30/2023
course created date
9/3/2023
course indexed date
Bot
course submited by