When met database operation and maintenance for the first time, most people didn't know much about it. I don't know where to start my study, so how to learn database operation and maintenance?
Before learning database operation and maintenance, we must first clarify the concept and main work contents:
1. For the operating system and small computers can reach a relatively skilled level of use. At present, Linux is widely used in large and medium-sized enterprises and institutions. The average small business uses Windows.
2. In terms of small computers, it is enough to master IBM or HP's small computer skills. As a professional database operation and maintenance engineer, you need to know more. Including storage technology, network technology, cluster technology, etc.
3. The reason is that the database, as a basic level, involves all aspects of application. When a system has problems, it is often not the database, but other applications that have problems. Professional diagnosis is needed at this time. If engineers do not have an overall grasp of technology, they cannot deal with problems quickly. So, making it difficult to carry out the work.
So, what does database operation and maintenance mainly do?
1. Database configuration and maintenance
2. Configuration and maintenance of the server
3. Operation and maintenance of application software
4. Expansion of Functions
After clarifying these, then see if you had a certain foundation for it. If not, you can first look at the "Database System Concept".
If there is basic knowledge to support, the three Oracle books are easy to understand and classic:
1. "Oracle Database Management Art". A relatively thorough Oracle reference book, is more suitable for beginners.
2. "Programming Art: Deepening Database Architecture". It is classic and has more in-depth content. Oracle DBA Requirements.
3. "Oracle SQL Advanced Programming" mainly talks about SQL. It is a classic must-have book.
These three books are all excellent books. Although other Oracle books are good, they are not as direct as these books. If these three books are similar, you can read others if you are interested. There is a book called "Undisclosed Oracle Secrets". You can learn more and then look at it. If Oracle doesn't get started, it is better to get some official entry documents. In order to lay a good foundation before reading these books.
Then learn at least one host environment (such as Linux) that can run the database. To understand everything about the system. Then learn oracle database, architecture, SQLPL/SQL, tuning, etc. Then various available database services will be built. Such as Data Guard in Data Guardrac cluster.
In actual work, combine with which database you want to use and learn which one. Because there are still some differences in maintenance between SQL Server and Oracle. At the same time, we should learn the related technologies of server and data storage.
After completing this, you can try to learn the DBA direction. Then take this convenience to learn more about Linux operation and maintenance. Many databases are now running on Linux. So, it is best to learn more about Linux systems or some useful things. And Linux has only one direction for DBA under Linux.
Of course, there are many people who learn about the databases running under Windows. It depends on your actual direction. Both should be studied, but the key should be combined with their own grasp. These two are the most basic servers. So, it is quite important for the operation and maintenance of the database.
