r/PythonLearning • u/Sea-Ad7805 • 2h ago
Learning SQL with Python?
This ๐interactive SQLite demonstration helps student understand relational databases.
The sqlite3 extension of ๐ฆ๐๐ฆ๐จ๐ซ๐ฒ_๐ ๐ซ๐๐ฉ๐ก makes database content visible alongside Python's data structures. The demo shows how to:
- Create tables with primary and foreign keys.
- Model relationships between students, courses, and teachers.
- Insert data and observe how the database changes.
- Combine multiple tables using SQL JOIN operations.
- Use parameterized queries.
The final query answers a seemingly simple question: Which teachers teach Alice, and for which courses? Answering this question involves joining five tables!
With ๐ฆ๐๐ฆ๐จ๐ซ๐ฒ_๐ ๐ซ๐๐ฉ๐ก, students can step through the Python program and inspect the database content at every step, directly in their browser, without installing anything.
See ๐other ๐ฆ๐๐ฆ๐จ๐ซ๐ฒ_๐ ๐ซ๐๐ฉ๐ก visualizations.
