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.
Author of "Stupid Machine" and educator at LinkedIn learningMark Niemann-Ross is a technologist with experience in hardware, software, and science fiction.
Mark has been helping developers navigate APIs for almost 30 years, and has been responsible for third-party programs at Quark and Adobe. In addition to hands-on technology, he's also been involved in technology education, starting with a degree in industrial education and most recently working as a content manager for LinkedIn Learning.
Mark's science fiction has most recently appeared in Analog Science Fiction and Fact. He's currently working on a murder mystery solved by a refrigerator.
Skills covered in this course
- [Instructor] After a couple of semi-successful attempts, I decided to go with the basest of tools, the sqlite3 command line interface. Depending on your computer and the software installed, it may already be available. If not, it's an easy download from sqlite.org. Sqlite3 command line interface has a bunch of commands you'll want to be familiar with. You can find a list of these commands at sqlite.org. Here's where to find it. Go to the Documentation tab, go down to Tools, and click on the Command-Line Shell. This gives lots of information about using the command line tool. Most importantly, in Chapter 3, it has special commands to sqlite3. These are called dot-commands because each command starts with a dot. As we work through this exercise, I'll be using dot-commands to manipulate the CSV files and SQLite files that I'll be building. Again, you can reference those commands at this page. It took me a little bit of experimentation, but I created a process that worked to my…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download the exercise files for this course. Get started with a free trial today.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Watch this course anytime, anywhere. Get started with a free trial today.