Opening _oracle for Beginners in Oracle database learning

The Oracle database has recently begun to be studied for project reasons. Oracle is one of the most popular databases, powerful, excellent performance, relative to the difficulty of learning is not small. I am going to write down my learning process and accumulate it to facilitate myself and other learners.

Written in front of the study, mainly:

1, a number of common questions and answers to share a ha;

2. An arrangement for the learning route;

3. Prospect of expected results.

1. Oracle Database Learning FAQ

Question1:oracle database book is difficult to understand, Oracle is really difficult to learn?

Answer1:oracle is a small software that encapsulates complex things, and we learn to manage databases. It's easy. As long as you have the right learning methods, it is not difficult to manage Oracle databases.

Question2: There are many versions of the database, which should I study?

Answer2: All things a reason, the version of the database although many, the essence is the same, the changes are only appearances, you are ORACLE7 experts, must also be oracle10g experts.

Question3: Database There are many platforms, I should learn Which?

Answer3: There are differences on each platform, very small. Windows is the best learning platform.

Question4: There are a lot of tools for managing databases, which should I use?

Answer4:sqlplus The best management tool, you have Oracle when you only use Sqlplus to manage the database.

Question5: What is the hardest part of database learning?

Answer5:sql statement, always SQL, writing efficient SQL is our eternal goal.

Question6: What is the most important job in maintaining a database on a daily basis?

ANSWER6: Backup, always backup, there are all the data.

Question7: What is the basic course of learning a database?

Answer7: Architecture, which is the cornerstone of backing up and optimizing databases.

Question8: How do I measure the level of my database?

Answer8: You can see what you want to see in Oracle database, you get started. You can read everything you know.

Question9: Is the graphics community helpful to database learning?

ANSWER9: Harmful!

QUESTION10: I do not have any computer professional foundation, can learn the database?

ANSWER10: Yes! The database is so simple that everyone can learn it. Like cars, we learn to drive, not to build cars. We do not understand the internal structure of cars, but do not affect our driving cars, our job is to manage the database, not difficult.

Question11:oracle a lot of content, we should master what products?

Answer11:oracle not a person to make out, we do not need to fully grasp, you have mastered the basic principles, in your direction of work. The Division of labor is very thin, a person can not become a master almighty. Life is boundless, knowledge is limitless.

2. Arrangement of Learning Route

The first part sq L Foundation

Basic query statements, DDL, and DML statements

Part II PL/SQ L Foundation

Writing and writing program for anonymous blocks

Third part of the database architecture

Examples of maintenance, control files, log files, data files, table space, the logical structure of the database, the management of the Undo section, table-storage data, the most basic unit, index, constraint management, profile configuration, Rights Management, database character set, metadata

The network configuration of the Part IV database

Part V Backup and recovery of the database

EXP Export and Imp import, cold backup, hot backup, Rman backup and recovery

Optimization of Part VI database

Acquisition data, Shared_pool, other memory optimization, different storage format, SQL statement optimization, different access mode of database

3. Outlook results

Expected results, the basic grasp of the following content

Base section:

Oracle Basic Usage

Oracle User Management

Oracle Table Management

Advanced section:

Queries for Oracle Tables

Oracle's functions

Oracle Database Management

Oracle's permissions, roles

Pl/sql programming

indexes, constraints, and transactions

　　

Later will continue to update, hope oneself can quiet down, steadfast study. Keep practicing, because you can find problems in practice, solve problems, and then improve your ability.