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

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.

Prerequisite
None

Expected Duration
107 minutes

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.

Objective

Using the SET Operators

  • 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

Practice: Using SET Operators

  • write reports requested by the HR department using the SET operators

Introduction to Data Definition Language

  • 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

Working with Constraints in DDL

  • 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

Additional Commands in DDL

  • 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

Practice: Using DDL Statements

  • work with tables using DDL

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.