Oracle Database Learning

Database (DB)

A database is a collection of large amounts of data that are stored in a computer, organized, and shared over a long period of time. The data in the database is organized, described and stored according to a certain data model. With a small redundancy, high data independence and extensibility, and can be shared for all users. Therefore, the database has a permanent storage, organized, shareable 3 basic features.

Dbms

Scientifically organize and store data, data that can be efficiently acquired and maintained. DBMS and OS are computer system software, also a large system software, the main functions are:

• Data manipulation functions (DML);
• Data definition function (DDL);
• Data organization, storage and management;
• Database creation and maintenance.

Dbs

A system that introduces a database into a computer system. Typically includes DB, DBMS (and development tools), Application System, DBA (responsible for DB setup, use, maintenance). As shown in the following:

Data management has passed through 3 phases: the Human Management Phase---> File system phase---> Database phase.

Installation of Oracle Database

ORACLE12C has 2 compressed files, extracts two zip files, and merges them. The final effect should look like this:

Double-click setup.exe to install and the estimated time to install is 60~90min. The installation process is divided into 11 steps.

First step: Uncheck Receive security updates.

Step Two: Skip the software update.

Step Three:

Oracle Database Learning