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

Next video – drawing graphs and charts with matplotlib: https://youtu.be/D59J_oAGXxQ

— Links —

✅ Subscribe to the channel: https://www.youtube.com/tecladocode?sub_confirmation=1

✅ The Discord server: https://discord.gg/78Nvd3p

✅ Twitter: https://twitter.com/tecladocode

✅ Instagram: https://instagram.com/tecladocode

✅ Facebook: https://facebook.com/tecladocode