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