DETAILED INF3707 Summary

Objectives After completing this lesson, you should be able to do the following: • List the course objectives • Describe the sample tables used in the course Copyright © 2004, Oracle. All rights reserved. Course Objectives After completing this course, you should be able to do the following: • Use advanced SQL data retrieval techniques to retrieve data from database tables • Apply advanced techniques in a practice that simulates real life Copyright © 2004, Oracle. All rights reserved. Course Overview In this course, you will use advanced SQL data retrieval techniques such as: • Datetime functions • ROLLUP, CUBE operators, and GROUPING SETS • Hierarchical queries • Correlated subqueries • Multitable inserts • Merge operation • External tables • Regular expression usage