Starting SQL by using Jupyter Notebook — Installations needed.
As a newbie to using SQL programming language, there are some tools/softwares that need to be installed to help you start writing your first SQL language. I would walk you through how to install this software on macOS and Windows.
To be able to write SQL, we need to install some packages. I would walk you through the installations on both OSs.
Windows installation steps
Step 1
We would install using the Anaconda GUI by visiting https://www.anaconda.com/products/individual.
Step 2
Download the version that suits your version of laptop specs (64-Bit or 32-Bit). Click on either 64-Bit or 32-Bit to download and install for Windows OS.
Step 3
Go to your download and run the installer downloaded. Follow the process to get the anaconda GUI installed and running.
Step 4
To run Jupyter Notebook, go to your start menu and search by typing Jupyter notebook. Click to run automatically the terminal runs and opens Jupyter notebook in you default browser (I prefer using chrome). You are all set to start learning SQL.
MacOS installation
This process can be simple and also time consuming. I have a challenge installing it though I was following the documentation. But let me walk you through how to install it on you MacOs.
Step 1
Make sure to have installed or python 3. Do not install using the default python 2 version on you MacBook as it is the default version used by the MacOs. You can do this by opening to your terminal and first check the version of your python. Type
python — — version
install python3 using pip (you may need to upgrade to pip3 before installing). If pip is not installed install pip.
pip3 install python3
Check for python3 version installed
python3 — — version
Step 2
If you are using MacOs Big Sur or Catalina, check if your newly install python has it’s path added to your .zshrc file. To do that, in your terminal, type
open ~/.zshrc
this would open the zshrc file for you. Check if you would find the PATH to your newly installed python3. This can be seen as this way
export PATH=/Users/<username>/Library/Python/3.8/bin:$PATH
If this is not present, type it below the default details as seen in the image above. Now you are good to install Jupyter Notebook.
Step 3
Install Jupyter notebook using pip. In your terminal
pip3 install jupyter notebook
You have successfully installed Jupyter notebook. Run your notebook by calling it in your terminal by typing
jupyter notebook
This would open your default browser to start running your notebook and start learning to code in SQL.
Note: Jupyter notebook is not only used to code in SQL but other languages as well such as python.
Kindly share, leave a comment and also reach me via my email: henry.mabakar@gmail.com.
