Basic Concepts of Oracle

• Introduction

1) Data Base (database)

A storage warehouse for storing data and managing data is a collection of data that is effectively organized together.

2) Common database software

Large database: Oracle

Small database: MySQL MySQL

3) RDBMS (relational Database Management System)

The relational database management system is a part of database software used to operate and manage database, which can establish, use and maintain database, referred to as RDBMS. It has unified management and control of data to ensure the integrity of data security.

4) SQL (structured Query Language)

SQL Voice can be used to query the data, manipulate the data, define the data, control the data, so that software developers, database administrators can use the SQL language to perform specific operations on the database.

Database definition Language (DDL): data definition language>>create Delete droptruncate

Database manipulation Language (DML): Data manipulation Language>>insert Update Delete

Database Query Language (DQL):D ATA query Language>>select

Transaction Control Language (TCL): Transaction control Language>>commit Roollback savepoint

5) DBA (database Administrator) administrator

6) Concepts of database and database objects

Database: Refers to a file on a physical disk

Database objects: Objects that exist in memory for interacting with database files

Basic Concepts of Oracle