BuildingBloCS Database Workshop 2024

In this workshop, we’ll look at the fundamentals of databases using SQLite, practice SQL commands, and integrate SQLite into Python.

By the end of this workshop, you will:

• Understand basic SQL commands (CREATE, SELECT, INSERT, DELETE, UPDATE)
• Use SQLite to build and manage a database
• Integrate SQLite into a Python program using sqlite3
• Use DB Browser to visualize and manipulate databases

Getting Ready

Make sure you:

• Install DB Browser and VSCode.
• Have Python 3.x ready.

To download the sample CSV files and the notebook, you can clone this repository:

git clone https://github.com/buildingblocs/database-workshop-2024.git

Alternatively, you can download the ZIP file by clicking on the green Code button above.

Downloading the Tools

You will need to download DB Browser. DB Browser is a GUI tool for working with SQLite databases. It allows you to create, view, and manage databases with ease.

You will also need to download Visual Studio Code (VS Code) for working with Python and SQLite.

👉 Download DB Browser here
👉 Download VS Code here

Setting Up

Ensure you have Python 3.x installed on your system. 👉 Download Python

Then, run the following command to check if Python is installed:

python --version

SQLite is bundled with Python, so no additional installation is required!

Happy Coding! 🎅

If you have any questions during the workshop, don’t hesitate to ask our facilitators.