Who should attend
- Technical consultants
- PL/SQL developers
- System analysts
Course Objectives
- Search data using advanced sub queries
- Retrieve row and column data from tables with the SELECT statement
- Control user access and manage schema objects
- Run data manipulation statements (DML) to update data in the Oracle Database 10g
- Employ SQL functions to generate and retrieve customized data
Product Description
- Identify features of an Entity Relationship (ER) model
- Identify features of Relational Database Management System (RDBMS)
- Identify the SQL statement to retrieve data from tables
- Identify arithmetic expressions used to perform operations on data
- Identify operators used to format results in SQL statements
- Identify features of single-row functions
- Match the character functions with their uses
- Match the number functions with their purpose
- Identify the use of natural joins to retrieve data from multiple tables
- Identify the use of an equi-join to retrieve data from multiple tables
- Identify the use of self-join to retrieve data from a table
- Identify the code for using the INSERT statement
- Identify the code for using the UPDATE statement
- Identify the code for using the DELETE statement
- Identify tasks to be performed for granting system privileges
- Identify tasks to be performed for granting object privileges
- Identify syntax for performing various tasks for maintaining columns
- Identify the code for retrieving data hierarchically from a table
- Identify the code for formatting hierarchical reports
- Identify features of regular expression functions