Learning Objectives

  • Identify the purpose of SQL’s SELECT command
  • Use SQL to select attributes and to project tuples from a relational database
    • Use the LIKE operator to match patterns in strings
    • Use SELECT DISTINCT to eliminate duplicates from query results
  • Describe how to perform an inner join of multiple relations

Preparation

Complete the following learning activities: (4.75–5 hours total)

  1. Read Fundamentals of Database Management Systems Chapter 4: Relational Data Retrieval: SQL (60 minutes)
  2. Complete Beazley’s Last Statement from Select Star SQL (30–45 minutes)
  3. Attend the class meeting (60 minutes)
  4. Complete the practice queries
  5. Take the quiz (10 minutes)
  6. Work on the schema design for the project (60 minutes)
    • Populate the database with representative data
  7. Work on the SQL programming exercise (PEX) (60 minutes)
    • Complete queries 6–10 (LargeCo database)

Due

As a reminder, the following is due this lesson:

Resources