Intro To SQLite Databases for Python Programming

Intro To SQLite Databases for Python Programming, available at $54.99, has an average rating of 4.58, with 28 lectures, based on 602 reviews, and has 5602 subscribers.

You will learn about 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 Youll 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 whats in the database whenever you want How to create basic reports with the data from your database This course is ideal for individuals who are Anyone who wants to use the SQLite Database with Python It is particularly useful for Anyone who wants to use the SQLite Database with Python.

Enroll now: Intro To SQLite Databases for Python Programming

Summary

Title: Intro To SQLite Databases for Python Programming

Price: $54.99

Average Rating: 4.58

Number of Lectures: 28

Number of Published Lectures: 24

Number of Curriculum Items: 28

Number of Published Curriculum Objects: 24

Original Price: $199.99

Quality Status: approved

Status: Live

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

Youll 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 whats in the database whenever you want

How to create basic reports with the data from your database

Who Should Attend

Anyone who wants to use the SQLite Database with Python

Target Audiences

Anyone who wants to use the SQLite Database with Python

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

Course Curriculum

Chapter 1: Installation

Lecture 1: Introduction

Lecture 2: First Things First: How To Get Support Fast!

Lecture 3: Install Python

Lecture 4: Install Sublime Text And Git Bash Terminal

Chapter 2: Using SQLite With Python

Lecture 1: Create SQLite Connection

Lecture 2: Create A Database Table

Lecture 3: Insert One Record Into The Table

Lecture 4: Insert Many Records Into The Table

Lecture 5: Query and Fetchall

Lecture 6: Format Results

Lecture 7: Primary Key ID

Lecture 8: Where Clause

Lecture 9: Update Records

Lecture 10: Delete Records

Lecture 11: Order Results By

Lecture 12: And / Or

Lecture 13: Limiting Results

Lecture 14: Drop Table

Chapter 3: Build A Simple Database App With Python

Lecture 1: Our App – Show All Function

Lecture 2: Our App – Add A Record Function

Lecture 3: Our App – Delete a Record Function

Lecture 4: Our App – Add Many Records Function

Lecture 5: Our App – Where Clause Function

Lecture 6: Bonus Lecture

Instructors

John Elder
Founder of Codemy

Rating Distribution

1 stars: 9 votes

2 stars: 9 votes

3 stars: 70 votes

4 stars: 234 votes

5 stars: 280 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!