An Introduction to Learning Oracle Database Beginners

Foreword: For the project reason, recently began to learn Oracle database. Oracle is one of the most popular databases, powerful, excellent performance, relative to the difficulty of learning is still not small. I am going to record my learning process, make a accumulation, and facilitate myself and other learners.

Written in front of the study, the main is:

1. Share some questions and answers.

2, an arrangement of the learning route;

3. Outlook for expected results.

1. Oracle Database Learning FAQs

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

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

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

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

Question3: There are many platforms in the database, which should I study?

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

Question4: There are a lot of tools to manage the database, which should I use?

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

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 of maintaining a database?

ANSWER6: Backup, always backup, there is data there is everything.

Question7: Which part of the basic course is the learning 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 the Oracle database, you're getting started. See what you can understand, you learn.

Question9: Does the graphics community help with database learning?

Answer9: Harmful and useless!

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

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

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

Answer11:oracle is not a person to do, we do not need to master, you master the basic principle, in your direction of work in depth. The Division of labor is very thin, a person can not become a master of all-round. Life is boundless and knowledge is limitless.

2. Arrangement of learning Routes

First Part sq L Foundation

Basic query statements, DDL, and DML statements

Part II PL/SQ L Foundation

Writing and writing programs for anonymous blocks

The third part of the database architecture

instance maintenance, control files, log files, data files, table spaces, logical structure of the database, management of the undo segment, table-the most basic unit for storing data, index, constraint management, profile configuration, Rights Management, database character set, metadata

Part IV Network configuration of the database

Part V backup and recovery of databases

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

Optimization of Part VI database

Acquisition of data, Shared_pool, other memory optimizations, different storage formats, optimization of SQL statements, different access modes of the database

3. Outlook results

The expected result, the basic grasp the following content

Basic part:

Oracle Basic Usage

Oracle User Management

Oracle Table Management

Advanced section:

Queries for Oracle Tables

Oracle's functions

Oracle Database Management

permissions, roles for Oracle

PL/SQL Programming

indexes, constraints, and transactions

　　

Later will continue to update, I hope I can quiet down, practical learning. Keep practicing because you can find problems in practice, solve problems, and then improve your abilities.

An Introduction to Learning Oracle Database Beginners