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

Online, Self-Paced

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.

Learning Objectives

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