A detailed exploration of MySQL Workbench, a unified visual tool for data modeling, SQL development, and comprehensive administration tools for MySQL. This course will guide you through maximizing the power of MySQL Workbench and getting productive quickly with MySQL.
MySQL Administration Hi, this is Pinal Dave, and welcome to the module of MySQL Administration with MySQL Workbench. In this module, we will cover differences between various MySQL Workbench Editions, Installation and Setup of MySQL Workbench, how to do the first Connection with MySQL Server, various Management Actions in MySQL Workbench Navigator, and finally, various Actions related to Instance in MySQL Navigator.
MySQL Development Hi. This is Pinal Dave, and welcome to the module: MySQL Development with MySQL Workbench. SQL Editor is where developers spend pretty much all of their time. MySQL Workbench is not a simple editor where developer writes query and executes it. There are lots of features that make the developer's life easy, efficient, and error free. In this course we will see four major areas of SQL development in MySQL Workbench. They are: Main Menu, Toolbar, SQL Query Panels, and Sidebar. We will cover each of these topics in detail in this module.
Data Modeling Hi, this is Pinal Dave, and in this module we will understand Data Modeling with MySQL Workbench. Data Modeling is a process of creating a data model for an information system, in our case, MySQL, by applying formal data modeling techniques. The process of data modeling involves expert data modelers working with business stakeholders to build meaningful and efficient data models. The scope of this course is to explain to you how you can implement various data modeling concepts with the help of MySQL Workbench. In this module, we will understand how to create a Data Model, how to import any Existing Data Model into MySQL, and we will also understand how we can build, enhance, and create a relationship diagram with the help of MySQL workbench, frequently use Reverse and Forward Engineering features, we will explore how Schema Transfer Wizard works across different connections, how Template Models can expedite developers efforts to build data models. And finally, we will cover Various Tools and Utilities which makes the developer's life easy and bug free.
MySQL Workbench Preferences Hi, this is Pinal Dave, and in this module we will discuss MySQL Workbench Preferences. MySQL Workbench Preferences control how MySQL Workbench will behave with users as well as MySQL Server. There are many different settings available for MySQL Workbench. In this module, we will cover a few of the General settings related to MySQL Workbench. We will also explore settings related to Administration and SQL Editor. Later on, we will see preferences related to SQL Queries, Model of MySQL, and Diagram. Finally, we will explore how we can change the Appearance of MySQL Workbench and change the overall Theme of MySQL Workbench. Let's see how all of these preferences work with the help of demonstrations.
MySQL Workbench Shortcuts Hi, this is Pinal Dave, and in this module we will discuss MySQL Workbench Shortcuts. There are two different kinds of shortcuts for MySQL Workbench. The first is Link Shortcuts, and the second is Keyboard Shortcuts. Let's understand about each of them in detail.