SQL Masterclass for Data Scientists

This repo contains all of the presentation slides, Jupyter notebooks and also a quick-link to relevant Play With Docker instances for the SQL Masterclass session for the ODSC APAC 2021 virtual conference!

All PDF slides exist in slides/

TODO: All Jupyter Notebooks and SQL scripts used for the session live in code/

Local Docker Commands

To run the psql shell used for the optimisation session - you can run the following commands locally. Just make sure you have Docker installed otherwise this won't work!

docker run -d --rm --name="odsc-sql-docker" dannyma/odsc-sql:latest
docker exec -it odsc-sql-docker psql -U postgres

Play With Docker Stacks

You can use this live Docker PostgreSQL environment to copy and paste SQL code from the code/ folder directly here to see the outputs generated for the session.

Click on the buttons below to launch a Play-With-Docker stack - DockerHub login/signup is required but all batteries should be included!

👇👇👇 Make sure you right click and open the link in a new tab if you're viewing this on GitHub!

Once the initialisation steps are complete and you see Your session is ready at the bottom of the screen - might need to click just outside the initial popout window and press your esc key to close this window as the Close button is sometimes not working

Next you can either hit port 3000 to use a SQLPad GUI or you can run the following to enter a psql terminal instance:

docker exec -it `docker ps -aqf "expose=5432"` psql -U postgres

Below is a quick video that is used for the Data With Danny Serious SQL course - but the same process can be followed for this exact Docker instance, just ignore the final part where you see lots of tables on the left - you should only see 5 tables instead for our environment!

TODO: upload video here