Oracle Complete Learning Guide Line

Salim Mahmud----------------------------------------(Click) Bangladesh information

Introduction: --------------------------------

In this guide you will find all the common things, sql, pl-sql, procedure, function, package, trigger, cursor like many items are described simply, how to install, connection & problem with connection and so on as required for learners.

In addition you will find here a complete project with developer tools. This is a simple project. You can tell it supply chain or small inventory. Actually this project to maintain a shop for ladies mainly garments items.

I have a shop here. I am using this software to maintain this shop. The name of this shop is "Ladies Corner". We are purchasing / buying Ladies / Womens / Girls / kids items from supplier and serving / selling it to our valuable customers. The items are like: Skirt, Tops, Under Garments, Bra, Swimwear Bikinis, Panty, Petticoat, Sleeping gown, Shoes, Beauty items, Cosmetics, Women Fashion Wear, Ladies Shorts, Trousers, Blouses, Beach-wear, Cardigans and so many items for modern Women, teenager girls and kids.

We shall make database for this project and develop a software using developer tools. We shall create Forms, Master details forms, window, canvas, trigger, LOV alert etc step by step which we need to make the complete software.

Some Link items you can find here.

Oracle(PL/SQL) Hand Book (PDF file)

Oracle (PL/SQL) in Bengoli Language (PDF file)

INTRODUCTION
ABOUT ORACLE CORPORATION
DBMS & RDBMS DATABASE TIME LINE

BEFORE INSTALLATION
ORACLE – 8i
ORACLE – 9i
ORACLE – 10g

INSTALLATION
Simple Installation ORACLE – 8i

Installation ORACLE – 9i

Installation ORACLE – 10g

CHECKING INSTALLATION

DOWNLOAD SOFTWARE
COPY TO HARD DISK

3 ways to connect database

SOME PROBLEM HAPPENS DURING CONNECTON
HOW TO MANAGE PASSWORD

Removing Oracle Database

Summary of PL/SQL
SQL

DDL-Data Definition Language

Constraint & Comments

DCL-Data Control Language

DML-Data manipulation Language

TCL-Transaction Control Language

Select Statement

Sub-Query (Select)

All Type of Join

Database Object(View)

Database Object(Sequence)

Synonym & Index

PL/SQL

Simple Variable

PL/SQL BLOCK

Cursor

Procedure

Function

Package

Trigger

FORMS (DEVELOPER)

REAL ESTATE SOFTWARE DEVELOPE (COMPLETE)

Creating Software Class # 1

REPORTS

During learning period I tried to collect data from internet, but for me It was difficult, though Oracle Corporation’s build many site for the beneficiary such as http://www.oracle.com/index.html is enough healthy. There are many sites you can find as bellows: http://otn.oracle.com/, http://metalink.oracle.com/, www.db.cs.ucdavis.edu/dbs, http://www.oracle.com/support/index.html http://www.oracle.com/us/community/index.htm http://www.oracle.com/products/index.html

http://www.oracle.com/industries/index.html

Further, you may find hundreds, thousands or more Oracle related sites in the internet. But? Here, in this site I tried to provide all Oracle related Data, Demo, Tutorial, Tricks and Tips & Techniques. Even you can find all types of files such and PDF, WORD, HTML formated file and so on for Oracle 6i, 8i, 9i and 10g. I collect many of them from internet, some are personally collected and some of from me. I hope, all the documents (together) here will be helpful for New and Advanced for DBA and Developer both equally. I hope and believe it is enough organized and capable to fulfill the requirement of oracle hunter / Oracle users, manily for new; if not then fill free to mail me with your requirement/question: Mahmud15d@gmail.com

Your Success is my goal in the filed of ORACLE