We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around September 19, 2018.
(1) If you’re using your own computer (Windows or Mac), you’ll need to install the software;
If you’re using a lab computer which already has MySQL Workbench installed, you’ll still need to configure a connection to access databases with your username and password.
(2) You can get instructions for how to do both of those things in this Quick Guide to MySQL Workbench. Use the guide to set up your software and connection.
(3) Whether you use a lab computer or your own computer, you’ll also need a MySQL username and password. I’ve assigned one to each of you, which you’ll find in the Under Grades in Canvas
- To find it, in Canvas, click Grades, then click “MySQL Account“
- You will find the MySQL username and password are added as comments to “MySQL Account.”
- The first value that starts with “m” is the username, and the second value is the password.
Starting from next Friday, September 7, we will learn how to create Entity Relationship diagrams (ERDs) to model databases.
To create ERDs, we will use ERDPlus, a free tool that is quite easy to use. Specifically, we will use the standalone version of ERDPlus (https://erdplus.com/#/standalone), which allows us to create an ERD within a browser.
There is a short YouTube tutorial (link: https://www.youtube.com/watch?v=A5-yy51eNGY) that shows you how to create a diagram, and export the diagram as an image which can be placed into a Word document.
Please watch this video on your own before Monday, September 10.