SQL

                                                                                                                                             <<<        >>>

Introduction to database:-

Data: The properties of anything is called data

Ex:- Meaningful facts, text, graphics,  images, sound, video segments

Information: Data processed to be useful in decision making

Ex: - student got 1^st rank.

Database: To store the information

Earlier days to store information we are using flat file systems like:

1. Spread sheets

2. Folders

3. Ledgers

4. List

The above mentioned storage methods are called as Flat file systems.

Disadvantages:-

Data Redundancy

Limited data sharing

Excessive program maintenence

File System Approach Access:

For each program we have to maintain separate file 

To avoid this drawbacks "RDBMS" came to picture


RDBMS:


It is an advanced version of DBMS with relationships
It is also used to store and manage data with efficient way than DBMS

RDBMS Approach

You can't connect directly to the database it won't allow. So, we used RDBMS.

SQL

Structured query language and purpose is in order to store (or) manage the information with relational database

Sql is a set of standards maintain by the ANSCII group

Installation Procedures for Oracle 10g,11g: 

Installation of Oracle 10g in windows xp:- Click here

Installation of Oracle 11g in windows 7:- Click here

Once after installing the sql prepare the below content and practice it simultaneously

SQL