Tutorials - Simon Willison: Data analysis with SQLite and Python

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.

[@jespasan]

Definitely a converted to SQLite now :) I had forgotten how powerful it is , and planning to use datasette to share with my team mates.
The presenter has amazing teaching style and obviously so knowledgeable and experienced that can bat any demo demons or free-styling based on audience questions without change of tone of voice or change of pace… seamlessly weaving it into the tutorial. I reckon I can get my very python/sql newbies colleagues to seat through this almost 3h presentation to get an all in one intro to using data and leave excited about the possibilities … all looks so easy :)
Many thanks

[@ehza]

Simon is a co-creator of the Django Web framework!

[@senpos]

This is gold. Thanks for the tutorial!

[@facundolopez1792]

Excellent presentation! Thank you Sir.

[@gw1284]

Thank you, going to play with it