[Lynda] Database Clinic: SQLite

Tags: , , [esi post-views cache="public" ttl="0"]

image of author Mark Niemann-RossMark Niemann-Ross



SQLite is a powerful embedded database engine that’s a core storage technology in Android and iOS applications. In this installment of the Database Clinic series—in which experts and their databases of choice are pitted against a series of the same challenges— Mark Niemann-Ross demonstrates how to leverage SQLite to solve common database problems. After providing a brief overview of the strengths and weaknesses of SQLite, Mark explains how to create a database and populate it using a public dataset. He also shows how to use a SQLite database with programming languages such as Python and R, handle subqueries and queries in SQLite, and more.

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
Skill Level Intermediate

2h 10m



Show More Show Less



Friendly Websites

OneHack.Us | Tutorials For Free, Guides, Articles & Community Forum.

2 thoughts on “[Lynda] Database Clinic: SQLite”

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.