Step 1: Read it

SQL for MySQL Developers: Read Chapters 17, 20, 21, and 24.

Chapter 21, InnoDB is the default engine from MySQL 5.5.5 onwards.

https://dev.mysql.com/doc/refman/5.6/en/innodb-default-se.html

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 4 - Updating Tables

Homework 5 - Changing Tables

Project 1 - Import and Extend a database