Oracle Course Outline
What is Oracle?
A management system database (DBMS) is the software that allows a computer to store, retrieve, add, delete and modify data. A DBMS manages all of the primary aspects of a database, including handling data manipulation, such as user authentication, as well as data insertion or extraction. A DBMS defines what is called the data schema or structure in which the data is stored.
Why use a database management system?
The DBMS manages three important things: data, the database engine that allows data to be accessed, locked and modified, and the database schema, which defines the logical structure of the database. . These three fundamental elements help to ensure consistency, security, data integrity and uniformity of administrative procedures.
Typical database administration tasks supported by the DBMS include change management, performance monitoring/tuning, and backup and restore. Many database management systems are also responsible for recovery, restart, and automated recovery, as well as logging and verifying activities.
- What is ORACLE?
- Intro to SQL
- Basic Concepts