How to Use SQL with Python! (CREATE, INSERT, READ/SELECT, UPDATE and DELETE)
In this video we cover using Structured Query Language (SQL) with Python and the sqlite3 module! SQL is the most common database language and python supports doing many SQL commands and actions right inside of python files! This tutorial shows how to connect to a database or create a new one, create a new table, insert data into the table, select data from the table to read in python, update records that need to be changed, and delete records that need to be removed!
The code covered in this video is available here:
https://github.com/plemaster01/PythonSQL
Please consider becoming a super channel supporter here!
/ lemastertech
Don't forget to leave a like on the video, subscribe to the channel, and comment what you'd like to see next! Thanks for watching!
TIMESTAMPS:
00:00 Introduction and SQL/Python Background
01:06 Use Python to Create a SQL databases and tables
07:15 How to Insert SQL Data into Tables Using Python!
12:07 How to Read (SELECT) Data from SQL databases with Python!
14:48 How to Update SQL Data in Python Programming!
17:56 How to Delete Records of Data from SQL Tables in Python!
20:03 Using Python to Remove Duplicate Data Entries from a SQL Table
