SJSU - Summer 2024 - Big Data & Generative AI

Session 2 - SQL Lab

Dr. Julien Pierret

Today's Agenda

  • Getting libraries in Python
  • SQL
    • SQLite
      • Setup
    • Database
    • Learning Basic SQL

Setup Instructions

  • Setup a Python 3.x venv (usually in .venv)
  • Install pip-tools mentioned earlier
    
                      pip3 install pip-tools
                    
  • Re-generate the requirements.txt file from the requirements.in
    
                      pip-compile --output-file=requirements.txt requirements.in
                    
  • Install the requirements
    
                      pip3 install -r requirements.txt
                    

requirements.txt


              

In Summary

  • SQL
  • Learn it!

See you at 1:30pm!

  • Questions?