Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

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

    $

Python Apps with SQLite

Learn about connecting to SQLite querying its tables.

GK# 5196

Course Overview

TOP

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.

Schedule

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

$

What You'll Learn

TOP
  • 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)

Outline

TOP
Viewing outline for:

GK Digital Learning Outline

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

Prerequisites

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

Who Should Attend

TOP

Any Python developer who wants to work with SQLite.

Course Delivery

This course is available in the following formats:

GK Digital Learning

Experience high-quality online learning combined with reliable expert guidance and skills development activities.



Request this course in a different delivery format.
Enroll