Lesson Plan : Struckturing 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 |
Introduction: | -Present some tables (movie rental store) -Tables disjoint info -Present tables, result thru chart |
Development: | -Explain a "JOIN" -Tell them how to relate the data through keys |
Practice: | -Excel spreadsheet containing data tables -Make up a table of customer names and addresses -Now, design a query with the class to do the above in SQL |
Accommodations: | |
Checking For Understanding: | blah blah blah |
Closure: | blah |
Evaluation: | blah blah blah blah blha |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |