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-example-sqlite3-tutorial/ ⭐️ Follow me ⭐ 💼 LinkedIn: https://www.linkedin.com/in/thomas--janssen/ ✅ Instagram: https://www.instagram.com/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