Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Python Apps with SQLite

Learn about connecting to SQLite querying its tables.

GK# 5196

Course Overview


SQLite is fast, small-footprint, zero-administration database that can be used in a broad array of circumstances, such as:

  • Embedded devices and the internet of things
  • Websites
  • Financial applications
  • Geospatial software
  • Cache for enterprise data 

In this course, you will gain a thorough understanding of working with SQLite. You will be able to write code to extract data to just about any format you'd like; efficiently insert or update data; and even manipulate SQLite environment settings.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


Class is Full
This session is full. Please select a different session.

What You'll Learn

  • Connecting to a SQLite database and querying its tables
  • Inserting, updating, and deleting rows
  • An overview of PRAGMA
  • Interfacing with SQLite is provided by sqlite3
  • Open-source third party packages (available from PyPI and GitHub)


Viewing outline for:

On-Demand Outline

  1. SQLite: Retrieve Data
  2. SQLite: Insert, Update and Delete
  3. SQLite: Other Considerations


  • A basic understanding of the Python language and standard library
  • A fundamental understanding of relational databases and Standard Query Language (SQL)

Who Should Attend


Any Python developer who wants to work with SQLite.

Course Delivery

This course is available in the following formats:


Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.

Duration: 4 hours

Request this course in a different delivery format.