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

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

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

FavoriteLoadingAdd 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

By |2020-05-06T03:26:40+00:00May 6th, 2020|Python Video Tutorials|5 Comments

5 Comments

  1. Kite May 6, 2020 at 3:26 am - Reply

    Like this tutorial? Join the Kite Developer Community on Facebook for access to more resources + support from fellow Python developers. Time to level up! https://www.facebook.com/groups/505658083720291

  2. Eric Trautmiller May 6, 2020 at 3:26 am - Reply

    I've been using Python for over a year and I never realized it had a built in database. Thanks for posting this!

  3. Viet Dinh-Van May 6, 2020 at 3:26 am - Reply

    I know this. This is the first experiment

  4. Satyamani Srivastava May 6, 2020 at 3:26 am - Reply

    Can you make a video on kivy ( python library)

  5. Kite May 6, 2020 at 3:26 am - Reply

    Let us know what other topics we should cover! Thanks for watching [:

Leave A Comment

*