This is the opening article for Oracle Database beginners.

This is the opening article for 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.

In front of learning, the main words are:

1. Share some FAQs;

2. An arrangement for the learning route;

3. 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. It encapsulates complicated things. What we learn is to manage databases. It is very simple. As long as you master the correct learning method, it is not difficult to manage oracle databases.

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. Arrangement of learning routes

Part 1 sq l Basics

Basic query statements, DDL and DML statements

Part 2 pl/sq l Basics

Writing and compiling anonymous Blocks

Part 3 database architecture

Instance maintenance, control files, log files, data files, tablespaces, logical structure of databases, undo segment management, table-management of the most basic units, indexes, and constraints of data storage, profile configuration, permission management, database character set, metadata

Part 4 network configuration of the database

Part 5 database backup and recovery

Exp export and imp import, cold backup, hot backup, Rman backup and recovery

Part 6 database Optimization

Data collection, Shared_pool, other memory optimization, different storage formats, SQL statement optimization, different database access modes

3. Expected results

The following are the expected results:

Basics:

Basic Oracle usage

Oracle user management

Oracle table management

Advanced:

Oracle Table query

Oracle Functions

Oracle Database Management

Oracle permissions and Roles

Pl/SQL programming

Indexes, constraints, and transactions

　　

It will be updated later. I hope that I can stay quiet and study hard. Continue to practice because you can discover, solve, and improve your abilities.