A sample database used in my Introduction to SQL for Librarians post. Can be pasted into SQLFiddle.com to create a database for experimentation.

intro-to-sql-basic-database.sql

CREATE TABLE books
	(`id` INT, `title` varchar(225), `location` varchar(12), `publisher` varchar(100), `publication_date` INT(4) )
;
	
INSERT INTO books
	(`id`, `title`, `location`, `publisher`, `publication_date`)
VALUES
	(1, 'Semantic Web for the Working Ontologist: Effective Modeling in RDFS and OWL', 'ebook', 'Morgan Kaufmann Publishers', 2008 ),
	(2, 'The Fifth Season', 'new', 'Orbit', 2015 ),
	(3, 'Ancillary Justice', 'new', 'Orbit', 2013),
	(4, 'Steve Jobs', 'biography', 'Simon & Shuster', 2015 ),
	(5, 'And Tango Makes Three', 'children', 'Simon & Shuster', 2005),
	(6, 'A Christmas Carol', 'classic', 'Simon & Shuster', 2007),
	(7, 'Do Androids Dream of Electric Sheep?', 'scifi', 'Del Ray', 1968),
        (8, 'Sally Ride: America\'s First Woman in Space', 'new', 'Simon and Shuster', 2015)
;