Step 1: Read it

SQL for MySQL Developers: Read Chapters 5, 6, 7, 8, 9, 10, 11, 12, 13, and 14.

It is a lot of chapters but 11, 12, 13, and 14 are short. Focus on chapters 6 through 10.

Skip chapter 15 and 16 as nice to know. HANDLER statements in Chapter 16 are specific to MySQL.

Skim Chapter 5; focus on the syntax of the various literals. The definitions in the chapter are in Backus–Naur Form which is simply a notation for showing the syntax of a language.

NOTE: In Chapter 7 example 7.1 will not work on the ACC Lab MySQL server as users are only allowed one schema (database). Just create the CITIES table in the default schema (database).

Step 2: Do it

When the book has an example for trying out a SQL example, DO IT.

The chapters also have exercises which have answers at the end of each chapter, try these out as time permits.

Step 3: Practice it

Homework 2 -  SELECT basics

Homework 3 -  SELECT advanced