Skip to main content

CS403: Introduction to Modern Database Systems

Unit 9: Basic Select Statements
In Unit 8, we introduced the select statement. In this unit, we will learn to build queries using one table. We will take a look at the basic syntax of the select statement along with some basic expressions and the where clause.

Completing this unit should take you approximately 14 hours.
- Unit 9 Learning Outcomes Page
- 9.1: The Distinct Clause
  - Stanford University: "SQL: Basic Select Statement" Page
    Watch this video.
  - W3Schools: "SQL SELECT DISTINCT Statement" URL
    Read this page.
- 9.2: The Where Clause
  - W3Schools: "SQL WHERE Clause" URL
    Read this page.
- 9.3: And/Or Operators
  - W3Schools.com's "SQL AND and OR Operators” URL
    Read this page.
- 9.4: SQL Aggregate Functions
  - W3Schools: "SQL Functions" URL
    Read this page.
- 9.5: Special Operators
  - 9.5.1: Like
    W3Schools: "SQL LIKE Operator" URL
    Read this page.
  - 9.5.2: Between
    W3Schools: "SQL BETWEEN Operator" URL
    Read this page.
  - 9.5.3: In
    W3Schools: "SQL IN Operator" URL
    Read this page.
  - 9.5.4: Wildcards
    W3Schools: "SQL Wildcards" URL
    Read this page.
  - 9.5.5: Top
    W3Schools: "SQL SELECT TOP Clause" URL
    Read this page.
- 9.6: The Order by Clause
  - W3Schools: "SQL ORDER BY Keyword" URL
    Read this page.