Working with DDL
Oracle 12c
| Beginner
- 18 Videos | 1h 10m 10s
- Earns a Badge
There's a lot of flexibility available in how you create tables to store data in an Oracle 12c database. Learn about how to create tables, choose the proper data type for columns, set constraints, and change or delete existing tables.
WHAT YOU WILL LEARN
-
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
identify the different types of constraints and how these are used to enforce rules at a table level
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 FOREIGN KEY constraint when creating a table -
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
IN THIS COURSE
-
1.Database Objects and their Naming Rules4m 18s
-
2.Creating Tables4m 39s
-
3.Data Types4m 26s
-
4.Specifying DEFAULT Option for Columns in a Table2m 45s
-
5.Constraints and Constraint Guidelines2m 55s
-
6.Defining Constraints4m 27s
-
7.NOT NULL and PRIMARY KEY Constraints4m 8s
-
8.UNIQUE Constraint4m 22s
-
9.Foreign Key Constraint4m 19s
-
10.CHECK Constraint3m 31s
-
11.Violating Constraints3m 40s
-
12.Creating a Table Using a Subquery4m 43s
-
13.ALTER TABLE Statement1m 40s
-
14.Working with Columns5m 50s
-
15.SET UNUSED Option3m 55s
-
16.Read-only Tables2m 31s
-
17.Dropping a Table2m 39s
-
18.Exercise: Create and Work with Tables Using DDL5m 23s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
