|
| |
ORACLE 8 DEVELOPER 2000 VISUAL BASIC:
Objective :
This course intends to make students experts in the latest
version of popular RDBMS package, Oracle 8.0.The front-end tool used is Developer 2000. It
covers Forms 5.0 & Reports 3.0.
Eligibility :
10+2 with working knowledge of Windows and at least
one programming language, preferably C OR working knowledge of any DBMS package,
preferably FoxPro or Access
Fees:
click
to view the Fee Details
Course Contents:
A. INTRODUCTION TO RDBMS
- Overview of Database Management
- Entity Relationship Model
- Traditional Data Model
- Relationship Data Model
- Network Data Model
- Hierarchical Data Model
Relational Model
 | Relations |
| Normalization |
| Relational Operations |
| Relational Calculus |
SQL
| Components of SQL |
| Data Definition |
| Data Manipulation |
| Data Control |
Embedded SQL and
Application Programming Interfaces
| SQLCA |
| Cursors |
| Open Database Connectivity (ODBC) |
B. ORACLE 8
Introduction to Oracle
Oracle Server and Architecture
| Structure in Oracle |
| The Oracle Instance |
| The Oracle Memory Structure |
| Oracle Server |
Advanced SQL
| SQL DDL Command |
| SQL DML Commands |
| SQL DCL Commands |
| Query, Function, Views |
| Indexes |
| Clusters, Hash Cluster |
SQL*PLUS
PL/SQL
| PL/SQL and its uses |
| Block, Variables, Constants |
| Declaration Using Attributes |
| Different Operators |
| IF..... |
| Looping |
| GO TO Statements |
| Identifier |
| Different Data types |
| Exceptions & Cursors |
| Procedures and Functions |
| Packages |
| Arrays |
| Triggers |
User and Security DBA
Concepts
| DBA Utilities |
| Managing Storage |
| Database Security, Backup Recovery |
C. DEVELOPER 2000
Introduction to Developer 2000
Forms 5.0
| Details of Canvas Views |
| Working with windows |
Events And Triggers
| Introduction to Events |
| Types of Events |
| Creating & Compiling Triggers |
| Writing Trigger Code |
| Handling Runtime Errors in Triggers |
| Using PL/SQL Exception Handling in Triggers |
| Details of different properties of Triggers |
Master Detail
Relationship Alerts, Record Groups and Lov
| Creating and Displaying Alerts |
| Working with Alerts |
| Record Groups |
| Creating a Record Group at Design Time |
| Viewing the Structure of your Record Group |
Interface Item
| ActiveX and OLE |
| Buttons |
| Calculated Items |
| Image |
Menu 3.0
| Menu Objects |
| Menu Object Names and Labels |
| Menus and Menu Items |
| Defining Menu Access Keys |
| Menu Toolbars |
| Popup Menus |
| Menu Editor |
Report
Builder 3.0
| Invoking Report Builder |
| Tabular Report |
| Form-Like Reports |
| Mailing Label Reports |
| Form Letter Reports |
| Group Left Reports |
| Group Above Reports |
| Matrix Reports |
| Representing Data Graphically |
| Web Reports |
Object
| About Objects |
| To Create a Table on the Local Database |
| To Select a Database Object Folder |
Partition
| Partitioned Objects |
| Table Partitioning |
| Improved parallelism |
| Partition |
Fee Structure :-
| LUMPSUM |
LIMITED INSTALLMENT |
MONTHLY
INSTALLMENT |
| AMOUNT/MONTH |
NO. OF MONTHS |
TOTAL |
DOWN PAYMENT |
AMOUNT/MONTH |
NO. OF MONTHS |
TOTAL |
| 6,000.00 |
3,100.00 |
2 |
6,200.00 |
2,200.00 |
1,340.00 |
3 |
6,220.00 |
<<Back To Top
|
