Skip to content
UdemySqlPaid courseBeginner levelCertificate

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

icon
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

icon
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



icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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. 

icon
More courses by John Elder

$54.99

$10.99

$54.99

$11.99

$11.99

$13.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.5

773 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 773 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100