Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle Introduction: Subqueries, Reports, and DML |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 4 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Trainee database administrators and application developers |
| Prerequisites |
| Familiarity with programming techniques would be an advantage |
| Course Aim |
| To explain the types of subquery, how to produce reports, and to introduce DML statements |
| Learning Objectives |
| Understand the various subquery types. Retrieve data using subqueries. Produce interactive reports. Write DML statements. Create a script file. Explain database transactions and read consistency. Control transactions. |
| Topics Covered |
| Subqueries - Single-row subqueries - Multiple-row subqueries - Hands-on: Generating subqueries - Multiple-column subqueries - Hands-on: Using multiple-column subqueries Producing reports - Interactive reports - Customizing and formatting - Creating a script file - Hands-on: Writing interactive scripts Manipulating data - The INSERT statement - Updating and deleting data - Hands-on: Executing DML statements Database transactions - Transaction control - Read consistency - Hands-on: Controlling transactions |