1: Relational database theory
Database System Foundation Written by Elmasri and Navathe, Bejamin / Cummings Press
2: Thorough learning inquiry language
Oracle 9i complete reference (Oracle 9i The Complete Reference) is written by Loney and Koch, Oracle Press
Oracle 9i Reference Manual (Oracle 9i SQL Reference Manual)
3: Start learning basic database management work
Oracle 9i DBA Manual (Oracle 9i DBA Handbook By Loney On Oracle Press).
Oracle 9i Concept Guide, Oracle 9i Administrator Guide, and Oracle 9i Backup and Recovery Guide (Oracle 9i Concepts Guide, The Oracle 9i Administrator's Guide, and the Oracle 9i Backup and Recovery Guide are from Oracle documents.
4: Read, read, read again
Oracle Press is an official publishing house of Oracle, with a large number of Oracle related books. There are also other publishers, such as Wrox Press and O'Reilly Press. You can also find Oracle documents to read. There are also many websites and newsgroups. As much as possible, you can continue. Also, you can read them over again to absorb the content you missed during your first reading.
5: Create a test case
I often see that beginners asked some of the foundations, in fact, if they spend some time, these issues are very easy to answer. There is no doubt that you will have a lot of problems when you start learning Oracle. Take a look at these questions You can't answer it yourself. For example, I have been asked to insert null values in columns that have unique constraints. At the beginning, this seems to be a problem that it is not easy to answer. But it is very easy to experiment! Just create a simple table. One of them, if the uniqueness is constrained. Try to insert an empty value in this column. Is it effective? You should be able to answer this question very easy. So why do you want to create these cases? One reason is that you can improve your ability to solve the problem. The skills required to create these cases are the skills to solve the problem. Solution to solve problems will have a great help to your DBA career. Another reason is that with your business development, you will often need to create more complex test cases to ensure the success of the database and applications. In the future, even simple test cases can also form more complex databases and application decomposition.
6: Find a good master
A makers can lead your DBA career (or other similar careers). They can give you an indication, answer questions, and help you save some time during your DBA growth. I hope this article can play a role in good fortune in your career development. If you work with a senior DBA, then that person should have a responsibility to make useful guidance for your career. You can also choose other people to guide you.
7: Participate in local user groups
Many urban cities have local users, and they meet the topic of the database. If possible, participate in one of the local user groups. This will give you a good way to communicate with others.
