... | @@ -7,25 +7,25 @@ the title of SQL Alchemist. |
... | @@ -7,25 +7,25 @@ the title of SQL Alchemist. |
|
|
|
|
|
2. Execute the script
|
|
2. Execute the script
|
|
|
|
|
|
/opt/Uebungen/DatabaseLab/setup.sh
|
|
`/opt/Uebungen/DatabaseLab/setup.sh `
|
|
|
|
|
|
3. Execute
|
|
3. Execute
|
|
|
|
|
|
source ~/.bashrc
|
|
`source ~/.bashrc `
|
|
|
|
|
|
4. Navigate to the folder for this lab:
|
|
4. Navigate to the folder for this lab:
|
|
|
|
|
|
cd /home/lab/local-data/DatabaseLab
|
|
`cd /home/lab/local-data/DatabaseLab `
|
|
|
|
|
|
5. Create and activate virtual environment
|
|
5. Create and activate virtual environment
|
|
|
|
|
|
conda create --name labEnvironment python=3.6 sqlalchemy sqlite pandas numpy matplotlib
|
|
`conda create --name labEnvironment python=3.6 sqlalchemy sqlite pandas numpy matplotlib`
|
|
|
|
|
|
7. source activate labEnvironment
|
|
` source activate labEnvironment`
|
|
|
|
|
|
8. Start notebook server
|
|
8. Start notebook server
|
|
|
|
|
|
jupyter notebook PythonSQL_Lab.ipynb
|
|
`jupyter notebook PythonSQL_Lab.ipynb `
|
|
|
|
|
|
9. Copy the link with the token and paste it into the browser’s address
|
|
9. Copy the link with the token and paste it into the browser’s address
|
|
bar
|
|
bar
|
... | @@ -59,20 +59,20 @@ Let’s verify that everything is working. |
... | @@ -59,20 +59,20 @@ Let’s verify that everything is working. |
|
2. List all installed packages and verify that sqlalchemy, sqlite3,
|
|
2. List all installed packages and verify that sqlalchemy, sqlite3,
|
|
pandas, numpy and matplotlib are installed
|
|
pandas, numpy and matplotlib are installed
|
|
|
|
|
|
conda list
|
|
`conda list`
|
|
|
|
|
|
3. Check that the Python version of the virtual environment is indeed
|
|
3. Check that the Python version of the virtual environment is indeed
|
|
3.6
|
|
3.6
|
|
|
|
|
|
python -V
|
|
`python -V`
|
|
|
|
|
|
4. Open the interactive Python interpreter
|
|
4. Open the interactive Python interpreter
|
|
|
|
|
|
ipython
|
|
`ipython`
|
|
|
|
|
|
5. Print something
|
|
5. Print something
|
|
|
|
|
|
print("Something")
|
|
`print("Something")`
|
|
|
|
|
|
If everything is set up correctly, you should see the print statement’s
|
|
If everything is set up correctly, you should see the print statement’s
|
|
output in the terminal. Now that all is set up, you are ready for the
|
|
output in the terminal. Now that all is set up, you are ready for the
|
... | | ... | |