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

  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
  3. Attend the class meeting
  4. Complete the practice queries

Due

As a reminder, the following is due this lesson:

« Relational Algebra II SQL Aggregates »