SQLite databases with Python

SQLite databases with Python, available at $49.99, has an average rating of 4.45, with 11 lectures, based on 52 reviews, and has 10741 subscribers.

You will learn about How to use SQLite databases with Python Basic SQL queries This course is ideal for individuals who are Beginner Python developers It is particularly useful for Beginner Python developers.

Enroll now: SQLite databases with Python

Summary

Title: SQLite databases with Python

Price: $49.99

Average Rating: 4.45

Number of Lectures: 11

Number of Published Lectures: 11

Number of Curriculum Items: 11

Number of Published Curriculum Objects: 11

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

How to use SQLite databases with Python

Basic SQL queries

Who Should Attend

Beginner Python developers

Target Audiences

Beginner Python developers

In this course you will learn interacting with SQLite3 databases. It makes it easy to access sqlite databases from python code. Manipulate and analyze your data using Python.

While you can store your data in files, this quickly becomes impractical.  A file can only be opened and written once, not by millions of people at the same time. If you want to make any kind of data-driven application you need to use a database system.

SQLite is a great little database. basically, it is a low-overhead, cross-platform, self-contained, zero-configuration, transactional SQL database engine. It’s great when you want to move beyond files on the disk and start working with databases.

The best part is that it has bindings in lots of languages. In python, those bindings are in Python Package Index (pypi) as python-sqlite3 package.

The course teaches you how to setup a database and basic SQL with Python. Once you know how to work with SQLite, you can transfer that knowledge to working with other database systems like MySQL or Postgres.You will learn how to insert, retrieve, update and delete data amongst other things.

If you are a Python beginner and want to work with databases, this course is for you.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Create database

Lecture 3: Create table and insert data

Lecture 4: Open an SQLite Database

Lecture 5: Show table data

Lecture 6: Delete data

Lecture 7: Update data

Lecture 8: Summary

Chapter 2: Intermediate

Lecture 1: Creating complicated tables

Lecture 2: Show data (intermediate)

Lecture 3: Whats next?

Instructors

Frank Anemaet
Supercharge Your Career

Rating Distribution

1 stars: 1 votes

2 stars: 3 votes

3 stars: 8 votes

4 stars: 22 votes

5 stars: 18 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!