In this installment of the Database Clinic series, enhance your understanding of SQLite—the embedded database engine—by seeing how it handles a series of common tasks.
- [Mark] SQLite is a part of almost every android and iPhone application. It's lightweight, easy to program, and public domain. Hi, I'm Mark Niemann-Ross, and in this course, I'll provide you with a look at common database problems and how to solve them with SQLite. We start with the simplest of operations, then move to more advanced SQLite use, such as extensions and subqueries. I'll show how to use an SQLite database with a database browser and a command line interface.
I'll also show how to use SQLite with programming languages, such as Python or R. This course is part of the database clinic series. Database clinic is a collection of courses each focused on a different database, each solving the same problem. You can choose to polish your skills with one database or use the collection of courses to compare how different databases provide solutions to data needs. I've enjoyed tackling these problems and look forward to sharing my solutions.
So let's get started with database clinic for SQLite.
- 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
1. SQLite in Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.