Lesson Plan : Structuring a Simple SQL Query
Teacher Name: | Mr. Teacher |
Grade: | Grade 11-12 |
Subject: | Science |
Topic: | How to write an SQL query. |
Content: | SQL,QUERIES,DATABASE |
Goals: | - Retrieve data from a database - Write efficient queries |
Objectives: | - Provide solutions to sample question, returns the correct data |
Materials: | - Computer - DBMS (database management system) - Overhead projector - Slides |
Introduction: | - Present some tables (movie rental store) - Tables disjoint info (customers, addresses, rental history, movies in store) - SELECT statement to rental history for a given customer - Present tables & the result through a chart |
Development: | - Explain a "join" - Tell them how to relate the data through keys and produce interesting results. - Explain the parts of an SQL query |
Practice: | - Excel spreadsheet containing data tables - Make up a table of customer names and addresses (using the customer IDs) - Now, design a query with the class to do the above in SQL |
Accommodations: | |
Checking For Understanding: | - More complex query: Find the year of the movies "John" rented in December. |
Closure: | - Invitation to further reading / learning - Preparation for next class. |
Evaluation: | - Look at the accuracy of the "Check Understanding" query. - Have them hand in their queries, test them. |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |