[Opening for Oracle Database beginners]: oracle Database beginners

[Opening for Oracle Database beginners]: oracle Database beginners
Due to project reasons, I recently started to study Oracle databases. Oracle is currently one of the most popular databases, with powerful functions and excellent performance. It is relatively difficult to learn. I plan to record my learning process and accumulate it for myself and other learners. First, I will share the Q & A of some common questions; 2. Arrange the learning route; 3. forecast the expected results. 1. Oracle Database learning FAQ Question1: Oracle Database books are hard to understand. Is oracle really hard to learn? Answer1: Oracle is a small software that encapsulates complicated things. We learn how to manage databases. very simple. as long as you have the correct learning method, it is not difficult to manage the oracle database. question2: There are many database versions. Which one should I learn? Answer2: everything is the same. Although there are many database versions, the essence is the same. What changes are just representations. You are an oracle7 expert and must be an oracle10g expert. Question3: databases have many platforms. Which one should I learn? Answer3: there is a small difference on each platform. Windows is the best learning platform. Question4: There are many database management tools. Which one should I use? Answer4: The best management tool for Sqlplus. When you only use sqlplus to manage databases, you can master oracle. Question5: Which part of database learning is the most difficult? Answer5: SQL statements are always SQL statements. Writing efficient SQL statements is our eternal goal. Question6: What is the most important task for routine database maintenance? Answer6: backup is always a backup, and data is everything. Question7: What are the basic database learning courses? Answer7: architecture, which is the cornerstone of database backup and optimization. Question8: how to measure the level of my database? Answer8: You can see what you want to see in the oracle database. You are getting started. You can understand everything. Question9: Is the graphic interface helpful for database learning? Answer9: harmful! Question10: I don't have any foundation for computer science. Can I learn databases? Answer10: Yes! The database is simple and everyone can learn it. like a car, we learn to drive, not to build a car. we do not understand the internal structure of cars, but it does not affect our driving cars. Our job is to manage databases, which is not difficult. question11: Oracle has a lot of content. What products should we master? Answer11: Oracle is not made by a single person. We do not need to fully master it. you have mastered the basic principles and have a deep dive into your work. the division of labor in the industry is very fine. A person cannot become an all-powerful master. life is boundless and knowledge is boundless. 2. Learning route arrangement Part 1 Basic basic query statements of sq l, DDL and DML statements Part 2 compiling of basic anonymous blocks of pl/sq l and programming architecture instances of database Part 3 maintenance, control file, log file, data file, tablespace, logical structure of the database, undo segment management, table-the most basic unit for storing data, index, constraint management, Profile configuration, permission management, database character set, metadata part 4 database network configuration Part 5 database backup and recovery Exp export and imp import, cold backup, hot backup, Rman backup and recovery Part 6 Database optimized collection data, Shared_pool, other memory optimization, different storage formats, SQL statement optimization, different Database Access Modes 3. Expected results, basic understanding of the following content Basic Part: Oracle basic use Oracle user management Oracle table management advanced part: Oracle Table query Oracle function Oracle Database Management Oracle permission, role Pl/SQL programming index, the constraints and transactions will be updated later. I hope I can stay quiet and study hard. Continue to practice because you can discover, solve, and improve your abilities.