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.
На этой странице сайта вы можете посмотреть видео онлайн Tutorials - Simon Willison: Data analysis with SQLite and Python длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь PyCon US 02 Июнь 2023, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 9,527 раз и оно понравилось 177 зрителям. Приятного просмотра!
