I am fresher. I want to learn Oracle DB, but I don't know from where I have to start.
Start from Here..
What is
data?
Data is any information in the form of text, numbers, pictures, sound, or video.
Data is any information in the form of text, numbers, pictures, sound, or video.
What is
Database?
A database is a collection of information organised systematically to act on data.
A database is a collection of information organised systematically to act on data.
What is RDBMS(Relational Database Management System) Database?
A database is a collection of information organised systematically in the form of rows and columns so that it can be easily accessed, managed and updated.
A database is a collection of information organised systematically in the form of rows and columns so that it can be easily accessed, managed and updated.
Why do we need any database?
Permanent Storage: You need any database for permanent
storage where you can store n- number of data depends on your storage capacity.
Fine Grained Security: You can secure your data in the
database using advanced features. Database gives you row and column
level security.
High Availability: You can perform hardware/maintenance activity while DB is online.
Performance: Single user or multiple users can access/modify database without degrading database performance at the same time.
Data Backup: You can restore and recover database at
any point in time. Also you can rewind the changes in database.
What is Oracle Database?
The database developed by Oracle Corporation is called as Oracle Database.
The database developed by Oracle Corporation is called as Oracle Database.
- Oracle Database is a relational database management system.
- It is based on client/server architecture.
- It follows the ACID model.
- It is also based on OSI Model.
The software which provides Oracle Database Setup from Oracle Corporation is called as Oracle Database Software.
History of Oracle:
Larry Ellison, Bob Miner, and Ed Oates started a consultancy called SDL (Software Development Laboratories) in 1977 and SDL developed the original version of the Oracle software.
Larry Ellison, Bob Miner, and Ed Oates started a consultancy called SDL (Software Development Laboratories) in 1977 and SDL developed the original version of the Oracle software.
What is SQL?
SQL(Structure Query Language) is the language or medium to communicate with Oracle Database and it is based on relational database management system in row and column format. SQL statements are used to perform tasks such as updating data in a database, or retrieving data from a database.
SQL(Structure Query Language) is the language or medium to communicate with Oracle Database and it is based on relational database management system in row and column format. SQL statements are used to perform tasks such as updating data in a database, or retrieving data from a database.
Thanks for reading this post ! Please comment if you like this post !
Thanks for sharing this informative blog.
ReplyDeleteOracle DBA Online Training
I truly appreciate the time and work you put into sharing your knowledge. I found this topic to be quite effective and beneficial to me. Thank you very much for sharing. Continue to blog.
ReplyDeleteData Engineering Services
AI & ML Solutions
Data Analytics Services
Data Modernization Services