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 18sAfter completing this video, you will be able to describe the DDL database objects and the associated naming rules. FREE ACCESS
-
2. Creating Tables4m 39sIn this video, find out how to use the CREATE TABLE SQL command to create new tables in a database. FREE ACCESS
-
3. Data Types4m 26sIn this video, you will identify the different data types used in Oracle databases when creating a table. FREE ACCESS
-
4. Specifying DEFAULT Option for Columns in a Table2m 45sLearn how to set a default value to be assigned to a column when creating a table. FREE ACCESS
-
5. Constraints and Constraint Guidelines2m 55sIn this video, you will identify the different types of constraints and how these are used to enforce rules at a table level. FREE ACCESS
-
6. Defining Constraints4m 27sUpon completion of this video, you will be able to describe the syntax for defining constraints when creating a table. FREE ACCESS
-
7. NOT NULL and PRIMARY KEY Constraints4m 8sAfter completing this video, you will be able to describe the use of the NOT NULL and PRIMARY KEY constraints when creating a table. FREE ACCESS
-
8. UNIQUE Constraint4m 22sAfter completing this video, you will be able to describe the use of the UNIQUE constraint when creating a table. FREE ACCESS
-
9. Foreign Key Constraint4m 19sAfter completing this video, you will be able to describe the use of the FOREIGN KEY constraint when creating a table. FREE ACCESS
-
10. CHECK Constraint3m 31sAfter completing this video, you will be able to describe the use of the CHECK constraint. FREE ACCESS
-
11. Violating Constraints3m 40sUpon completion of this video, you will be able to describe the conditions when a constraint is not met. FREE ACCESS
-
12. Creating a Table Using a Subquery4m 43sLearn how to create a new table and insert rows by combining the CREATE TABLE and AS subquery options in a SQL statement. FREE ACCESS
-
13. ALTER TABLE Statement1m 40sDuring this video, you will learn how to change the definition of a table using the SQL command ALTER TABLE. FREE ACCESS
-
14. Working with Columns5m 50sTo change the definition of a table, use the ALTER TABLE SQL command to add, modify, or drop columns in the table. FREE ACCESS
-
15. SET UNUSED Option3m 55sDuring this video, you will learn how to use the "SET UNUSED" option to mark columns as unused using the "ALTER TABLE" SQL command. FREE ACCESS
-
16. Read-only Tables2m 31sIn this video, you will use the ALTER TABLE SQL command to set a table to read-only. FREE ACCESS
-
17. Dropping a Table2m 39sLearn how to use the DROP TABLE SQL command to delete a table from the database. FREE ACCESS
-
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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
