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

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=referral&utm_source=youtube&utm_campaign=kite&utm_content=sqlite-3-intro

JOIN our online community of people who want to level up their developer skills ►
https://www.facebook.com/groups/505658083720291/

Subscribe ► https://www.youtube.com/c/KiteHQ?sub_confirmation=1

***************************************
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 ►
https://www.youtube.com/watch?v=MWYRGLKMzAQ

Web Scraping Baby Yoda ►
https://youtu.be/RkaHdOje-cI

Best IDEs for Python ►
https://www.youtube.com/watch?v=f7vJzFgUorc

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

STAY TUNED:
Kite ► https://kite.com/
YouTube ► https://www.youtube.com/channel/UCxVRDu9ujwOrmDxu72V3ujQ
Twitter ►https://twitter.com/kitehq

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

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