Business Accounting
Communication
Database
Document Management
e-Commerce
Networking
Office Suites
Personal Finance
Presentation
Project Management
Reports & Forms
Schedule & Contact Management
Spreadsheet
Tax Preparation
Training & Tutorials
Word Processing
|
|
Complete Oracle Designer 6i Curriculum CBT Training CDs |
List Price:
Your Price: |
|
|
|
Product Info |
Reviews |
<< 1 >>
Rating: Summary: Complete Oracle Designer 6i Curriculum CBT Training CDs Review: Course Overview
The Complete Oracle Designer 6i Curriculum introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database, describes how to access data from more than one table using joins and aggregating data using group functions. Learners will create tables and other database objects to maintain and modify these data objects, and teaches how to control both user and object level security in an Oracle database. Learners will also be introduced to the basics of PL/SQL. This curriculum builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous easy-to-understand examples ensure that the concepts are amply illustrated. This curriculum also takes students along a streamlined path through the Oracle Designer development environment. It covers recording business requirements into the Repository including process modeling, entity relationship modeling, and function modeling. Transforming the analysis model into design level definitions, refining the data and application designs, and generating database objects and simple WebServer applications are covered.
This curriculum consists of six courses:
Course 61110 Oracle SQL: Basic SELECT Statements
Course 61111 Oracle SQL: Data Retrieval Techniques
Course 61112 Oracle SQL: DML and DDL
Course 61113 Oracle PL/SQL: Basics
Course 61414 Oracle Designer 6i First Class: Analysis
Course 61415 Oracle Designer 6i First Class: Design and Generate Certification: This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2.
Learn To
See individual course descriptions for specific course objectives and scope.
Audience
The intended audiences for this curriculum include application developers, database administrators, designer/developers, business analysts, project leaders, Web application developers, and technical support professionals. Prior to taking this curriculum, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage.
Deployment Options
e-Learning
Accreditation
NASBA credits: 4 CPE Credits Per Course
Language Options
US English
Total Learning Time
36 to 48 hours
<< 1 >>
|
|
|
|