Introduction To oracle database management system

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

slide 1:

Relational Database Concepts A most important part of every business is to keep records. We need to maintain records of our customers the employees of our company the emails etc. To keep all the data individually is quite a difficult and hectic job because whenever we need the records of a particular customer or an employee we need to search manually. It takes more time and still not reliable. Here comes the concept of databases. What is Database A database is a software program which allows for storage and retrieval of information on a computer hard drive file system or other device. A relational database is a database that allows for queries which typically used Structured Query Language SQL to store and retrieve data. Relational databases allow for more efficient queries which use short CPU power and memory allocation as they are optimized for efficiency. However connect to a database is significantly slower than just reading a simple file off of your computers hard drive. The added features of a relational database build this speed decrease worthwhile in many situations.

slide 2:

Using English-like commands SQL users can easily retrieve the Data from Relation Database without using any complex program codes. In general we can use the SQL commands to achieve the following: SELECT: Display the Data stored in tables INSERT: Add rows in the tables DELETE: Remove rows from the tables UPDATE: Modify rows in the tables CREATE/ALTER/DROP: Create modify or drop Database objects GRANT/REVOKE: Control user access level COMMIT/ROLLBACK: Transaction control

slide 3:

Each of the above SQL commands can be classified into one of the following categories: SELECT Queries INSERT /UPDATE/DELETE Data Manipulation Language DML CREATE/ALTER/DROP Data Definition Language DDL GRANT/REVOKE Data Control Language DCL COMMIT/ROLLBACK These commands use in DML to either commit or rollback the transaction How Much a Database Administrator DBA Can Make During his/her Career: Junior DBA An Oracle DBA without college and less than 10 years experience earns about 60k/year.

slide 4:

Mid Level DBA A DBA with a Bachelors degree and ten years full-time work experience can earn up to 110K/year. Senior DBA A senior DBA with a Masters degree 20 years experience managing mission critical database can earn up to 170k/year. Expert Level DBA For those Expert Class Database Administrators with advanced degrees and specialized skills pay is often as high as 200k per year. Download Free

authorStream Live Help