Oracle Database 10g: SQL Fundamentals Self-Study Course

Oracle University Self-Study CD Courses are a great accompaniment and reliable alternative to our inClass courses, and provide an excellent ongoing resource for reviewing key concepts and practicing skills.

In this CD ROM course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Learners will be introduced to the powerful SQL programming language and its features. After learning the basics of SQL, participants will be introduced to advanced features of SQL, such as advanced querying, reporting, schema objects, manipulating large data sets, advanced sub-queries, and storing and retrieving dates according to different time zones.

Audience

• System Analysts
• PL/SQL Developer
• Technical Consultant

Course Topics 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
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