Once you have your bible database up and running, there are lots of fun queries you can try. Each page focuses on a different area of SQL. Provided you've installed the biblesql database, you should be able to cut and paste the queries from the pages below straight into your mysql browser.

Triggers

Using triggers to see who's updated your tables.

Full Text

Full text indexes versus LIKE in searching for content

Subqueries

Using Subqueries to select out all the juicy bits!

Views

Using views to restrict Selects to the old and new testaments

Functions

Writing a function in SQL which finds how many times in a verse god gets mentioned

Procedures

Using Procedures to display one chapter at a time