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
On this page of the site you can watch the video online SQLite3 Tutorial - Learn SQL for Python in 17 Minutes with a duration of hours minute second in good quality, which was uploaded by the user Thomas Janssen | Tom's Tech Academy 22 February 2024, share the link with friends and acquaintances, this video has already been watched 493 times on youtube and it was liked by 12 viewers. Enjoy your viewing!
