Step-by-Step oracle Learning

1. Basic knowledge of database principles, concepts of rows and columns, and knowledge of relational databases are required.

2. You have an environment learning database, such as an XP installation, a company minicomputer, or a PC, linux, solaris,

AIX, or hp-unix.

3. Start to learn the basics of SQL. DML, DDL, DCL, and so on. Go through SQL first.

4. Install oracle, 9i or a later version, or 10 Gb. However, in terms of materials, it is difficult to solve problems in learning, because the most users are not. The three concepts ($ oracle_base, $ oracle_home, SID) must be clear.

5. start to learn about oracle, and shut down the basic startup (only after startup and shutdown immediate), and then learn SQLplus (set environment variables and formats ), learn iSQL * PLUS at the same time (this requires the httpserver service to be started in advance ). OK, you have basically done it.

6. oracle architecture learning: instance + db = oracle server.

Instance = SGA + background processes.

Database = controlfile + datafile + redolog file

Be sure to understand. after learning about some basic concepts, you will ask what the tablespace is, how the table is, how the log is managed, how the control file cannot be viewed, how the oracle is started, and how to close it, what are the benefits of disabling this function? I heard that a table has an index. What is this? I heard that oracle has five objects. What is it? What are five common constraints? OK. learning knowledge means learning more and more problems.

7. what you need now is not to solve the above problem, but to configure the network. You need to understand listener. ora, tnsnames. ora, sqlnet. ora, because you want to use databases or databases on the network, you need to configure these three files. First, you can learn oracle without any time.

8. solve the above problems mentioned in section 6. Learning oracle SQL, of course, is compatible with the standard (9i compatible with sql99 ).

9. After practice: you have learned about it:

Tables, indexes, views, indexes, and synonyms are oracle5 objects.

Five constraints: primary key, foreign key, not null, unique, and check.

Startup nomount, mount, and alter database open.

To disable the service.

Role of sysdba user, password creation and modification.

Create a user, role, authorize, and revoke permissions.

Tablespace, segment, extent, db block. datafile, and OS block relationships.

Tablespace, datafile. Redolog management, controlfile backup.

Detailed learning of tables, indexes, and views. Including storage parameters.

Learn about undo tablespace and rollback segment.

Oracle character set learning.

OK. You can delete the database before creating the database. Because you have a basic understanding of what is used during the creation process.

Html ">