Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQLite databases with Python
Rating: 4.3 out of 5(61 ratings)
10,749 students

SQLite databases with Python

Quick intro to Databases with Python
Created byFrank Anemaet
Last updated 7/2021
English
English [Auto],

What you'll learn

  • How to use SQLite databases with Python
  • Basic SQL queries

Course content

2 sections • 11 lectures • 33m total length

  • Introduction0:06
  • Create database4:23

    Learn how python uses sqlite3 to create and open a single-file database via the connect function, and run the script on macOS, Linux, or Windows.

  • Create table and insert data3:31

    Create SQLite tables with Python, defining columns and data types, including a primary key. Insert data using SQL queries and commit changes, and manage or reset the database file.

  • Open an SQLite Database4:16

    Learn to open an SQLite database with Score Browser, browse data, view and edit tables, create new tables, run SQL queries, and interact with data alongside Python.

  • Show table data2:49

    Learn to retrieve data from a SQLite table using the select query, with all columns or specific ones like idea and name. Understand why selecting columns matters for large tables.

  • Delete data2:58

    Learn to delete data from the users table in SQLite databases using the execute function, specify conditions (id, greater than, or less than), and back up before permanent deletion.

  • Update data3:42

    Learn to update data in an SQLite table using the execute function, targeting rows by their unique id and setting a column value, such as the name to Python.

  • Summary0:27

Requirements

  • Be able to run Python

Description

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.

Who this course is for:

  • Beginner Python developers

Report abuse