Describe the Oracle tools and what they are used for. Know which tools are available for connecting to and interacting with an Oracle database. Understand how these tools differ from one another.
Understand relational database concepts. Understand important relational database concepts such as primary and foreign keys and how these are used to enforce business rules within the database.
Identify how SQL is used to interact with the database. Be able to describe how SQL and iSQL*Plus, GUI management tools, Java, PL/SQL, and Oracle's programming interfaces can be used to connect to an Oracle database; describe the structure of the tables; and use SELECT, INSERT, UPDATE, and DELETE statements to perform transactions.