MySQL Workbench Guided Tour
This course focuses on the MySQL Workbench Integrated Development Environment.
What you'll learn
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.
Table of contents
Introduction
2mins
MySQL Administration
37mins
- Introduction 1m
- MySQL Workbench Editions 1m
- Demo: Installation and Setup 1m
- Demo: Setup New Connection 3m
- Demo: Advanced MySQL Connection 2m
- Demo: Duplicate MySQL Connections 3m
- Demo: Impact of Settings on Query 2m
- Demo: Navigator 1m
- Demo: Server Status 3m
- Demo: Client Connection 2m
- Demo: Users and Previleges 4m
- Demo: Create New User 2m
- Demo: Status and System Variables 2m
- Demo: Data Export 3m
- Demo: Data Import/Restore 1m
- Demo: Startup/Shutdown 1m
- Demo: Server Logs 2m
- Demo: Options File 2m
- Summary in Sixty Seconds 1m
MySQL Development
33mins
- Introduction 1m
- Demo: Opening SQL Editor 1m
- Demo: Opening SQL Queries File 1m
- Demo: Query Menu: Execute 3m
- Demo: Query Menu: Explain 4m
- Demo: Query Menu: Stop Script Exectuion on Errors 2m
- Demo: Query Menu: Limit Rows 2m
- Demo: Query Menu: Reconnect to Server 1m
- Demo: Query Menu: Transactions 3m
- Demo: Toolbar of Resultset 4m
- Demo: Features of Resultset Panel 2m
- Demo: Toolbar of SQL Query Tab 3m
- Demo: Contex Help 1m
- Demo: Snippets 2m
- Demo: Auto Complete 2m
- Summary in Sixty Seconds 1m
Data Modeling
24mins
- Introduction 1m
- Demo: Create EER Model by Reverse Engineering 5m
- Demo: EER Diagram 4m
- Demo: Vertical Menu 1m
- Demo: MySQL Model and History 3m
- Demo: Model Templates 2m
- Demo: Forward Engineering 2m
- Demo: Schema Transfer 1m
- Demo: Schema Compare 2m
- Demo: Tools and Utilities 2m
- Summary in Sixty Seconds 1m
MySQL Workbench Preferences
16mins
- Introduction 1m
- Demo: Workbench Preferences Screen 1m
- Demo: General Preferences 3m
- Demo: Administrator Preferences 1m
- Demo: SQL Editor Preferences 2m
- Demo: SQL Queries Preferences 3m
- Demo: Model Preferences 1m
- Demo: Diagram Preferences 1m
- Demo: Appearance and Theme Preferences 2m
- Summary in Sixty Seconds 1m
MySQL Workbench Shortcuts
4mins
About the author
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 25 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
