|
Provided by: 123-CBT Computer Based Training Oracle9i SQL DML and DDL |
 |
The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains the use of external tables and how to create the external tables.
Learn To: o Identify the data structures in an Oracle server.
o Identify the rules for naming tables in a database.
o Identify the DML and transaction control statements.
o Insert rows in a table by using the INSERT statement.
o Add a column to a table in an Oracle database.
o Change the table structure by modifying the characteristics of an existing column.
o Identify the features of an Oracle sequence.
o Create a sequence by using the CREATE SEQUENCE statement.
o Identify the properties of views.
o Match the clauses of the CREATE VIEW statement with their functions.
o Create a public synonym by using the CREATE PUBLIC SYNONYM statement.
o Remove a synonym by using the DROP PUBLIC SYNONYM statement.
o Identify the features of Oracle database security.
o Create users in an Oracle database.
o Match the types of multitable INSERT statements with their uses.
o Insert rows into multiple tables by using the INSERT INTO statement unconditionally.
Audience The intended audience for this course are Database Administrators. Required prerequisite knowledge includes Oracle9i SQL: Basic SELECT Statements 61130 and Oracle9i SQL: Data Retrieval Techniques 61131.
Deployment Options Internet / Intranet, Download, LAN, Workstation
Accreditation NASBA credits: 4 CPE Credits
Language Options American English, Brazilian Portuguese, German, Spanish
Total Learning Time 6 to 8 hours
61132 Objectives Unit 1: Creating Tables and Constraints 0.5 - 1 hour
o Identify the data structures in an Oracle server.
o Identify the rules for naming tables in a database.
o Sequence the steps to create a table.
o Identify the rules for referencing a table in another user's schema.
o Match the Oracle datatypes with their definitions.
o Identify the properties of constraints.
o Match the constraint types with their definitions.
o Identify the characteristics of the different levels of constraints.
o Sequence the steps performed by the Oracle server during a primary key lookup with a foreign key value insert.
o Identify the featu
Learn To: o Identify the data structures in an Oracle server.
o Identify the rules for naming tables in a database.
o Identify the DML and transaction control statements.
o Insert rows in a table by using the INSERT statement.
o Add a column to a table in an Oracle database.
o Change the table structure by modifying the characteristics of an existing column.
o Identify the features of an Oracle sequence.
o Create a sequence by using the CREATE SEQUENCE statement.
o Identify the properties of views.
o Match the clauses of the CREATE VIEW statement with their functions.
o Create a public synonym by using the CREATE PUBLIC SYNONYM statement.
o Remove a synonym by using the DROP PUBLIC SYNONYM statement.
o Identify the features of Oracle database security.
o Create users in an Oracle database.
o Match the types of multitable INSERT statements with their uses.
o Insert rows into multiple tables by using the INSERT INTO statement unconditionally.
Audience The intended audience for this course are Database Administrators. Required prerequisite knowledge includes Oracle9i SQL: Basic SELECT Statements 61130 and Oracle9i SQL: Data Retrieval Techniques 61131.
Deployment Options Internet / Intranet, Download, LAN, Workstation
Accreditation NASBA credits: 4 CPE Credits
Language Options American English, Brazilian Portuguese, German, Spanish
Total Learning Time 6 to 8 hours
61132 Objectives Unit 1: Creating Tables and Constraints 0.5 - 1 hour
o Identify the data structures in an Oracle server.
o Identify the rules for naming tables in a database.
o Sequence the steps to create a table.
o Identify the rules for referencing a table in another user's schema.
o Match the Oracle datatypes with their definitions.
o Identify the properties of constraints.
o Match the constraint types with their definitions.
o Identify the characteristics of the different levels of constraints.
o Sequence the steps performed by the Oracle server during a primary key lookup with a foreign key value insert.
o Identify the featu
|
|
||||||||
Training
Provided by 123-CBT Computer Based Training
Oracle9i SQL DML and DDL
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
