Oracle Database 11g Conversion Functions Group Functions and Joins

To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

WEB

Conversion and General Functions| - identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.|Conditional Expressions| - recognize the steps for using the CASE expression and the DECODE function to implement conditional processing.|Using Conversion Functions and Conditional Expressions| - identify and write queries that convert data types and implement conditional processing, in a given scenario.|Group Functions| - recognize the benefits of using group functions to return values for groups of rows.|Creating and Manipulating Group Functions| - identify the steps for creating, restricting, and nesting group functions.|Using Joins| - identify the steps for using joins to return data from more than one table.|Writing Queries Using Group Functions and Joins| - write queries that calculate values for groups of data and return values from multiple tables in a given scenario.|

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 -...