Introduction to MySQL Workbench: A Beginner’s Guide

Introduction to MySQL Workbench: A Beginner’s Guide

This course is designed to equip beginners with the fundamental skills needed to effectively utilize MySQL Workbench for database management and development. Whether you're new to databases or transitioning from another platform, this course will provide you with a solid foundation in using MySQL Workbench to create, manage, and query databases. 

Course Objectives 

  1. Understand the basic concepts of relational databases. 
  2. Learn to navigate and utilize the MySQL Workbench interface efficiently. 
  3. Create and manage databases, tables, and relationships using MySQL Workbench. 
  4. Perform basic and intermediate SQL queries within MySQL Workbench. 
  5. Gain familiarity with data modelling and visualization tools available in MySQL Workbench. 
US$ 247.03
247.03 USD US$ 247.03
US$ 350.00
Responsible Dr M. Motahar
Last Update 04/19/2024
Completion Time 5 hours 7 minutes
Members 22
  • Introduction to MySQL Workbench
    • What is MySQL?
      10 xp
    • What is MySQL Workbench?
      10 xp
    • How to Download and Install MySQL Workbench (For Windows)
      10 xp
    • How to set up MySQL Server (For Windows)
      10 xp
    • Brief Tour of MySQL Workbench
      10 xp
    • How to Download and Install MySQL Workbench (For Mac)
      10 xp
    • How to Set Up MySQL Server (For Mac)
      10 xp
    • How to Download Sample Databases (for Mac)
      10 xp
    • How to Access your Sample Databases
      10 xp
  • Navigating MySQL Workbench
    • The SQL Visual Editor
      10 xp
    • Workbench Preferences
      10 xp
    • The SQL Workbench Main Toolbar
      10 xp
    • Administration Navigator Tab
      10 xp
    • Schemas Navigator and Information Panel
      10 xp
  • ER Modelling
    • Generate ER Models of the Sample Databases
      10 xp
    • Overview of the Model Editor
      10 xp
    • Creating an ER Model in MySQL Workbench
      10 xp
    • Creating an ER Diagram
      10 xp
    • How to Establish Relationships between Tables
      10 xp
    • How to Export a Schema from the Model Editor
      10 xp
  • Creating and Managing Databases
    • Creating New Databases
      10 xp
    • USE and DROP Databases
      10 xp
    • How to Back up your Databases (using Data Export)
      10 xp
    • How to Restore your Databases (Using Data Import/Restore)
      10 xp
    • SHOW Databases and Managing Database Connections
      10 xp
  • Working with Tables
    • Reviewing Table Design
      10 xp
    • Data Types and Constraints
      10 xp
    • Creating a Table
      10 xp
    • Implementing Relationships using Primary Keys and Foreign Keys
      10 xp
    • Altering Tables
      10 xp
  • Inserting and Updating Data
    • How to Insert Data using Data Import/Restore
      10 xp
    • Importing Data using INSERT INTO
      10 xp
    • How to Enable Loading In Local Files into MySQL Workbench
      10 xp
    • How Import a CSV File into a Table
      10 xp
    • UPDATE Table
      10 xp
    • DELETE FROM Table
      10 xp