|
Provided by: 123-CBT Computer Based Training Manipulating Data in Oracle Database 10g |
 |
Manipulating Data in Oracle Database 10g Oracle
To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements
To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements
|
|
||||||||
Training
Provided by 123-CBT Computer Based Training
Manipulating Data in Oracle Database 10g
Oracle
PrerequisitesFamiliarity with RDBMS technologies and programming techniques
Target AudienceDatabase administrators, application developers, and database operators
LessonsUsing DML statements to insert data in Oracle 10g| - insert rows into a table.|Modifying and removing rows in Oracle 10g tables| - update and delete rows in a table.|Using DML statements in Oracle 10g| - insert, update, and delete data.|Database transactions in Oracle 10g databases| - control data changes and identify how read consistency is implemented.|Controlling database transactions in Oracle 10g| - control data changes using the COMMIT, SAVEPOINT, and ROLLBACK statements.|Manipulating large datasets in Oracle 10g databases| - manipulate data in Oracle 10g by using subqueries.|Multitable INSERT statements in Oracle 10g| - use various types of multitable inserts.|Multitable MERGE statements and data tracking| - use the MERGE statement and the Flashback Version Query feature.|Using multitable statements in an Oracle 10g database| - perform multitable INSERT and MERGE operations, and track row versions.|
Test Prep
Simulations
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
-...
