Step 1: Read it
SQL for MySQL Developers: Read Chapter 27.
SQL for MySQL Developers: Skim Chapters 28, 29, and 30.
Read the Database Normalization PDF.
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.
Before doing Homework 6 try out the EER Diagram component of MySQL Workbench. Import the Tennis database into the EER Diagram window.
EER Diagram Modeling Tutorials
https://dev.mysql.com/doc/workbench/en/wb-tutorials.html
Step 3: Practice it
Homework 6 - Database normalization
Project 2 - Design and create a database