Oracle Database 12c - Introduction to SQL: Working with SET Operators and DDL


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
A key component of a Relational Database is the objects that are created, modified and deleted within the database. This course covers two topics. In the first topic, the course will teach you how to use SET operators in a SQL statement. In the second topic, you will learn how to create a table and work with the various constraints associated with a table. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate.

Target Audience
Functional Implementer, Forms Developer, System Analysts, Application Developers, PL/SQL Developer and learners looking to obtain the Oracle Database 12c Administrator Certified Associated designation or to become an OPN Certified Specialist.

Prerequisites
None

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 12c - Introduction to SQL: Working with SET Operators and DDL

  • start the course
  • describe the types of SET operators and their associated guidelines
  • recognize how the Oracle Server manages SET operators
  • use UNION and UNION ALL operators returns all rows in a SQL statement
  • use the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement
  • use the MINUS operator to return all distinct rows selected by the first query in a SQL statement
  • describe how the expressions in the SELECT lists of the queries must match in number in a SQL statement
  • use the ORDER BY clause in set operations in a SQL statement
  • write reports requested by the HR department using the SET operators
  • describe the DDL database objects and the associated naming rules
  • use the CREATE TABLE SQL command to create new tables in the database
  • identify the different Oracle database data types used when creating a table
  • define a default value to be assigned to a column when creating a table
  • define a default value to be assigned to a column when creating a table
  • describe the syntax for defining constraints when creating a table
  • describe the use of the NOT NULL and PRIMARY KEY constraints when creating a table
  • describe the use of the UNIQUE constraint when creating a table
  • describe the use of the CHECK constraint
  • describe the use of the CHECK constraint
  • describe the conditions when a constraint is violated
  • create a new table and insert rows by combining the CREATE TABLE and the AS subquery option in a SQL statement
  • change the definition of a table using the ALTER TABLE SQL command
  • change the definition of a table by adding, modifying, and dropping columns in a table using the ALTER TABLE SQL command
  • use the SET UNUSED option to mark columns as unused using the ALTER TABLE SQL command
  • use the ALTER TABLE SQL command to set a table to read only
  • use the DROP TABLE SQL command to delete a table from the database
  • work with tables using DDL

    • Course Number:
    od_insq_a07_it_enus

    Expertise Level
    Beginner