Introduction to MySQL Workbench: A Beginner’s Guide (PF)

Introduction to MySQL Workbench: A Beginner’s Guide (PF)

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. 
AU$ 500.00
500.0 AUD AU$ 500.00
AU$ 500.00
Responsible Dr M. Motahar
Last Update 04/08/2024
Completion Time 1 hour 52 minutes
Members 7
  • 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