Sqlite 3 Python Tutorial in 5 minutes - Creating Database, Tables and Querying [2020]

Опубликовано: 19 Февраль 2025
на канале: Kite

149,307

2.4k

Today, we’re going to cover how to create and edit tables within a database using SQLite in Python. In this tutorial, we’ll create a database to manage data about a retail business with a few different locations. We’ll be storing information about each of our retail stores that are located across three different cities. We’ll also create a way to log data about purchases from these stores.

⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. We made this YouTube channel and Kite to help you be more productive: https://kite.com/download/?utm_medium...

JOIN our online community of people who want to level up their developer skills ►
  / 505658083720291

Subscribe ► https://www.youtube.com/c/KiteHQ?sub_...

***************************************
Timestamps:

0:20 - What is SQLite?
0:45 - What uses SQLite
1:10 - Connection to db
2:00 - Create table query
3:00 - Select query
4:05 - Update and Delete

#sqlite #pythontutorials #python

***************************************
Additional Python Resources

Read and Write to CSV with Python ►
   • Python Tutorial - How to Read and Wri...

Web Scraping Baby Yoda ►
   • WEB SCRAPING Baby Yoda Pictures with ...

Best IDEs for Python ►
   • Best IDEs for Python

***************************************
Be sure to subscribe for tutorials, project breakdowns and more!
https://www.youtube.com/c/KiteHQ?sub_...

STAY TUNED:
Kite ► https://kite.com/
YouTube ►    / @kitehq
Twitter ►  / kitehq

***************************************
Keywords

postgresql python sqlite python python mysql sqlite3 python python mysql database connection tutorial