Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Oracle SQL 12c
| Beginner
- 12 videos | 1h 2m 43s
- Includes Assessment
- Earns a Badge
Explore how to create a table and work with the various constraints associated with a table in Oracle Database 12c.
WHAT YOU WILL LEARN
-
Provide an overview of dll, and 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
Define constraints such as not null, unique, primary key, foreign key, and check -
Create a new table and insert rows by combining create table and as in a sql statement
Change the definition of a table using the alter table sql command
Mark columns as unused with the set unused statement
Remove unused columns
Use the drop table sql command to delete a table from the database
Create and work with tables using ddl
IN THIS COURSE
-
5m 42sAfter completing this video, you will be able to provide an overview of DLL, and describe the DDL database objects and the associated naming rules. FREE ACCESS
-
4m 51sIn this video, learn how to use the CREATE TABLE SQL command to create new tables in a database. FREE ACCESS
-
3. Data Types6m 30sIn this video, you will learn how to identify the different Oracle database data types used when creating a table. FREE ACCESS
-
4. Specify the DEFAULT Option for Columns in a Table6m 27sIn this video, learn how to set a default value to be assigned to a column when creating a table. FREE ACCESS
-
5. Overview of Constraints8m 26sIn 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. Working with Constraints7m 18sIn this video, you will learn how to define constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK. FREE ACCESS
-
7. Creating Tables Using Subqueries3m 34sTo create a new table and insert rows, combine the CREATE TABLE and AS keywords in a SQL statement. FREE ACCESS
-
8. ALTER TABLE Statement4m 28sIn this video, you will learn how to change the definition of a table using the SQL command ALTER TABLE. FREE ACCESS
-
9. Marking Columns as Unused4m 25sIn this video, you will learn how to mark columns as unused with the SET UNUSED statement. FREE ACCESS
-
10. Removing Unused Columns3m 54sIn this video, you will remove any unused columns. FREE ACCESS
-
11. DROP TABLE Statement1m 55sIn this video, find out how to use the DROP TABLE SQL command to delete a table from your database. FREE ACCESS
-
12. Exercise: Create and Work with Tables Using DDL5m 15sIn this video, you will learn how to create and work with tables using DDL. FREE ACCESS
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.
