In this Python Video Tutorial, I will show you how to create databases using the Python SQLite module. SQLite is great because it:
- Provides most of the basic database structure you want
- Doesn’t require you to have an actual database server running
- Provides SQL querying capabilities
- Is included with Python by default
You enter and retrieve information from an SQLite database just like you do with any other database, by using SQL. Here is a tutorial on how to program with SQL if you don’t know how SQL Statements Video Tutorial. In that tutorial I focus on MySQL, but everything a say about SQL is nearly identical.