Sqlite Backend for Beginners – Create Quick Databases with Python and SQL

Sqlite, is a library known for its quick and simple databases.

With the help of Python, we will cover all the basics of creating databases, tables, inserting data into those tables, selecting and fetching database rows, searching data within the database and manipulating this data inside our code. All this – in less than 15 minutes!!! 🤩

Time stamps:

  • 00:00 – Intro
  • 00:27 – Starter Code Overview
  • 00:51 – Create Empty Sqlite Database with Python
  • 02:37 – SQL Cursor Object
  • 03:02 – Create Database Table
  • 03:42 – Sqlite Data Types
  • 04:14 – Insert Multiple Rows of Data Into a Table
  • 06:03 – Select and Print All Database Rows
  • 06:47 – Select Specific Rows with Specific Values
  • 08:29 – Combine Multiple Database Tables
  • 11:06 – Manipulate Data Fetched from Database
  • 13:04 – Coming Soon and Thanks for Watching! 🙂

Frank

#DataScientist, #DataEngineer, Blogger, Vlogger, Podcaster at http://DataDriven.tv . Back @Microsoft to help customers leverage #AI Opinions mine. #武當派 fan. I blog to help you become a better data scientist/ML engineer Opinions are mine. All mine.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.