SQL SELECT

Preparation

Fundamentals of Database Management Systems

• Chapter 4: Relational Data Retrieval: SQL

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

Practice

Complete the practice queries as time permits in class (or outside of class)