Lesson #6: Integration
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.
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
Thanks. I’ve fixed both.
michaelmclaughlin
11 Feb 10 at 1:42 pm