To get you started on learning SQL, we're going to use MySQL as the database. Note that what you're learning here can be applied very easily across all SQL family databases however.
As the first step, we can install MySQL to your computer. Note that all of these databases are just programs that you can install and run in your computer (just like downloading any other application and installing them in your windows or Mac). Just like you can install and run multiple applications on your computer, you can also install and run multiple databases in your computer.
Installing MySQL on a Mac
There are multiple ways to install MySQL in your computer. One of the popular ways is to use the homebrew package manager to install and initialize the required MySQL software (if you're using a Mac). Another way is to download the installer (for both PC and Mac). It's up to you how you install MySQL but go ahead and figure out a way to get this done.
Setup and Import
To get you started on learning SQL, we're going to use MySQL as the database. Note that what you're learning here can be applied very easily across all SQL family databases however.
As the first step, we can install MySQL to your computer. Note that all of these databases are just programs that you can install and run in your computer (just like downloading any other application and installing them in your windows or Mac). Just like you can install and run multiple applications on your computer, you can also install and run multiple databases in your computer.
Installing MySQL on a Mac
There are multiple ways to install MySQL in your computer. One of the popular ways is to use the homebrew package manager to install and initialize the required MySQL software (if you're using a Mac). Another way is to download the installer (for both PC and Mac). It's up to you how you install MySQL but go ahead and figure out a way to get this done.
Resources that may be helpful: