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 ⭐
🔗 https://sqlitebrowser.org/
⭐️ Download the source code ⭐
🔗 https://tomstechacademy.com/code-exam...
⭐️ Follow me ⭐
💼 LinkedIn: / thomas--janssen
✅ Instagram: / tomstechacademy
❗ 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
