Lesson Plan : Structuring a simple SQL query
Teacher Name: | Rocks On Rocks |
Grade: | Grade 11-12 |
Subject: | Science |
Topic: | How to write a SQL query. |
Content: | SQL, QUERIES, DATABASE |
Goals: | Retrieve data from a database Write efficient queries |
Objectives: | Sample questions Queries return correct data |
Materials: | Computer with database management systems. Slides to go with. |
Introduction: | Present some tables (movie rental store) Movies, addresses, rental history, show a chart |
Development: | Explain a "join" tell them how to relate the data through keys, and multiple tables. |
Practice: | Excel spreadsheet containing data tables. Make up a table, customer names, address using customer ID's Design a query with the class |
Accommodations: | |
Checking For Understanding: | More complex query: Find the movie year that 'John' rented which would use 2 databases |
Closure: | Invitation to further reading/reading next class |
Evaluation: | Look at the accuracy of the "check understanding" Hand in queries and test |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |