Oracle Database
Oracle Database is Oracle's relational database management system. It stores application data, processes SQL transactions, and gives database administrators controls for security, recovery, performance, and availability.
itDatabases and data storage | OpenSkills.info
Course pathWalk it in order
Look it upDip in anytime
Go furtherLeaves this page
Intro
Oracle Database
Oracle Database is an object-relational database management system. An application connects to a database service and uses SQL to read or change data. The database engine enforces data rules, coordinates concurrent work, and records changes so it can recover after a failure.
Start by separating the database from the instance. The database is the set of physical files that hold data, control information, and redo. An instance is the memory structures and background processes that manage those files. This distinction explains why starting an instance and opening a database are separate operations.
Continue the course
This section is part of the paid course.
See pricing to subscribe, or log in if you already have access.
Where this skill leads
Relevant careers
See how this topic contributes to broader role-level skill maps.
Sources
- https://docs.oracle.com/en/database/oracle/oracle-database/26/cncpt/toc.htm
Supports
- Oracle Database concepts
- SQL
- schema objects
- transactions
- database and instance architecture
- https://docs.oracle.com/en/database/oracle/oracle-database/26/cncpt/memory-architecture.html
Supports
- SGA and instance shared memory structures
- https://docs.oracle.com/en/database/oracle/oracle-database/26/cncpt/CDBs-and-PDBs.html
Supports
- CDB and PDB definitions
- supported multitenant architecture
- https://docs.oracle.com/en/database/oracle/oracle-database/26/multi/introduction-to-the-multitenant-architecture.html
Supports
- CDB administration
- PDB isolation
- consolidation
- common and local users
- multitenant tools
- https://docs.oracle.com/en/database/oracle/oracle-database/26/admin/getting-started-with-database-administration.html
Supports
- administrative accounts
- SYS and SYSTEM guidance
- DBA and administrative privileges
- https://docs.oracle.com/en/database/oracle/oracle-database/26/bradv/toc.htm
Supports
- Oracle backup and recovery documentation
- RMAN study path
- https://docs.oracle.com/en/database/oracle/oracle-database/26/sbydb/introduction-to-oracle-data-guard-concepts.html
Supports
- primary and standby databases
- data protection
- site recovery
- RAC distinction
- https://docs.oracle.com/en/database/oracle/oracle-database/26/racad/real-application-clusters-administration-and-deployment-guide.pdf
Supports
- Oracle RAC administration and deployment study path
- https://github.com/suryadev99/awesome-oracledb
Supports
- curated Oracle SQL Developer
- SQLcl
- and Visual Studio Code extension ecosystem entries
- https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/Tools-Support.html
Supports
- Oracle SQL Developer and SQLcl capabilities
- https://github.com/oracle/sql-developer-vscode
Supports
- Oracle SQL Developer Extension for Visual Studio Code capabilities