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: (2.75–3 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)

Due

As a reminder, the following are due this lesson:

« SQL Data Definition SQL Aggregates »