Intro To SQLite Databases for Python Programming

Learn Sqlite Database With Python The Fast and Easy Way!

4.37 (568 reviews)

Udemy

platform

English

language

Databases

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

Why take this course?

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

Screenshots

Intro To SQLite Databases for Python Programming - Screenshot_01

Intro To SQLite Databases for Python Programming - Screenshot_02

Intro To SQLite Databases for Python Programming - Screenshot_03

Intro To SQLite Databases for Python Programming - Screenshot_04

Reviews

David

December 11, 2023

Just wish this course had gone into a bit more depth in terms of how to structure multiple databases/tables. Other than that, went through all the basics very efficiently.

Dan

December 4, 2023

It is OK, but is it for someone who has never touched a database before and knows zero SQL. I was looking for in-depth usage of sqlite in terms of python

November 22, 2023

For me it was a refresher course for SQLite and the SQL language. It is straight foreward. That makes it fast, exactly what I want. The app example could be a little more sophisticated, its more like a repetitition of the single steps. Why not.

September 28, 2023

I rarely give a course such low rating, but after I read instructor's response, I decided to do so. This course is on Youtube for free, and one of the student has already listed on the review section. The instructor responded that this course teaches everything we need to know to use sqlite as a database is so wrong. The information is sufficient to use sqlite as a SINGLE TABLE, and there is no information on using 2 tables (joining search), performance etc. You generally would learn more from geeks for geeks when you reading through their articles on python sqlite. I think this instructor just made this course to advertise his own site.

Anonymized

August 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.

Don

March 10, 2023

as someone with mid level Python and very rudimentary sql skills, I appreciated that we went over the steps several times. That's how I learn. Do the examples with him.

Msk0B2P

September 14, 2022

Good course, easy to follow. Would've preferred a more in depth tour on SQLite and why it is advantageous over other Databases.

Christina

August 2, 2022

This course is exactly what I expected if not better. It's simple, he explains the material great without wasting time like a lot of instructors do. Highly recommend!

Jeffrey

July 16, 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.

Manish

July 1, 2022

Normally, I do not leave a bad review but this course is the worst. There are multiple issues - 1. This Course is available for free here. Exact same course and material - https://www.youtube.com/watch?v=byHcYRpMgI4&ab_channel=freeCodeCamp.org 2. Another issue is that the Instructor has not edited the unnecessary parts. Slow installation, downloads, etc all are kept as it is. The course can be easily reduced to just 30 minutes if he edits the unnecessary parts. Even the Instructor does not seem to be knowledgeable. He keeps on saying - "I don't know"... 3. The Instructor keeps on watching the other screen continuously where he has kept his notes and due to that he takes time to deliver and covers that with unnecessary stuff just to fill the time. How can this be the Best Seller Course? I request Udemy to see that if the course is available for free on Youtube, why would they tag it as Bestseller and ask students to pay for it. Please think before buying this course.

Tshering

June 17, 2022

It was a great course and I liked it, but the problem that I faced in it was running my codes and commands in cmd (git bash); it would not run in a same directory. So if it had been in a CMD or other code-editors (2021-2022) than it could have made things much easier, but thank you for your work. I learned a lot.

Andrea

June 14, 2022

I loved the course, as it was very easy to follow along to. I got stuck some times but it was easy to back on track. I recommend this course to anyone who is interested in learning about python.

Calvin

May 24, 2022

This course doesn't really teach SQLite. You are not going to learn any meaningful thing about SQLite. And what's point of mixing SQLite and Python. This course should be designed for SQLite only from command line. After thorough review of SQLite, then it should demonstrate same technique with Python.

Felix

November 15, 2021

Great course! The instructor explains concepts really well, and straight to the point. The videos were short, which made the learning process more enjoyable.

Edipo

November 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.

Charts

Price

Rating

Enrollment distribution

Intro To SQLite Databases for Python Programming - Distribution chart