Python SQLite Tutorial: Build a Python project with a SQLite database

Learn how SQL works from the ground up and how to use SQLite from your Python apps in this complete Python SQLite Tutorial!

In this video, we build a Python project that uses a SQLite database to store data. We also look at how SQL simplifies inserting, retrieving, and searching for data.

0:00 - Video Introduction / What to Expect
0:30 - Overview of SQLite & Databases
1:10 - A database for a Coffee Preparation App
2:05 - A Table's Composition
2:48 - How to create a table in SQL
4:48 - Inserting data into the database
5:52 - Selecting data from the database
7:47 - Filtering your data
8:19 - Sample Query
9:16 - Group by Clause
10:50 - Accessing data in Aggregate
12:55 - Coffee App Introduction
13:14 - PROJECT START - Preparing the app's database
16:31 - Coding the app
36:05 - Conclusion

-- Links --

[erkayberkant]

I watched many tutorials about Sqlite, but the way you teach this, is really the best.

[aurontz]

I've view many many tutorials on sqlite3 with python. None of them compare to this. Thank you so much. Subbed!

[beybey]

As a coffee and coding lover, i had the BEST 37 minutes for today

[augurelite]

What a fantastic tutorial! Worth every minute. As a mostly self-taught beginner programmer, I feel like I learned some really good coding practices too! Thank you so much

[jawadmansoor]

After seeing a tons of videos on SQL I say this is the BEST tutorial of all times about SQL. Subscribed and liked.

[AlexanderColaneri]

Very good, thank you for your content! I had to put the video speed to 0.75 while working on my project, to clearly understand everything, and it worked out.

[novicetech]

I'm a latecomer to the party, but this was a very good tutorial. I learned a lot. I will review this code carefully and try to implement this approach any time I need a database. Excellent stuff. Thanks.

[zukofire]

thanks for this Teclado, very helpful in the context of my internship at a start up!

[naveenkumarthangavelu]

Thank you so much for this course. Apart from SQLITE. I also learnt more about how to call the function and arguments.
It was so crisp and easy to understand . Thank you much for this video

[notsaeed]

Thank you so much. This was the only helpful resource I could find.

[roybarretto]

This is an awesome video lesson (not coffee bean). Brief and simple but clear and easy to understand. Thanks. Will put this code into GUI as a tkinter project. Gracias.

[sobiralimov]

Wooooww. It's amazing course for me. I enjoyed and learned much. Thanks for all!

[kpresident]

Great video! One of the best about python and sqlite!Thank you so much!

[stevemorse]

Thanks for a great tutorial.

The only problems I had was the interface device between the chair I was sitting on and the computer keyboard.
I do not think the 3 beers and a large vodka tonic had anything to do with it!.
I got the whole thing done in less than 2 hours, including my errors.

Thanks again.

[moeezabdul]

Absolutely, a Beauty of a Video Honestly!

Really Appreciated Your Knowledge & Support on this!

Liked & Subscribed!

[Motivation_into_coding]

Thanks my brother man, I have a task to submit for bookstore which will allow to update delete search an add using sqlite3 with menu to display with the input using function, u help me a lot by following this video

[meylyssa]

Thanks for clear and understandable explanations!

[leonardofreitas]

This video is excellent! All very well explained. Thanks for sharing!

[aabhaskrjha]

Both on udemy and YouTube you're a rockstar.

[foucault]

Excellent video. Muchisimas gracias José!