Getting Started with SQLite for Python

SQLite is a really cool little file database that comes bundled with Python, giving you a very powerful platform to work with relational data, locally on your computer, without any need for a database server. This is particularly important for data projects involving many data sources where you need to have some persistence to the data you gathered. Because it is bundled with Python, you don't need to install anything to start using SQLite. We'll create a database, create a new table, insert some data, and then query that data and return it for display in our console. Easy!

Related Videos:
Getting Started with SQLite for Python
You are watching this video now!
How to Execute SQL from a File on SqLite Using Python
How to Select Data from SQLite
How to Output HTML from SQLite
Migrate Data from MS Excel to SQLite and Back Again
How to Use Dates in SQLite
How to Create a Delimited Field in your SQLite Query with Python
How to Make an Interactive Map Using Python and SQLite Data

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

[fraserrankin]

I was wondering if there ever was a video posted for an in memory database?

[larrycash]

I was wondering if a video was available on csv to sqlite3 inserting

[l.kennethwells]

I know I'm a couple years late but thanks for your videos. Question: We use MSFT 365 and I have MS Access is that something to look into, also being we have sharepoint as well? Thank you