SQLite3 Tutorial - Learn SQL for Python in 17 Minutes

Thomas Janssen · Intermediate ·📐 ML Fundamentals ·2y ago

Key Takeaways

Builds a console application using SQLite3 and Python to manage a database

Original Description

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
Watch on YouTube ↗ (saves to browser)
AI explanation not available for this lesson yet
This lesson is still being prepared for the AI tutor. In the meantime, explore lessons that are ready.
Browse explainer-ready lessons →

Related Reads

📰
Stop Being Intimidated by Machine Learning. Read This Instead.
Demystify machine learning basics by understanding weights, biases, loss functions, and optimization without relying on black-box libraries
Medium · Machine Learning
 📰
My First Kaggle Competition: 690K Rows, 6 Engineered Features, and a Tuning Result That Kept Me…
Learn from a beginner's experience in a Kaggle competition, including data preparation and model tuning, to improve your machine learning skills
Medium · Machine Learning
 📰
Machine Learning Pipelines Explained Without Putting You to Sleep
Learn the basics of machine learning pipelines and how to apply them in real-world scenarios to improve model performance and efficiency
Medium · Machine Learning
 📰
The Embedded Systems and Robotics Roadmap
Learn the essential steps to get started with embedded systems and robotics, from basics to advanced topics, and accelerate your career in this field.
Medium · Programming

Chapters (8)

0:30 Build a basic console application
4:05 Download and install DB Browser for SQLite3
4:48 Designing the database
6:29 Import SQLite3 and connect to the database
7: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
Up next
Layer Norm is Just a Direction
DataMListic
Watch →