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

Add to favorites

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.

Download Kite free:

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

Subscribe ►

***************************************
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 ►

Web Scraping Baby Yoda ►

Best IDEs for Python ►

***************************************
Be sure to subscribe for tutorials, project breakdowns and more!

STAY TUNED:
Kite ►
YouTube ►
Twitter ►

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

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

source