Database Tutorial

Course Tutorial Site

Site Admin

Lesson #6: Integration

with 2 comments

This lesson focuses on integrating concepts that you’ve learned through the first five lessons. You learned how to create and modify database structures in Lesson #2. This lab requires that you use those skills again with less direct guidance other than the business and system specifications. These changes to the data model may need to be fixed in your data model from Lesson #3

You learned how to insert data in Lesson #4. This lab requires you to use those skills again in this lab. This lab also requires you to extend your knowledge from an INSERT INTO table_name VALUES statement to an INSERT INTO table_name (sql_query) statement.

This lesson also presents key information on how you: (a) fabricate data through cross joins; (b) update more than one column with a correlated UPDATE statement; and (c) how you validate the integrity of your work when database-level constraints can’t do all of it. You will also deal with more complex data in this lessson, including data derived from data; filtered data, and data conversions. You must generate data through the use of joins and sets covered in Lesson #5.

The new lesson preparation material covers subqueries (single-row, multiple-row, and correlated subqueries), conditional SQL logic with the CASE statement (and coverage of Oracle Proprietary DECODE statement), data type conversion, and an introduction to the syntax of an CREATE INDEX statement.

    Subqueries
    Learn what a subquery is and how it works.
    Correlated subqueries
    Learn what a correlated subquery is and how it works.
    Insert Query Results
    Learn what a multiple row is and how it works when the source is a subquery.
    Data Type Conversions
    Learn the basics of data type conversions with the CAST function as well as some port specific functions.
    SQL Conditional Logic
    Learn how to perform conditional logic statement inside SQL queries and DML statements.
    Data Fabrication
    Learn what data fabrication is, and how to leverage CROSS JOIN syntax to achieve data fabrication.
    UPDATE Statement
    Learn what an UPDATE statement is, and how it works.
    Using Indexes
    Learn what an INDEX is and how to create and manage it.

Written by michaelmclaughlin

October 8th, 2009 at 8:52 pm

Posted in

2 Responses to 'Lesson #6: Integration'

Subscribe to comments with RSS or TrackBack to 'Lesson #6: Integration'.

  1. Your first link after the intro paragraphs “Subqueries” seems to be directing to the wrong place. The subqueries link on the right hand side of the page under lesson 6 works though.

    Also the sentence “These changes to the data model may need to fixed in your data model from Lesson #3.”

    I think you are missing the word “be” in the part “need to fixed” should be “need to be fixed.”

    Marcus Norton

    11 Feb 10 at 1:07 pm

  2. Thanks. I’ve fixed both.

    michaelmclaughlin

    11 Feb 10 at 1:42 pm

Leave a Reply