Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g

This course is included in our On-demand training solution.

Overview

To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases

Target Audience

Database administrators, application developers, and database operators

Prerequisites

Familiarity with RDBMS technologies and programming techniques

Expected Duration

130 min.

Course Objectives

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g

  • retrieve records using the NATURAL JOIN and USING clauses.
  • retrieve data by creating joins with the ON clause.
  • use outer joins and generate Cartesian products.
  • use joins to retrieve data from multiple tables.
  • write SQL queries using set operators.
  • identify how to comply with rules for using set operators.
  • use the UNION, UNION ALL, INTERSECT, and MINUS operators in SQL queries
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?