Online Hierarchical Query eLearning - Training Resources

Oracle SQL Specifics Retrieving and Formatting Data Course Overview This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will  more...

Oracle SQL and SQL Plus Advanced SELECT Statements ...ies Duration: 1 Hour(s) Identify the features of a hierarchical query. Complete a SELECT statement to display rows from a table that has a hierarchy. Complete the statement to format a hierarchical report by using the PRIOR operator and LEVEL pseudocolumn. Complete a statement to prune a hierarchical tree. Unit 6: Set Operators Duration: 1 Hour(s) Write the compound queries  more...