Workshop on databases and SQL. See the top menu for specific topics.
View the Project on GitHub berkeley-scf/scf-databases-2022
This project is maintained by berkeley-scf, the UC Berkeley Statistical Computing Facility
Hosted on GitHub Pages — Theme by orderedlist
Alternatively, if you have an SCF account you can plan to use one of the SCF machines via ssh or the SCF Jupyterhub.
If you’d like to be able to replicate the demo I do of creating a PostgreSQL database, you’ll need to install PostgreSQL on your computer. (This is completely optional and you will be able to follow my demo without this.) Probably the easiest way to enable this is to install Docker, which will allow you to start up a Linux virtual machine on your laptop. See the Mac instructions or the Windows instructions for how to install Docker. We’ll set up PostgreSQL within Docker during the workshop.
For replicating the demo of creating a database (either in SQLite or PostgreSQL) please download and unzip this file containing raw data files.
The tabs at the top will guide us through the material to be covered in the workshop. We’ll primarily be accessing the material in the SCF Databases tutorial, interspersed with time to work on SQL practice problems.