If you’re a fresher eager to learn Oracle Database but unsure where to begin, this guide is for you. We’ll start with the fundamentals, build your understanding step by step, and help you find a clear path forward. No prior database experience is required. |
📊 What Is Data? Data is any information in the form of text, numbers, pictures, sound, or video. 🗄️ What Is a Database? 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. 💡Why do we need a 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. - 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. 💻 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. ⚙️ What is an Instance? Instance is a platform to access an Oracle database where you can execute SQL commands to access the data from an Oracle database. 🎉 Enjoy the journey!!! 📝 Stay tuned for a detailed blog post on this case !!! |
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !
📢Join Me on:
