Hands-on task
SQLite: a book catalog in one file
Let's start with the simplest database — SQLite. Create a database /root/catalog.db with a table books of three columns id, title and year, and add at least 3 books to it.
Write the SQL as a script in the file /root/catalog.sql — it's handy to type it in the Editor tab — and then run that script in sqlite3.
- sqlite3
- create table
- insert
- sql