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
Watch video SQLite3 Tutorial - Learn SQL for Python in 17 Minutes online, duration hours minute second in high quality that is uploaded to the channel Thomas Janssen | Tom's Tech Academy 22 February 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 493 times and liked it 12 visitors.
