Lesson Plan : Structuring a SQL query
Teacher Name: | Glenn Sheils |
Grade: | College/University |
Subject: | Vocational Ed. |
Topic: | How to prepare and form an SQL query |
Content: | SQL, QUERIES, DATABASES |
Goals: | - Retrieve data from database - Efficiently |
Objectives: | Sample Questions Return correct data? |
Materials: | Computer DMBS,MySql |
Introduction: | - Give example of movie rental store. - Tables, customers, addresses, movies SELECT statement |
Development: | - Explain a JOIN - Tell them how to relate the data through keys. - Explain parts of an SQL query. |
Practice: | - Work through examples - Excel spreadsheet - Make up a table of customer names and addresses - Now have the students design a query with the class |
Accommodations: | |
Checking For Understanding: | - Testing - More complex query, find teh tables that John rented in December |
Closure: | - Invite to further reading - Prep for next class |
Evaluation: | Look at results of check understanding |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |