Tutorials - Simon Willison: Data analysis with SQLite and Python

Simon Willison teaches how to use SQLite, sqlite-utils, and Datasette to explore, analyze, and publish data.

SQLite is the world's most widely used database and has been a part of the Python standard library since 2006. It continues to evolve and offer more capabilities every year. This tutorial will transform you into a SQLite power-user. You'll learn to use SQLite with Python, level up your SQL skills and take advantage of libraries such as sqlite-utils and tools such as Datasette to explore and analyze data in all kinds of shapes and sizes. This hands-on tutorial will cover: - The sqlite3 module in the Python standard library - A review of SQL basics, plus advanced SQL features available in SQLite - Using sqlite-utils for advanced manipulation of SQLite databases - Datasette as a tool for exploring, analyzing and publishing data - Applying the Baked Data architectural pattern to build a data application using Datasette and deploy it to the cloud This tutorial is aimed at beginner-to-intermediate Python users with some previous exposure to basic SQL. Attendees will leave this workshop with a powerful new set of tools for productively exploring, analyzing and publishing data.