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 rulesuse the CREATE TABLE SQL command to create new tables in the databaseidentify the different Oracle database data types used when creating a tabledefine a default value to be assigned to a column when creating a tableidentify the different types of constraints and how these are used to enforce rules at a table leveldescribe the syntax for defining constraints when creating a tabledescribe the use of the NOT NULL and PRIMARY KEY constraints when creating a tabledescribe the use of the UNIQUE constraint when creating a tabledescribe the use of the FOREIGN KEY constraint when creating a table
-
describe the use of the CHECK constraintdescribe the conditions when a constraint is violatedcreate a new table and insert rows by combining the CREATE TABLE and the AS subquery option in a SQL statementchange the definition of a table using the ALTER TABLE SQL commandchange the definition of a table by adding, modifying, and dropping columns in a table using the ALTER TABLE SQL commanduse the SET UNUSED option to mark columns as unused using the ALTER TABLE SQL commanduse the ALTER TABLE SQL command to set a table to read onlyuse 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.