Python SQLite Tutorial: Complete Overview - Creating a Database, Table, and Running Queries

In this Python SQLite tutorial, we will be going over a complete introduction to the sqlite3 built-in module within Python. SQLite allows us to quickly get up and running with databases, without spinning up larger databases like MySQL or Postgres. We will be creating a database, creating a table, insert, select, update, and delete data. Let's get started...

The code from this video can be found at:

✅ Support My Channel Through Patreon:

✅ Become a Channel Member:

✅ One-Time Contribution Through PayPal:

✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot

✅ Corey's Public Amazon Wishlist

✅ Equipment I Use and Books I Recommend:

▶️ You Can Find Me On:

#Python

[JMEPatterson]

You had me at "SQLite is actually part of the standard library"!

[tictoktrending]

The Award of "Best sqlite tutorial on YouTube " goes to Corey Schafer 👏👏👏

[IyamwhoIyam]

You are very clear and your approach is spot on. Keep it up! We need you!

[michaelfresco]

You really cannot ask for a better tutorial than this. Absolutely fantastic. I like it how Corey pickups up the pace a bit at the end, and also gives us some practical functions, which show you how you'd use this in real life.

[starkarma]

I am usually shocked if the best Python tutorials on, well, anything, can't be found on your page. You are an amazing teacher with great talent. Thank you for all your work.

[basetroll]

No book can replace your fantastic videos! For years(embarrassing) I've put all my data into huge arrays because I had horror of databases. With your video, so clear and understandable presented, I will now dive into it.

[Luis_Fernando_Pouliot_Madero]

You teach so many things in only 29 minutes, so clear. Voice, image, sound, simplicity, direct to matter. Great! ☑☑☑☑☑

[devrubic]

One of the best tutorials ever. After a long time I wasn't confused on learning something new and wasn't also bored to leave it! AWESOME

[VictorMongi]

This tutorial is a Gem, seriously.... God Bless You Corey... keep making great stuff mannnn....

[PaoPaw]

My man teaching not only how to do the basic stuff but also what we can apply on a real world project (security, best practices etc.) you're the best.

[BeeBee--]

I had to pause this vid midway to watch your OOP Tutorials 1 and 2. Your videos are consistently well-made that I could bounce off different tutorials and easily integrate them with the current lesson. Kudos!

[khan]

That was exactly any newbie Pythonian could ask ! I feel like I have completed my whole uni semester in 29 minutes. Thanks mate !

[vvqwvjv]

Mr. Shafer, thank you very much for your tutorial. It's so clear and enlightening. I rewrote one of my script using SQLite to store records and query, which is more efficient than my previous approach (to store data in excel via openpyxl and search cell from the whole worksheet). Much appreciated.

[amyst]

Simply one of the best Python tutorials out there, so good it forced me to put my first comment out here :) ... thank you Corey!

[drakZes]

I LOVE YOU, finally someone who explains their code and not only code so we can actually understand it. THANK YOU SO MUCH!

[jerwinsamuel]

Clear choice of words. Your teaching skills are amazing.

[shanerigsby]

So glad I found this video as my first look at SQLite--perfect level of instruction. Hoping to find a bunch more from you.

[Brandon-bmhp]

I love your videos
They do not turn into a big mess like others they get straight to the point like it should be!

[-sahlamahla]

You're a hero!
I love the way you explain things.
Thanks a lot

[imnodl]

Thank you so much for making my life so much easier, I had no idea you could use triple quotes to write multiple line strings without having to use '/n'. This greatly improved my code's readability. Also, thanks a bunch for all of these free tutorials, they're absolutely fantastic!