SQLite: Other Considerations

Start Course
level
Introductory
Subject
Software Development
Course Length
42 minutes
Subscription
Foundation

Course Description

SQLite is a fast, small-footprint, zero-administration database that can be used in a broad array of circumstances. The fundamentals of using SQLite include knowing how to programmatically execute SQL queries and whether to retrieve data or modify the database by inserting, updating, or deleting rows. In this course, we will explore two alternative packages to interface with SQLite: apsw and records. We will also look at ways to view or modify characteristics of SQLite itself through PRAGMA statements.

Requirements

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

Instructors

Brian Wolf

Proven project leader and 36 year veteran with extensive hands-on experience over entire software lifecycle.