Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle Introduction: Using Functions and Retrieving Data |
| 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 describe single-row functions, and how to obtain data from multiple tables |
| Learning Objectives |
| Use single-row functions. Understand the various join methods. Explain group functions. |
| Topics Covered |
| Single-row functions - Character and number functions - Working with dates - Hands-on: Using single-row and date functions Additional single-row functions - Datatype conversions - Dealing with the year 2000 - General functions - Hands-on: Using datatype conversions Displaying data from multiple tables - Joining tables - Additional join methods - Hands-on: Using joins Aggregating data - Group functions - Creating groups of data - Hands-on: Using group functions |