Back To Oracle Training Courses

Oracle9i SQL Training CBT Suite

Price: $387.00

CBT Course Overview:

The Self Study Store Computer Based Training Introduction to Oracle9i SQL covers relational database principles and Oracle concepts, writing basic SQL statements, restricting and sorting data, and using single-row functions. Additionally, the student will learn about group functions, subqueries, iSQL*Plus report variables, and the Data Manipulation and Data Definition language statements supported by Oracle9i. This curriculum consists of three courses: Course 61130 Oracle9i SQL: Basic SELECT Statements Course 61131 Oracle9i SQL: Data Retrieval Techniques Course 61132 Oracle9i SQL: DML and DDL Certification: This training course is tied to the certication training to the Oracle9i DBA certification, and is mapped to Exam 1Z0-007.

Total Training Duration:

24 hours

CBT Course Modules:

• Oracle9i SQL: Basic SELECT Statements Training
• Oracle9i SQL: Data Retrieval Techniques Training
• Oracle9i SQL: DML and DDL Training

Training Course Topics:

• Learn the components of the relational model.
• Match the structural elements of a relational database table with their descriptions.
• Sequence the phases of the system development life cycle.
• Match the types of SQL statements with their descriptions.
• Match the capabilities of SQL SELECT statements with their functions.
• Learn the guidelines for constructing basic SQL SELECT statement.
• Write a query that restricts rows returned by using the WHERE clause.
• Write a WHERE clause to accommodate different datatypes.
• Use comparison operators with the WHERE clause.
• Learn the different categories of datatypes.
• Match the character datatypes with their descriptions.
• Learn the features of the NUMBER datatype.
• Learn the four Oracle join types used to display data from more than one table.
• Learn a Cartesian product.
• Retrieve rows from two tables by using an equijoin.
• Learn the features of a group function.
• Write SQL statements that contain common group functions.
• Manage null values when using group functions in a SQL statement.
• Learn the requirements for using subqueries.
• Learn the data structures in an Oracle server.
• Learn the rules for naming tables in a database.
• Learn the DML and transaction control statements.
• Insert rows in a table by using the INSERT statement.
• Add a column to a table in an Oracle database.
• Change the table structure by modifying the characteristics of an existing column.
• Learn the features of an Oracle sequence.
• Create a sequence by using the CREATE SEQUENCE statement.
• Learn the properties of views.