Intro To SQLite Databases for Python Programming

Name: Intro To SQLite Databases for Python Programming
Rating: 4.6 (765 reviews)

Learn Sqlite Database With Python The Fast and Easy Way!

Highest Rated

Created byJohn Elder

Last updated 11/2023

English

German [Auto],English [Auto],

What you'll 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 content

3 sections • 24 lectures • 1h 38m total length

Introduction3:32
First Things First: How To Get Support Fast!0:09
Check out my student Facebook Group...
It's a great place to get fast support for this course from me, to interact with other students, to post your projects and code, and to access course announcements and extras...
Join Now!
https://www.facebook.com/groups/codemycom/
Install Python3:27
Install Sublime Text And Git Bash Terminal4:43

Create SQLite Connection5:44
Import sqlite3, create a connection to a database file named customer DB (or an in-memory database), and run the python script to auto-create the database.
Create A Database Table10:32
Learn to create a sqlite3 table using a cursor, define a customers table with first name, last name, and email, and commit and close the connection.
Insert One Record Into The Table3:11
Insert one record into the customers table using the insert into command with first name, last name, and email values, executed by the cursor and committed after insertion.
Insert Many Records Into The Table3:14
Learn how to insert many records into a SQLite table using a Python list of customer tuples with placeholders, where each placeholder is a question mark.
Query and Fetchall2:20
Learn to query an SQLite database with a cursor, use select * from customers, fetchall (or fetchone and fetchmany), and print the resulting Python list to display records.
Format Results7:34
Learn to fetch one, fetch many, and fetch all results in Python using sqlite3, access tuple items, loop through rows, and format output with concatenation and tabs.
Primary Key ID3:12
Where Clause3:24
Update Records5:22
Delete Records1:42
Order Results By3:10
And / Or3:17
Limiting Results2:28
Drop Table1:46

Our App - Show All Function5:00
Our App - Add A Record Function3:33
Add a new record to the customers table by creating a connection and cursor, inserting values with placeholders, and committing. Explore deleting a record in the next video.
Our App - Delete a Record Function3:30
Our App - Add Many Records Function3:32
Our App - Where Clause Function4:20
Define a simple where clause function to select all customers where email equals a given value, then fetch and print matching rows for easy lookup.
Bonus Lecture10:10

Requirements

A Basic Understanding Of Python Programming Would Be Helpful
You don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computer

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

Who this course is for:

Anyone who wants to use the SQLite Database with Python

Intro To SQLite Databases for Python Programming

What you'll learn

Explore related topics

Course content

Installation4 lectures • 12min

Using SQLite With Python14 lectures • 57min

Build A Simple Database App With Python6 lectures • 30min

Requirements

Description

Who this course is for: