Intro To SQLite Databases for Python Programming

Learn Sqlite Database With Python The Fast and Easy Way!

What's Inside

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

Get started now!



Certificate Available
44716+ Students
23 Lectures
1+ Hours of Video
Lifetime Access
24/7 Support
Instructor Rating
John Elder

John Elder is a pioneer in Internet Marketing 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.

Popular Bundles