Database:
In simple words, Database is a collection of meaningful information.
DBMS:
DBMS stands for Database Management System. DBMS is a collection of programs or codes that create for managing a database.
RDBMS:
RDBMS stands for Relational Database Management System which is based on the relational data model of database. Now, in relational database system all the data or information is stored in form of tables.Oracle:
Oracle is an object Relational Database Management system(RDBMS). Almost half of RDBMS worldwide markets is owned by oracle. For work with oracle SQL we need oracle database. Now, oracle database is a database created in oracle.
Oracle Database :
Oracle database contains two parts - 1)Logical Structure & 2)Physical Structure. Logical Structure contains tablespaces, schema objects, segments and extents. And the physical structure contains Datafiles, Redo log files, control files, log files etc.
Now, as we discussed previously in RDBMS all data is stored in form of tables and that tables with other objects are stored in tablespace logically. But physical they are stored in Datafiles.
Redo log files is nothing but a logging file that track all the changes made in the database. There is also another file called control file thar contains all the database name and location of the other files.
Now, as we discussed previously in RDBMS all data is stored in form of tables and that tables with other objects are stored in tablespace logically. But physical they are stored in Datafiles.
Redo log files is nothing but a logging file that track all the changes made in the database. There is also another file called control file thar contains all the database name and location of the other files.
What is Oracle SQL:
 |
| Oracle SQL |
SQL stands for 'Structure Query Language' designed for retrieval and management of data in relational database. SQL is a fourth generation language. Now, Oracle SQL is nothing but the SQL language designed for work with Oracle database.
Oracle SQL Process:
Oracle SQL works in some steps.
- User input the SQL command in command window.
- SQL command go to the Oracle database and find the related data user want.
- When found the matched data in database return the data to user.
So, as we see in this following process a user can access or modify a oracle database with the use of oracle SQL language.
Oracle SQL Classification:
On the basis of the multiple types of operations that we can perform with SQL we have five classification.
1. Data Definition Language: SQL commands used to define some database object like create table, drop table etc.
2. Data Manipulation Language: SQL command used to insert, update or modify the data inside a table.
3. Data Retrieval Language: SQL commands used to retrieve data from table.
4. Data Control Language: SQL commands used to control the database accessibility.
5. Transactions Control Language: Control the multiple SQL commands for each work properly.
in upcoming posts we will discuss this five classifications in more detail. So, this is for now, if anyone have any question, then ask me in the comment box, thank you.
1. Data Definition Language: SQL commands used to define some database object like create table, drop table etc.
2. Data Manipulation Language: SQL command used to insert, update or modify the data inside a table.
3. Data Retrieval Language: SQL commands used to retrieve data from table.
4. Data Control Language: SQL commands used to control the database accessibility.
5. Transactions Control Language: Control the multiple SQL commands for each work properly.
in upcoming posts we will discuss this five classifications in more detail. So, this is for now, if anyone have any question, then ask me in the comment box, thank you.
No comments:
Post a Comment