INTRODUCTION TO ORACLE DATABASE

Wow i know the first question i would be asked by a curious learner is 'What are databases really? ' The answer to that question lies in the question. Data is information. Where you store this information is what you call a Database. There are several types of database which are in use today , the commonest one in use is the Microsoft Access . It comes in as a handy package with Microsoft Visual basic inputs which make it a good database software.

For the large database which large corporations would love to use to store staff information etc , Oracle proves to be the most acknowledged and useful worldwide. Oracle comes in different certifications or versions. We have had Oracle 9i , Oracle 10g, Oracle 11i (for financial operations ), Oracle 11g and Oracle 12i. It is a very useful software source which derives its power of operations from its security . What do i mean by that ? Well other software do not have the ability to reserve information for a certain class of employees in a corporation , for instance. In Oracle , especially if you run it on Linux Operating System, you can restrict access to information from any class of persons.

In working with Oracle , you must work from the command prompt of a programming language we call SQL -It actually means Structured Query Language. As the name implies , it is used to query the database and retrieve any volume of information which has been stored on the database.
An Example of an SQL Query :


Select  Last_Name, First_Name,Sex
From    Employees
Where   Sex = 'Male' ;
It should be noted that at the end of the query , a semi-colon follows. All SQL  queries must end with a semi-colon . This is the only way it signifies that the query has stopped. The keyword for all SQL queries are SELECT  , FROM AND WHERE others are UPDATE , AND , OR ,REMOVE etc. These keywords help the administrator to retrieve and send information to the database.

I'll rest the matter  here till the next piece. Look out for the next piece.