Oracle DBA 11g training online in USA|UK - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

Oracle DBA 11g training online in USA|UK

Description:

Oracle DBA 10g Course Syllabus 1.Introduction to Oracle 10g DBA 2.Understanding Oracle working environment 3.Managing Oracle server & instance 4.Oracle Architectural components 5.Installation of Oracle server(on Unix/Linux & Windows) 6.Creating Oracle Database 7.Using Data Dictionary and Dynamic performance views 8.Maintaining control Files 9.Maintaining Redo Log Files 10.Managing Tablespaces and Datafiles 11.Storage structure and Relationship 12.Managing undo Data 13.Managing Tables 14.Managing indexes 15.Maintaining Data Integrity 16.Managing users 17.Managing privileges 18.Managing roles Web : – PowerPoint PPT presentation

Number of Views:24

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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
About PowerShow.com