Oracle Learning Section II: Creating a data table

Learning content:

A. Creating A database and table space

B. Create users and assign permissions

C. Create a data table

I. Creating a database and table space

(i) Basic concepts of the SQL language

1. Concept

Advanced Structured Query Language and an important bridge for communicating database servers and customers.

The PL/SQL language is a structured query language.

2. Classification:

Data definition language: Create alter drop

Data manipulation language: Insert update delete

Data Control Language: Select

(ii) Two ways to create a database

Mode one: graphical interface;

Mode two: Create Datebase command method. Common

Specific operation steps:

1. Locate the Oracle directory Configuration and porting tool Assistant

2. After opening the graphical interface, follow the steps to complete the creation of the database.

(iii) Data file and table space

1. Oracle data structure: physical and logical

Physics: Data files (storing data)

Log files (information that records modifications to the database)

Control files

2. The tablespace is the logical unit for the Oracle database to store data.

system table Space: User Information

Sysaux tablespace: Do not store user information

Undo Tablespace: The tablespace used to hold the undo information.

Users table space: The tablespace that Oracle recommends for users to use.

Temp Table space: temporary storage of data.

3. A server holds a database, and the project database is differentiated by creating table spaces.

Ii. creating users and assigning permissions

(i) User creation: the distinction between roles and permissions: A role is a collection of multiple permissions.

Three common characters:

Connect: Connecting to a Database

RESOURCE: Creating a trigger to create a Sequence table view index

DBA: All permissions in the system are owned, equivalent to the database administrator.

(ii) Database security

Third, create a data table

(i) Data types in Oracle

(ii) Mastering the creation of data sheets

(iii) Concept of data integrity

Oracle Learning Section II: Creating a data table