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, some common questions and answers to share a ha; 2. An arrangement for the learning route; 3. The expected outcome Outlook. 1. Oracle Database Learning FAQ 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's easy to manage an Oracle database if you have the right learning method. 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: are different 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. What is the basic course of the question7: learning database? answer7: architecture, which is the cornerstone of backing up and optimizing databases. question8: How to 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: is it helpful to study database in the graphics field? answer9: Harmful! Question10: I do not have any computer professional foundation, can learn the database? answer10: ! 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 not a person to do it, we do not need to master, you have mastered 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 Part I sq l base basic query statements, DDL and DML statements Part II pl/sq l Basic anonymous block writing, programming the third part of the database Architecture instance maintenance, control files, log files, data files, table space, the logical structure of the database, undo Section Management, table-the most basic unit of storage data, index, constraint management, profile configuration, Rights Management, database character set, meta-data The database's network configuration Part V database backup and recovery exp Export and IMP Import, cold backup, hot backup, Rman Backup and restore optimized data collection, Shared_pool, other memory optimizations, different storage formats, optimization of SQL statements, different access patterns for databases 3, expected results of the forecast results, Basic knowledge of the following basics: Oracle Basic Oracle User Management Advanced section: Oracle Table Queries Oracle's functions Oracle database management permissions for Oracle, role 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.
"The opening chapter of learning Oracle Database Beginners"
