MySQL Workbench Tutorial Objective

Session 01: MySQL Workbench Installation

Session 02: MySQL Workbench Configuration

Session 03: Connections in MySQL Workbench

Session 04: Administrative Tasks

Session 05: Performance Tools

Session 06: Database Design and Modeling

Session 07: Database Migration

Detailed Syllabus:

Session 01: MySQL Workbench Installation

MySQL Workbench Install on Windows
MySQL Workbench Install on Linux

Session 02: MySQL Workbench Configuration

User Accessibility Options
Workbench Preferences
MySQL Workbench Settings and Log Files
Common Preferences and Configuration

Session 03: Connections in MySQL Workbench

Creating A New MySQL Connection
Manage Server Connections
Client Connections

Session 04: Administrative Tasks

Server Management
Users and Privileges
Server Status
Status and System Variables
Data Export and Import
MySQL Audit Inspector Interface
MySQL Enterprise Backup Interface
MySQL Enterprise Firewall Interface
Wbcopytables Utility

Session 05: Performance Tools

Performance Dashboard
Performance Schema Reports
Query Statistics
Visual Explain Plan
Using Explain to Improve Query Performance

Session 06: Database Design and Modeling

Modeling Interface
Additional Modeling Tools
Modeling Tutorials
Forward and Reverse Engineering
Schema Synchronization and Comparison
Table Templates
Customizing DBDoc Model Reporting Templates

Session 07: Database Migration

General Installation Requirements
Migration Overview
Conceptual DBMS Equivalents
Microsoft Access Migration
PostgreSQL Migration
MySQL Migration
Using the MySQL Workbench Migration Wizard

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.