Database Clinic: SQLite

In Database Clinic: SQLite, I show how to solve database challenges with SQLite.

Compare SQLite with other databases

SQLite is a library used to add database capabilities to apps and applications. It’s lightweight, easy to implement, and open source. It’s most useful for storing light-weight structured data. Think of it as an alternative to storing data in a text file. It’s used for storing app preferences or even as a file format.

After providing a brief overview of the strengths and weaknesses of SQLite, I explain how to create a database and populate it using a public dataset. I also shows how to use a SQLite database with programming languages such as Python and R, handle subqueries and queries in SQLite, and more.

Hosted on LinkedIn Learning and lynda.com

LinkedIn Learning is part of LinkedIn. Here is a link to Database Clinic: SQLite on LinkedIn Learning.

Lynda.com was purchased by LinkedIn – and still continues to publish content. Here is a link to Database Clinic: SQLite on lynda.com.

Topics Include:

  • Strengths and weaknesses of SQLite
  • Creating a database
  • Joining data sets
  • Calculations with SQLite and Python
  • Searching a database
  • Subqueries and queries in SQLite
  • CRUD operations in SQLite with R