In this chapter, we discuss Structured Query Language (SQL) and its use in querying databases. You continue developing the Book-O-Rama database by learning how to insert, delete, and update data, and how to ask the database questions.
Key topics covered in this chapter include
What is SQL?
Inserting data into the database
Retrieving data from the database
Updating records from the database
Altering tables after creation
Deleting records from the database
We begin by describing what SQL is and why it's a useful thing to understand.
If you haven't set up the Book-O-Rama database, you need to do that before you can run the SQL queries in this chapter. Instructions for ...