Installing and Running MySQL -- Linux -- Launching the Server Under Linux -- Windows -- Installing a Windows Distribution -- Starting the Server Under Windows -- Mac OS X -- Creating and Loading Databases -- Creating a New Database -- Starting the MySQL Daemon -- Running the Client -- Creating New Users -- Creating and Using the Database -- Creating the Tables -- Populating the Tables -- Introduction to SQL -- A Bit of SQL History -- Conformance Levels -- Relational Database Terminology and the Sample Database -- Basic Relational Database Concepts -- The Online Bookstore Database -- Manipulating Relations -- SQL Environments -- Interactive SQL Command Processors -- The Embedded SQL Dilemma -- Performing Interactive Data Manipulation -- Simple SQL Retrieval -- Choosing Columns -- Retrieving All Columns -- Retrieving Selected Columns -- Removing Duplicates -- The Relational Algebra Project Operation -- Ordering the Result Table -- Choosing Rows -- Predicates -- Performing Row Selection Queries -- The Relational Algebra Restrict Operation -- Nulls and Retrieval: Three-Valued Logic -- Retrieving Data from More Than One Table: Joins -- The Relational Algebra Join Operation -- A Non-Database Example -- Equi-Joins -- What's Really Going On: Product and Restrict -- SQL Syntax for Inner Joins -- Traditional SQL Joins -- SQL-92 Join Syntax -- Joining Using Concatenated Keys -- Joining More Than Two Tables -- Finding Multiple Rows in One Table: Joining a Table to Itself -- Correlation Names -- Performing the Same-Table Join.