Relational Databases and SQL
This unit is based on the EdX version of the Stanford Online: Relational Databases and SQL course
BEFORE you start the course, you should INSTALL the necessary software and set up the database.
Download the MySQL software installer for your operating system HERE
Windows 10 users, click on the big "MySQL Installer for Windows" link with the picture of the dolphin.
Let the download complete.
MacOS users, click on the ".DMG" download package
Let the download complete.
Follow this video to install the MySQL server on your Windows workstation.
REMEMBER: The root password is 'ics4u2020'
If you need the Microsoft C++ Redstributable, click here and download and install it. Retry MySQL install.
Follow this video to install the MySql server on your MacOS workstation.
REMEMBER: The root password is 'ics4u2020'
The course database load file is here. Download it before proceeding to the next step.
Download the TablePlus TRIAL app from this website for your operating system.
Follow this video to install the Windows TablePlus app that you will use to load the course database.
Follow this video to install the MacOS TablePlus app that you will use to load the course database.
You may now begin the course.
Go to this link and REGISTER for the online course. It is FREE. You are AUDITING the course. Do not choose the Certificate/Verified version. We are doing the FREE version.
NOTE: There are two files that the instructor talks about; Schema.sql and Data.sql.
You may LOOK at the contents in these files BUT
YOU HAVE ALREADY LOADED YOUR DATABASE!!! DO NOT RELOAD THESE FILES!!!
Lecture Adjustments based on MySQL
Table Variables and Set Operators
You will see two commands, 'union' and 'intersect'. These two commands are NOT supported by MySQL.
The instructor will provide alternative query demonstrations.
NOW - Let's Talk to SQL with Java
Follow this tutorial
Uninstalling mySQL from your computer.
Windows
MacOS
Note for Mac users. There may be a few commands that do not work. That's fine. They're old.
BEFORE you start the course, you should INSTALL the necessary software and set up the database.
Download the MySQL software installer for your operating system HERE
Windows 10 users, click on the big "MySQL Installer for Windows" link with the picture of the dolphin.
Let the download complete.
MacOS users, click on the ".DMG" download package
Let the download complete.
Follow this video to install the MySQL server on your Windows workstation.
REMEMBER: The root password is 'ics4u2020'
If you need the Microsoft C++ Redstributable, click here and download and install it. Retry MySQL install.
Follow this video to install the MySql server on your MacOS workstation.
REMEMBER: The root password is 'ics4u2020'
The course database load file is here. Download it before proceeding to the next step.
Download the TablePlus TRIAL app from this website for your operating system.
Follow this video to install the Windows TablePlus app that you will use to load the course database.
Follow this video to install the MacOS TablePlus app that you will use to load the course database.
You may now begin the course.
Go to this link and REGISTER for the online course. It is FREE. You are AUDITING the course. Do not choose the Certificate/Verified version. We are doing the FREE version.
NOTE: There are two files that the instructor talks about; Schema.sql and Data.sql.
You may LOOK at the contents in these files BUT
YOU HAVE ALREADY LOADED YOUR DATABASE!!! DO NOT RELOAD THESE FILES!!!
Lecture Adjustments based on MySQL
Table Variables and Set Operators
You will see two commands, 'union' and 'intersect'. These two commands are NOT supported by MySQL.
The instructor will provide alternative query demonstrations.
NOW - Let's Talk to SQL with Java
Follow this tutorial
Uninstalling mySQL from your computer.
Windows
MacOS
Note for Mac users. There may be a few commands that do not work. That's fine. They're old.