Introduction to SQL
A workshop on getting started with SQL for non-developers.
-
No prior programming experience required. The workshop is designed for beginners and non-programmers.
-
Learn SQL using hands on approach. You will not only learn some theory but get to write SQL queries alongside.
-
To get the most out of the workshop, it is recommended to bring a laptop, with the required software installed, or at least downloaded.
All demos during the workshop are conducted on a Mac. If you use Windows or another operating system, you can still follow along. However, it is recommended that you install the required software beforehand.
Software required
MySQL Server
The SQL Database Server used to store data and capable of running SQL Commands that we write in a client.
Download & Install
MacOS / OSX:
MySQL Community Server installer v8.0.16 (.dmg)
Windows:
MySQL Server & Other tools installer v8.0.16 (.msi)
Other OS:
Download MySQL Community Server
MySQL Workbench
The SQL client used to connect to the server.
If you prefer an alternate SQL client, it's fine. Just ensure you are able to use it to connect to MySQL.
Download & Install
MacOS / OSX:
MySQL Workbench installer v8.0.16 (.dmg)
Windows:
The previous installer should have options to install Workbench too.
However if you need to install it separately, install all of these in sequence:
Visual C++ Redistributable for Visual Studio 2015
MySQL Workbench for Windows installer (.msi)
Other OS: