SQLite3 is the command line interface to SQLite. It's not pretty, but it does more than any of the other SQLite GUI interfaces. The command line tool allows us to control SQLite in a direct and interactive fashion, speeding development in other environments.
- [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 satisfaction.…Let me show you the step by step…
- 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.