Oracle DBA 11g training online in USA|UK

1
ORACLE 10gD2K ONLINE TRAINING
2
ORACLE10gD2K

• Oracle 10g D2K Oracle D2K, aka Oracle
  Developer/2000, is a developer tool for Oracle
  version 5 to 7.2. It allows you to design reports
  and data input forms for Oracle databases. It is
  a client/server application development system
  for Windows, Macintosh and Motif from Oracle.
• Oracle D2k (Developer 2000), the front end in
  oracle develop forms and the backend database
  oracle would be storing information and d2k will
  be displaying it. The biggest advantages to a
  computerized database system are speed, accuracy,
  and accessibility. 

3
Oracle 10g D2K  Course Syllabaus

• D2K (Developer 2000) Forms and Reports
• Forms 6i / 10g
• D2K (Developer 2000) Forms and Reports
• Reports 6i / 10g
• Oracle 10g / 11g
• SQL
• PL / SQL

4
Forms 6i / 10g

• Introduction
• Pre-requisites
• Advantages, Features and roles in ERP
• How to install and work with D2K
• Tools used in D2K
• Fundamentals
• Interface of forms
• Types of Data Blocks
• Manipulating Properties
• Creation of Object Groups
• Form Triggers

5
D2K (Developer 2000) Forms and Reports

• Program Units
• PL/SQL Libraries
• Database Objects
• Working with Object Technology
• Record Groups
• LOV
• Advanced Topics of Forms
• Error Handling

6
Reports 6i / 10g

• Introduction
• Advantages, features and roles of Reports in D2K
• Fundamentals of Reports
• Interfaces of Reports
• Creation of Reports using Wizards
• Creation of Reports Manually
• Manual Reports
• Report Triggers
• Creation of Templates
• Communication / Interlinking of Forms Reports
• oracle SQL PL/SQL

7
 Oracle 10g / 11g

• Introduction to DBMS
• Approach to Data Management
• Introduction to Pre-requisites
• File and Filesystem
• Disadvantages of file
• Introduction to Database
• Database Models
• Hierarchal Model
• Network Model
• Relational Model
• Introduction to RDBMS

8
SQL

• Sub Language Commands
• Introduction to SQL Database Objects
• Working with DML, DRL commands, Operator supports
• Built-in Functions
• Grouping the result of a query
• Querying multiple tables
• Working with Sub-Queries
• Oracle SQL PL/SQL
• Integrity Constraints
• Working with DCL, TCL commands
• Maintaining Database Objects

9
PL / SQL

• Introduction to PL/SQL
• The Advantages of PL/SQL
• PL/SQL Architecture, PL/SQL Data Types
• Advanced PL/SQL
• Advanced Version Features
• Implementing Object Technology
• Using LOB 
• Using Collections
• Oracle Database Architectur

10
Contact us

• Ph  9700042555 , 040-65240555
• Address 74-15-4, 3rd Floor, Swarna plaza, Auto
  Nagar, Terminal, Krishna Nagar, Vijayawada-520007
• Website URL
• http//www.sudeeptechnologies.com/courses/oracle/o
  racle-10g-d2k-online-training/84

11
THANK YOU