Learning Intention:

Students will create a SQL query to read data from a MySQL database.

Materials/Resources:

• Access to a computer with internet access
• MySQL database
• SQL query guide

Lesson Plan:

I. Introduction (5 minutes) A. Establish Learning Objective: Today we will be learning how to create a SQL query to read data from a MySQL database.

B. Explain the task: We will be using a SQL query guide to learn the syntax for constructing a query.

II. Coding Activity (20 minutes) A. Step-by-Step Instructions: 1. Open the SQL query guide and review the syntax for a SELECT query. 2. Connect to the MySQL database. 3. Construct a query using the SELECT statement. 4. Execute the query. 5. Review the results.

B. Group Activity: Students will work in small groups to practice constructing SQL queries. They will use the query guide to help them understand the syntax and review their answers afterwards.

III. Closing (5 minutes) A. Questions/Discussion: What difficulties did you have while constructing the query?

B. Summary of Learning Objectives: Today you learned how to create a SQL query to read data from a MySQL database. You practiced your skills by working in groups and reviewing the results of your queries.