Database Tutorial

Course Tutorial Site

Site Admin

Week 7 – Summary

without comments

Objectives

There are three objectives for the seventh week. The best way to accomplish these objectives is two fold. First, you need to read the articles and web pages referenced through links in the summary page. This also includes any subordinate pages referenced through links. Second, you need to do the work and use the tools to copy existing scripts, edit scripts, and test scripts.

  • Learn how to update multiple rows through correlated UPDATE statements.
  • Learn how to use the CASE operator to return conditionally substituted values.
  • Learn how to fabricate data through SELECT statements and set operators.

Reading Assignments

You should prepare by reading the following articles. There will be many new terms. You may want to check the Glossary in the Oracle Database 12c PL/SQL Programming book to understand most of those new terms. After your preparation, you should work through the examples provided for you in the reading.

  • Prepare (Reading):
    • Understand how to perform data troubleshooting.
    • Understand how to use the data dictionary.
    • Understand how to query the data dictionary.
    • Understand how to write diagnostic queries.
    • Understand how to aggregate data values.
  • Teach One Another (Lab):

    • Diagnose preexisting data states with queries.
    • Update data through correlated queries.
    • Write conditional logic with the CASE operator in a SELECT-list.
  • Ponder and Prove (Internalization):

    • Compare and contrast data analysis and conditional operation use cases.
    • Examine and understand how to a query with conditional operations works.

Reference Materials

After you’ve read the article and tutorials, you should experiment with the examples provided in the article or tutorials. The second week’s lab starts with copying, editing, and testing unit and integration testing scripts:

Written by michaelmclaughlin

August 11th, 2018 at 2:54 pm

Posted in