--: UNISOFT TECHNOLOGIES :-

Introduction D2k

INTRODUCTION TO ORACLE 9i: SQL:

		1. Introduction
		2. Writing Basic SQL Statement
		3. Restricting and Sorting Data
		4. Single Row Function
		5. Displaying Data from Multiple Tables
		6. Aggregating Data by using Group Function
		7. Writing Sub queries
		8. Producing Readable Output with iSQL * Plus
		9. Manipulating Data
		10. Creating and Manipulating Tables
		11. Including Constraints
		12. Creating Views
		13. Other Database Objects
		14. Controlling User Access
		15. SQL Workshop
		16. Using Set Operators.
		17. Oracle 9i Date time Functions
		18. Enhancement to the GROUP BY Clause
		19. Advanced Sub queries
		20. Hierarchical Retrieval
		21. Oracle 9i Extensions to DML and DDL Statements

INTRODUCTION TO ORACLE 9i: SQL/PLSQL:

		1. Introduction.
		2. Declaring Variables
		3. Writing Executable statements
		4. Interacting with the Oracle Server.
		5. Writing Control Structures.
		6. Working with Composite Data Types
		7. Writing Explicit Cursors.
		8. Advanced Explicit Cursor Concepts
		9. Handling Exceptions.
		10. Creating procedures.
		11. Creating Functions.
		12. Managing Subprograms ing
		13. Creating Packages
		14. More package Concepts.
		15. Oracle Supplied Packages.
		16. Manipulating Large Objects.
		17. Creating Database triggers.
		18. More trigger Concepts.
		19. Managing Dependencies.

Oracle9iDS: FORMS DEVELOPER

		1. Introduction to Oracle Forms Developer & Forms Services
		2. Running a Forms Developer Application
		3. Working in the Forms Developer Environment
		4. Creating a Basic Form Module
		5. Working with Data Blocks and Frames
		6. Working with Text Items
		7. Creating LOVs and Editors
		8. Creating Additional Input Items
		9. Create Noninput Items
		10. Creating Windows and Content Canvases
		11. Working with Other Canvas Types
		12. Introduction to Triggers
		13. Producing Triggers
		14. Debugging Triggers
		15. Adding Functionality to Items
		16. Run Time Messages and Alerts
		17. Query Triggers
		18. Validation
		19. Navigation
		20. Transaction Processing
		21. Writing Flexible Code
		22. Sharing Objects and Code
		23. Introducing Multiple Form Applications