Certificate in Oracle 8.i/Developer 2000/VB (100 Hours)

updesco oracle courses-10
30
Nov

Course Description

Certificate in Oracle 8.i/Developer 2000/VB (100 Hours)

This Certificate in Oracle 8.i/Developer 2000/VB (100 Hours) course will teach you for the working of Oracle professional and the previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites as each student is required to have a working knowledge of the relational database model as well as SQL and pl/SQL programming skills, this Certificate in Oracle 8.i/Developer 2000/VB (100 Hours) course focuses on the administration of a DBMS including creation, management, maintenance, and operation of a database management system course is part of the computer information technology database certificate plan. completion of this course and the prerequisite courses further prepares the student for a position as an entry-level database programmer and also acts as preparation for Oracle certification test.

Certification

This short-term training program for Oracle8i concept conducted by ETL LABS PVT LTD  is a government certification program. As this institute is an authorized UPDESCO (a govt of UP undertaking) education center, so this certification programs for the Oracle8i concept is verifiable at State Govt Office and website. The duration of this course is 100 Hours.

Learning Outcomes

  • To get a job as an Oracle Database Administrator (Oracle DBA)
  • To understand the basics of Database and RDBMS concepts.
  • For those with some IT experience: To get into Oracle Database Administration
  • To understand the fundamentals of Oracle Database (including Oracle 8i)

Course Curriculum

Total learning: 46 lessons Time: 100 hours
  • Topics Of Oracle  0/16

    • Introduction to DBMS
    • Introduction to SQL
    • Queries
    • Constrains ( Column level, Table level )
    • Reports In SQL *Plus
    • Concept in MYSQL
    • Concept Of Data Types
    • Sequence, Index, Snapshot
    • Introduction Of PL – SQL Language
    • Conditional Controls
    • Iterative Controls
    • Exception Handling
    • Procedures & Functions
    • Cursors
    • Database Triggers
    • Concept Of Object Oriented Database
  • Developer 2000  0/10

    • Introduction to Developer 2000
    • Blocks
    • Exploring Toolbar and Menu Bar
    • PL-SQL Editor
    • Events and Triggers
    • Master Details Relationship
    • Record Group, Lov, Alerts
    • Programs Units, Library, Menus
    • Form Parameters, Call Form
    • Reports
  • Topic Of Visual Basic  0/20

    • Introduction to VB Environment
    • Working With Controls-I
    • Working with controls-II
    • Working with Procedures and Functions.
    • Concepts of Private & Public Procedure
    • Working with Forms
    • Looping
    • The Menu editor
    • VB Graphics
    • Create an application
    • Error handling and debugging
    • Dynamic data exchange & OLE- concept
    • Database Concept
    • Creating Index using visual data manager
    • Find records using index values in data access object
    • Accessing data using SQL-Statements
    • Working with advanced control
    • Data Access Objects- DAO Concepts
    • Creating Application with Database
    • Concepts of Open database connectivity

Instructors

Review

0.0

0 rating

5 stars
0%
4 stars
0%
3 stars
0%
2 stars
0%
1 star
0%