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
Using advanced SQL data retrieval techniques such as:
- SET operators
- Oracle9i DATETIME functions
- ROLLUP, CUBE operators and GROUPING SETS
- Hierarchical queries
- Correlated subqueries
- Multitable inserts
- External Tables
After completing this lesson, you should be able to do the following:
- Describe SET operators
- Use a SET operator to combine multiple queries into a single query
- Control the order of rows returned
Click Here
