Oracle 10G Developer@Denn Technologies Inc.

Run data manipulation statements (DML) to update data in the Oracle Database 10g Use the SET operators to create subsets of data Create tables to store data Utilize views to display and retrieve data Create sequences to generate numbers Obtain meta data by querying the dictionary views. Identify the major structural components of Oracle Database 10g Create reports of sorted and restricted data Employ SQL functions to generate and retrieve customized data Create reports of aggregated data Write SELECT statements that include queries Retrieve row and column data from tables with the SELECT statement

Advantage of the COURSE

• Use SQL Statements to retrieve data from tables
• Create and Manage Tables
• Employ SQL functions to generate and retrieve customized data
• Run data manipulation statements (DML) to update data in the Oracle Database 10g

Core TOPIC

• Writing SQL SELECT statements
• Using the Oracle SQL Developer Environment
• Restricting Data
• Sorting Data
• SQL Functions