SQLite3 Tutorial - Learn SQL for Python in 17 Minutes

Do you want to learn how to use SQL in Python? In this video you learn CRUD: Create, Read, Update and Delete rows with Python! We build a console application which lets you manage a database.

SQLite3 is the database we'll be using - and it's already part of Python 3, so you don't need to install it!

⭐️ Scroll through the video ⭐
00:30 - Build a basic console application
04:05 - Download and install DB Browser for SQLite3
04:48 - Designing the database
06:29 - Import SQLite3 and connect to the database
07:44 - Adding rows to the database with CREATE
11:22 - Changing rows in a database with UPDATE
13:28 - Deleting a row from a database with DELETE
14:20 - Reading rows from a database with SELECT

⭐️ Download DB Browser for SQLite3 ⭐

⭐️ Download the source code ⭐

⭐️ Follow me ⭐

❗ Some of my videos contain affiliate links. When you click on these kind of links, I get a small percentage in case you make a purchase via the website. Be aware that this doesn't cost you anything - you never pay more than the standard retail price.

#python #sql #sqlite3 #database