comprehensive beginner's tutorial for python and sqlite?

Question

looking for a good tutorial for learning sqlite in python- with a focus on the sql, not the bindings

specifically, one that assumes no prior knowledge of sql

Answer 1

1. Python
2. SQLite and Using SQLite in Python

Answer 2

Here's a nice series of blog posts where the author develops a GUI-fronted database for bioinformatics using sqlite and wxpython.

Answer 3

Why you don't just use the sqlite3 class with-in Python?

chapter 11.6 in Python documentation