MySQL and Workbench
MySQL
MySQL Workbench is a popular tool among MySQL database developers and engineer
MySQL Workbench
➔ MySQL Workbench is a visual tool for MySQL databases that database developers, database designers, and database architects can use to create databases in MySQL.
How to install HR schema on MySQL for learning.
➔ The HR schema is a popular sample relational database design for generic human resources departments, and is commonly used for learning and parcticing SQL queries.
➔ After learning, analyzing, and testing SQL queries here, one can create and design databases, tables, and queries.
➔ The HR schema is provided by Oracle Database for the purpose of learning and demonstrating SQL structure, design, and queries.
Install HR schema in MySQL using workbench
02 Select sql script to open in workbench.
03 Execute all script and refresh Mysql Databases.
04 Query HR databases tables.
How to install Northwind database on MySQL for learning.
➔ The Northwind database is a popular sample relational database design for a generic trading company called "Northwind Traders" that does import-export business around the world.
➔ This sample database is commonly used for learning, understanding, and analyzing SQL queries.
➔ After learning, analyzing, and testing SQL queries in this tutoril, one can create and design databases, tables, and queries.
➔ The Northwind database is provided by Microsoft for the purpose of learning and demonstrating SQL structure, design, and queries.
Install Northwind database in MySQL using workbench
02 Select sql script to open in workbench.
03 Execute all script and refresh Mysql Databases.
04 Refresh schema palate to see the northwind databases and tables.
