Warning: include() [function.include]: URL file-access is disabled in the server configuration in /nfs/cs/classes/www/06U/cis399oracle/lectures/week3.php on line 14

Warning: include(http://www.cs.uoregon.edu/classes/06U/cis399oracle/utility_functions.php) [function.include]: failed to open stream: no suitable wrapper could be found in /nfs/cs/classes/www/06U/cis399oracle/lectures/week3.php on line 14

Warning: include() [function.include]: Failed opening 'http://www.cs.uoregon.edu/classes/06U/cis399oracle/utility_functions.php' for inclusion (include_path='.:/private/apps/php-5.2.4/lib/php') in /nfs/cs/classes/www/06U/cis399oracle/lectures/week3.php on line 14

CIS 399 - Introduction to Oracle and SQL

Slides for this week's lectures

Week 3 Lecture Notes

Monday, July 10 2006

  1. Announcements: old homework update
  2. Finish lecture from Thursday, July 6
  3. The SELECT Statement
    1. DISTINCT
    2. WHERE clause
    3. Character strings and dates
    4. Operator precedence
    5. ORDER BY clause
    6. Top-N queries in Oracle
    7. Computations in queries
    8. Concatenating Columns

Tuesday, July 11 2006

  1. Announcements: new homework
  2. The SELECT Statement, continued
    1. Functions
      1. Character functions
      2. Numeric Functions
      3. Date Functions
      4. Conversion Functions
        1. Number formatting
        2. Date Formatting
        3. Time Formatting
      5. Special Functions
      6. Aggregate Functions
    2. GROUP BY clause
    3. HAVING clause
    4. FOR UPDATE clause
  3. Formatting Output

Wednesday, July 12 2006

  1. Chapter 6: Multitable Queries & Views
  2. Joins:
    1. Inner
    2. Natural
    3. Outer
    4. Self
  3. Table Aliases
  4. Set Operations

Thursday, July 13 2006

  1. Set Operations, continued
  2. Subqueries
  3. Correlated Subqueries

Answers to Questions / Clarifications

Back to Main Page

Valid XHTML 1.0 Strict