Description:

This course will introduce programming techniques and data structures that will help participant to take further courses of Oracle in either Developer track or DBA track. This course is basically designed for those who are very keen to learn programming magic.

Contents:

Introduction to Operating System
Introduction, DOS commands and Windows

Microsoft Word
Opening, Creating and Saving Documents, Typing and Selecting, Working with Tables, Adding borders, Checking spelling and grammar, Printing.

Microsoft Excel
Creating, Opening and Saving worksheet, Entering and Selecting Data, Creating Formulas and Printing.

Data Structure and Programming Techniques
Introduction, Data Structure Operation, Algorithm, Searching of ALGORITHM, Mathematical Notation, Loops, Array, Records, Pointer & Bubble Sorting.

FoxPro - Language
Introduction, Structure of Fox Programs, Variables, Operator, Input/Output functions, conditional statements, Functions & Array.

 

Description:

Participant will learn about the general features of 4-GLs, Relational Databases, and Developer/2000 tools. They will learn the art of designing an effective GUI based application using D2K modules. After completing this course you will be able to appear in Oracle Certified Professional (OCP) test.

Contents:

SQL & PL/SQL
Introduction, creating, changing, deleting database objects, database manipulation, controlling user privileges, displaying information from multiple tables, DDL, DML, DCL, Query Instructions, PL/SQL Blocks, variable declaration & data types, delimiters and identifiers, PL/SQL functions, handling control structures, loop, exceptions, cursors, procedures, functions, packages, libraries.

Oracle Forms 5.0
Introduction, creating simple GUI application, creating master detail, interface events, working with canvas, items windows, alerts, writing procedures, triggers, property classes, LOVs visual attributes, defining & attaching libraries, working with manus, creating none-input items, pop list, combo boxes, T-list, layout editors, responding to mouse events, etc.

Oracle Reports 3.0
Introduction, Features and basic concepts, data models, queries, groups, columns, data links, working with layouts, working with frames, managing lexical and bind variables, interfacing with other development tools.

Oracle Graphics 3.0
Introduction, creating chart, using graphic items in forms and reports, Using timer effectively.

Group Project
Participant will have to develop a medium size project alongwith development of user manual. Complete supervision will be provided by OCLITS staff to each group/individual for successful completion of an effective project.

Description:

Participant will introduced to the Oracle 8 Server architecture and mechanism underlying key administration tasks. How to manage logical and physical storage structures, manage access to data by granting privileges to individuals users, course you’ll be able to appear in OCP (Oracle Certified Professional) DBA track.

 

Contents:

SQL & PL/SQL
Introduction, create a database design, retrieve and display information, manipulate information, create tables and database structures, control user access, Perform computation with data, Display data from multiple tables, Pass values between queries, Develop application using procedural capabilities (PL/SQL), Code decision and repetitive action Handle PL/SQL Errors, Modularize programming with procedures and functions.

Database Administration
Overview of Oracle 8 Architecture, Starting up and shutting down an instance, Creating a database, accessing data, managing transaction concurrency, managing the database structures and storage allocation. Managing roll back segments and table & index segment, managing cluster segment constraints, database users, resource usage and database access, managing roles, auditing the database, specify national language, support behavior, advance architecture.

Backup & Recovery
Backup and Recovery strategies, Recovery theory, practice and methods, optimize 24-Hour Operations, perform and complete recovery, describe logical b & r, Oracle export/import Utilities, troubleshooting, implement a standby database.

Performance Tuning  Workshop
General concepts in Database tuning. Tuning memory usage, Tuning Data manipulation Tuning physical storage, Reducing network traffic, tuning SQ, contention issue Database locking.

Note :

Project :

Participant will be introduced to development of projects. On participants' request, brief instructions can be given for development of a medium size project.

 

Description:

Participant will learn about the general features of 4-GLs, Relational Databases, and Developer/2000 tools. They will learn the art of designing an effective GUI based application using D2K modules. After completing this course you will be able to appear in Oracle Certified Professional (OCP) test.

 

Contents:

SQL & PL/SQL
Introduction, creating, changing, deleting database objects, database manipulation, controlling user privileges, displaying information from multiple tables, DDL, DML, DCL, Query Instructions, PL/SQL Blocks, variable declaration & data types, delimiters and identifiers, PL/SQL functions, handling control structures, loop, exceptions, cursors, procedures, functions, packages, libraries.

Oracle Forms 5.0
Introduction, creating simple GUI application, creating master detail, interface events, working with canvas, items windows, alerts, writing procedures, triggers, property classes, LOVs visual attributes, defining & attaching libraries, working with manus, creating none-input items, pop list, combo boxes, T-list, layout editors, responding to mouse events, etc.

Oracle Reports 3.0
Introduction, Features and basic concepts, data models, queries, groups, columns, data links, working with layouts, working with frames, managing lexical and bind variables, interfacing with other development tools.

Oracle Graphics 3.0
Introduction, creating chart, using graphic items in forms and reports, Using timer effectively.

 

Note :

Project :

Participant will be introduced to development of project only.

 

Description:

Participant will learn about the general features of 4-GLs, Relational Databases, and Developer/2000 tools. They will learn the art of designing an effective GUI based application using D2K modules. After completing this course you will be able to appear in Oracle Certified Professional (OCP) test.

 

Contents:

SQL & PL/SQL
Introduction, creating, changing, deleting database objects, database manipulation, controlling user privileges, displaying information from multiple tables, DDL, DML, DCL, Query Instructions, PL/SQL Blocks, variable declaration & data types, delimiters and identifiers, PL/SQL functions, handling control structures, loop, exceptions, cursors, procedures, functions, packages, libraries.

Oracle Forms 5.0
Introduction, creating simple GUI application, creating master detail, interface events, working with canvas, items windows, alerts, writing procedures, triggers, property classes, LOVs visual attributes, defining & attaching libraries, working with manus, creating none-input items, pop list, combo boxes, T-list, layout editors, responding to mouse events, etc.

Oracle Reports 3.0
Introduction, Features and basic concepts, data models, queries, groups, columns, data links, working with layouts, working with frames, managing lexical and bind variables, interfacing with other development tools.

Oracle Graphics 3.0
Introduction, creating chart, using graphic items in forms and reports, Using timer effectively.

 

Project :

Besides developing a medium size project alongwith development of user manual in the last two months participants will be working on a REAL LIFE PROJECT. Complete supervision will be provided by OCLITS staff to each group/individual for successful completion of the projects.

 

Description:

Participant will learn about the general features of 4-GLs, Relational Databases, and Developer/2000 tools. They will learn the art of designing an effective GUI based application using D2K modules. After completing this course you will be able to appear in Oracle Certified Professional (OCP) test.

 

Contents:

SQL & PL/SQL
Introduction, creating, changing, deleting database objects, database manipulation, controlling user privileges, displaying information from multiple tables, DDL, DML, DCL, Query Instructions, PL/SQL Blocks, variable declaration & data types, delimiters and identifiers, PL/SQL functions, handling control structures, loop, exceptions, cursors, procedures, functions, packages, libraries.

Oracle Forms 5.0
Introduction, creating simple GUI application, creating master detail, interface events, working with canvas, items windows, alerts, writing procedures, triggers, property classes, LOVs visual attributes, defining & attaching libraries, working with manus, creating none-input items, pop list, combo boxes, T-list, layout editors, responding to mouse events, etc.

Oracle Reports 3.0
Introduction, Features and basic concepts, data models, queries, groups, columns, data links, working with layouts, working with frames, managing lexical and bind variables, interfacing with other development tools.

Oracle Graphics 3.0
Introduction, creating chart, using graphic items in forms and reports, Using timer effectively.

 

Operating System Concepts
Operating System Objectives and Functions, Process and Threads, Multiprogramming, Multiprocessing, Distributed Processing, Single and Multi-user Operating System, Paging Techniques, Storage media, File Allocation Table, Caches, RAMS, ROMs.

Windows NT / UNIX Operating system
Advance Concepts, Creating users and assigning rights, Installation workshops, and Security Issues.

Networking Essentials
Concepts and Terminology, LAN Technology (Bus/Tree LANs, Ring LANs Star LANs, Wireless LANs), LAN Systems (Ethernet and fast Ethernet, Token Ring0, Cabling, Hardware (hubs, Bridges), WAN Technology (OSI Model/TCP/IP) Protocol, Internet/intranet/Extranet, Routers.

Database Administration
Overview of Oracle 8 Architecture, Starting up and shutting down an instance, Creating a database, accessing data, managing transaction concurrency, managing the database structures and storage allocation. Managing roll back segments and table & index segment, managing cluster segment constraints, database users, resource usage and database access, managing roles.

Backup & Recovery
Backup and Recovery strategies, Recovery theory, practice and methods, optimize 24-Hour Operations, perform and complete recovery, describe logical b & r, Oracle export/import Utilities, troubleshooting, implement a standby database.