Training
Provided by 123-CBT Computer Based Training
In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features.
Learn To:
Match the different phases of system development life cycle (SDLC) with their features.
Identify features of an Entity Relationship (ER) model.
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 equijoin to retrieve data from multiple tables.
Identify the use of self-join to retrieve data from a table.
Audience:
The audience for this course includes PL/SQL Developers, System Analysts, Technical Consultants, Forms Developers, Portal Developers, and Database Administrators.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Database Management in Oracle 10g
Match the different phases of system development life cycle (SDLC) with their features.
Identify features of an Entity Relationship (ER) model.
Identify features of Relational Database Management System (RDBMS).
Identify the structural components of Oracle 10g.
Identify features of iSQL*Plus.
Identify options available in iSQL*Plus that help interacting with a script file.
Identify uses of various SQL statements.
Unit 2: Basic SQL Statements
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 the use of the WHERE clause in restricting the result set of an SQL query.
Identify the uses of the comparison operators used in a WHERE clause to restrict the query results.
Identify the operators used in logical conditions to restrict query results.
Identify the rules of precedence associated with the WHERE clause.
Identify methods of sorting the result set of a query by using the ORDER BY clause.
Identify substitution variables that are used while retrieving data by using SQL statements.
Unit 3: SQL Functions
Identify features of single-row functions.
Match the character functions with their uses.
Match the number functions with their purpose.
Identify features of the date functions.
Identify features the functions used to convert data types.
Identify the use of nested functions in retrieving data from tables.
Identify features of general functions.
Identify features of conditional functions.
Identify features of types of group functions.
Identify guidelines for using the GROUP BY clause.
Unit 4: Advanced SQL Statements
Identify the use of natural joins to retrieve data from multiple tables.
Identify the use of an equijoin to retrieve data from multiple tables.
Identify the use of self-join to retrieve data from a table.
Identify the use of outer
Training Avaliability and Delivery
This is primarily online training
This is an online eLearning or CBT training program
This program may be available on CD
Contact 123-CBT Computer Based Training for more information
About 123-CBT Computer Based Training - Training Provider
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
- Dreamweaver MX
-...
More Oracle Database 10g Training from 123-CBT Computer Based Training
