Intro To SQLite Databases for Python Programming (Udemy.com)
Learn Sqlite Database With Python The Fast and Easy Way!
Created by: John Elder
Last updated November 2023
What you will learn
- Understand how to use SQLite Databases With Python
- Understand the basics of what a Database can do.
- Install Python, SQLite, Sublime Text, and Git Bash
- You'll Learn How To Create a Database and Table
- How to put data in and take data out using Python
- How to update and delete data from the database
- How to explore what's in the database whenever you want
- How to create basic reports with the data from your database
Course Description
These days everything uses a database, and SQLite is one of the most popular databases out there. FREE and Open Source, SQLite is a great database for smaller projects, hobby projects, or testing and development.
Likewise, Python is one of the most popular and powerful programming languages today. Pairing the two together is a powerful combination!
In this course you'll learn the basics of using SQLite with Python.
You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.
For this courses I'll assume you already have a basic knowledge of Python programming, but you don't need to know anything at all about databases or SQLite to take the course.
You'll learn...
What Is A Database
How To Install Python
How To Install Git Bash Terminal
How To Use SQLite in a Python Program
How To Connect to Database in Python
How To Create A Database
How To Create A Table
How To Insert One Record Into Table
How To Insert Many Records Into Table
Understanding Data Types
How To Select Data From Table
How To Format Your Results
How To Use The Where Clause
How To Use The Like Clause and Wildcards
How To Use AND and OR
How To Update Records
How To Limit and Order Results
How To Delete Records
How To Delete (Drop) A Table And Backups
And More!
At the end of the course we'll build a very basic app to help reinforce all the things we learning along the way.
I'll walk you through all of this and more, step by step. If you have any question along the way, I'm here to answer them.
If you've ever wanted to understand SQLite databases or use them in your Python programs, this is the course for you.
We'll download everything you need for this course for free, you don't need any special tools!
I'll see you on the inside!
-John Elder
Instructor Details
- 4.5 Rating
773 Reviews
John Elder
John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.
Today he teaches Web Development courses at Codemy the online code school he founded.
John graduated with honors with a degree in Economics from Washington University in St. Louis where he was an ArtSci Scholar.
More courses by John Elder
Intro To PostgreSQL Databases With PgAdmin For Beginners (2023)
4.5 (7,751 Reviews)
Provider: Udemy
Time: 2h
$54.99
Build An API With The Django Rest Framework Using Python (2023)
4.5 (1,229 Reviews)
Provider: Udemy
Time: 1.4h
$54.99
Top Node and Javascript Bundle: Learn Node and JS (2023)
4.3 (1,126 Reviews)
Provider: Udemy
Time: 8.2h
$11.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Akhil Ashok on 3/6/2026
The great thing about this course is that it doesn't waster your time. Here the instructor teaches the essentials that needed to jump into the projects that we are building and the way the practical explaination was given is excellent. Must Try this course
By Bcrum on 12/9/2025
It was a nice quick way to get started using sqlite in python. I was looking for a fast way to get acquainted with SQL to use it in a simple python project and this may be enough for my purposes. Thanks!
By Alberto Navarrete Peón on 9/4/2024
Very basic and to the point, but useful information that is clearly explained. I have no interest in developing through sublime text, but on visual studio, and I struggled at first to create the databases. Nonetheless, a little googling resolved the issue.
By Anonymized User on 8/20/2023
Easy to watch and informative. Some fundamental database concepts are just skipped, such as the cursor, but can easily be learned from other sources. I believe it would be interesting to include a sample of reading multiple large CSV files into a database, e.g.. Thank you for putting the course together.
By Jeffrey Ballinger on 7/15/2022
This is a great primer going into incorporating SQL with your python code. sqlite3 is free and comes with python, so just natural to tackle this maybe after you learn python basics. The course can be completed in a day, but you'll learn enough to write something useful. If you are reading this, get the course already. There is a nice bonus at the end too.
By Anonymized User on 11/14/2021
Really good fast coruse, if you know the python basics and you need understand very fast, how works with sqlite, this is the course to do, the instructor is very good and dont waste time in complex explanation, just the necessary to you have a grasp and understand how to start.
By Tyler Vidricksen on 5/24/2020
This was nice little course. It's quick and to the point. If you are a beginner python coder and are just beginning to dabble in SQL, starting here is a good idea. .You'll learn how to execute basic CRUD operations and learn how to call them inside functions. I do wish the course was a little longer though. The course is far from complete. There are several more topics in the python docs I wish were covered here (since the docs are cryptic for a newbie)... that said, the course is good enough to get me started.
By Aashish Kumar on 2/5/2020
The lectures were very much comfortable to understand and were full of knowledge. This is kind of an introduction to SQLite3 with Python course so do not expect a lot from this course. But if you want to begin with SQLite3 in Python, it's a worthy course to take. Thanks!
By Einar Wedoe on 1/15/2020
Great stuff for a newcomer as I am to SQLite. This was excatly what I needed. The only reason for the last star being half, is that I feel the course could have covered a few more functions. But as an intro to Python and SQLite this is a good as it gets!! :-)
By Andreas Brunn on 6/15/2019
Very basic course. If you already know some basic SQL commands there is not so much new you can learn in this course. It's basically just the same python code in every video (connect to database, execute SQL and print out the results) and the SQL commands are exactly what you would use with any other SQL database. Well, it's not claiming to be an intermediate or advanced course, but I was hoping for a little more elaborated videos. To sum up: If you have never used any kind of database yet, you may benefit from this course. But if you already got in touch with any flavour of SQL there is nothing new in here.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100












