User Tools

Site Tools


labs:sqlalchemy

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
labs:sqlalchemy [2017/05/18 17:35]
brunnegi
labs:sqlalchemy [2020/08/31 21:03] (current)
Line 4: Line 4:
  
  
-====== Lab Setup ======+===== Lab Setup =====
  
   - Open terminal   - Open terminal
-  - Execute <​code> ​./​opt/​Uebungen/​DatabaseLab/​setup.sh </​code>​+  - Execute ​the script ​<​code>​ /​opt/​Uebungen/​DatabaseLab/​setup.sh </​code>​
   - Execute <​code>​ source ~/.bashrc </​code>​   - Execute <​code>​ source ~/.bashrc </​code>​
-  - Navigate to the folder for this lab: <​code>​ cd local-data/​DatabaseLab </​code>​+  - Navigate to the folder for this lab: <​code>​ cd /home/lab/local-data/​DatabaseLab </​code>​
   - Create and activate virtual environment ​   - Create and activate virtual environment ​
   - <​code>​conda create --name labEnvironment python=3.6 sqlalchemy sqlite pandas numpy matplotlib   - <​code>​conda create --name labEnvironment python=3.6 sqlalchemy sqlite pandas numpy matplotlib
Line 20: Line 20:
  
  
-===== Getting Started ​=====+===== Verifying Setup =====
  
-Ubuntu comes pre-installed ​with Python 2 and 3. It can also easily be installed using apt-get. However, these are system wide installations that are used by all Python programs. Since Python heavily relies on external libraries, and not all libraries are compatible with all versions of Python, it is often necessary to use different versions of Python for different projects. Thus, the use of Virtual Environments is highly encouraged. Every virtual environment has its own Python distributions and installed libraries. This way, different projects can be cleanly separated. There are several tools to create and manage virtual environments. ​+Ubuntu comes with pre-installed ​distributions of Python 2 and 3. It can also easily be installed using apt-get. However, these are system wide installations that are used by all Python programs. Since Python heavily relies on external libraries, and not all libraries are compatible with all versions of Python, it is often necessary to use different versions of Python for different projects. Thus, the use of Virtual Environments is highly encouraged. Every virtual environment has its own Python distributions and installed libraries. This way, different projects can be cleanly separated. There are several tools to create and manage virtual environments. ​
 In this lab we will use [[https://​conda.io/​docs/​using/​envs.html|Anaconda]]. In this lab we will use [[https://​conda.io/​docs/​using/​envs.html|Anaconda]].
  
Line 38: Line 38:
 Now that all is set up, you are ready for the next step.  Now that all is set up, you are ready for the next step. 
  
-===== Jupyter Notebook ​=====+===== SQLAlchemy Lab =====
 As mentioned earlier, there are many ways to code Python. In this lab you will be introduced to Jupyter Notebooks. A powerful and convenient method for programming with Python. As mentioned earlier, there are many ways to code Python. In this lab you will be introduced to Jupyter Notebooks. A powerful and convenient method for programming with Python.
 We have already opened the notebook in the browser. ​ We have already opened the notebook in the browser. ​
 For the remainder of this lab, you will be working in the Jupyter Notebook. Just follow the instructions there. Have fun! For the remainder of this lab, you will be working in the Jupyter Notebook. Just follow the instructions there. Have fun!
 +
 +
 +
 +===== Python Experts Listen Up! =====
 +If you are already familiar with Python, you can skip the Tutorial in the Jupyter Notebook and scroll down to the actual lab exercises!
labs/sqlalchemy.1495121705.txt.gz ยท Last modified: 2020/08/31 21:03 (external edit)