SQL and Python: The Workshop

Learn about SQL, relational databases and how to use them from Python, in our hands-on workshop at our May 2022 meeting.

Following on from last month’s talk (https://www.meetup.com/Python-North-West-Meetup/events/284555813/),
we’ll be exploring SnakeReads (definitely not a rip off of goodreads.com). Our very own place to keep track of books we’ve read and reviews we have, stored in a sqlite database. Learn how to write your own SQL queries to view and edit this data, and how to run the queries using Python. Please note, this workshop will focus on the SQL and running it from Python, rather than “How do you write a website like goodreads”.

The workshop will be led by Jonathan Stott. Jonathan is Head of Data Engineering for Evergreen Life, and has been working as a data person for longer than he cares to think about right now. To distract himself from this, he tries to cycle a lot and go for long walks in the countryside.

To get the most out of the session, you'll need to join using a laptop/desktop rather than a tablet. We’ll be using SQLite Browser (https://sqlitebrowser.org/) for our SQL queries and viewing the SQLite database. There are install instructions on the website if you’d like to get it set up ahead of time. You’ll also need a Python environment and a code editor, such as Visual Studio Code.

Please note, this month we’re using Jitsi rather than Zoom. This can be used via the browser.