Teaching Situation: All English (because my English is limited, not all understand)
Course Arrangement: A total of 20 classes, 2 hours per class or so, attach a number of quizzes, one of which exams, a final exam.
Test scope: Class content and test content, more difficult than the DBA exam simple.
First talk
Section I.
1. The teacher introduced himself: Eric, an American born in Japan, speaks Japanese and English (that is, does not understand Chinese) and has a professor of Oralce qualifications, aged 50.
2. Eric's email:eric@beihangsoft.cn.
3. I've been looking for some oralce-related learning sites (not Eric's recommendation because he can't read Chinese):
1 Oracle Chinese Community: http://www.oracle.com.cn/cgi-bin/forum_show.cgi
4. Eric's personal website about Dba:http://www.freewebs.com/ericdavid or http://soft.buaa.edu.cn/oracle/courses/dba/dba.htm
5. The teacher first gives examples of commonly used relational databases, such as SQL Server, DB2, Sybase, and Oralce, and also says that non relational databases are also useful, such as access that we know well. Then introduced the C/s structure, I think these people are familiar with, I will not repeat.
6. The teacher also recommended several reference books to learn from the DBA.
OCP oracle9i database-fundamentals I Examination Guide (Chinese version)
Publishing House: Machinery Industry Publishing House
Jason S.couchman waiting for chime to be translated
Release Date: January 2003
Price: 78¥
GB Code: ISBN 7-111-11112-5/tp.2650
Applicable level: Intermediate √ Advanced √
Remark: 1CD
OCP oracle9i database-fundamentals I Examination Guide (English edition)
OCP oracle9i database:fundamentals I Exam Guide
Publishing House: Machinery Industry Publishing House
(US) Jason S.couchman waiting
Release Date: April 2002
Price: 95¥
GB Code: ISBN 7-111-10096-4/tp.2380
Applicable level: Intermediate √ Advanced √
Remark: 1CD
OCP oracle9i SQL Test Guide (English) (if you don't have a basis for SQL, you'll have to buy one more)
OCP Introduction to Oracle9i:sql Exam Guide
Publishing House: Machinery Industry Publishing House
[Beauty]jason S.couchman
Release Date: April 2002
Price: 89¥
GB Code: ISBN 7-111-09756-4/tp.2292
Remark: 1CD
OCP oracle9i SQL Test Guide (Chinese version)
OCP Introduction to Oracle9i:sql Exam Guide
Publishing House: Machinery Industry Publishing House
Original Publishing house: Mcgraw-hill
Jason S.couchman, Chiu Jongpan and other translations
Price: 58¥
GB Code: ISBN 7-111-11279-2/tp.2697
Applicable level: Intermediate √ Advanced √
Remark: 1CD
7. Then the teacher introduced several websites about the exam.
Prepare to create the database: Delete the original redundancy information, if you are not already using the newly installed Oracle, do not perform the following steps
To delete previous database information:
1. Using Windows key +r, open the Run window: Enter command Regeidt, open the registry
2. Locate the hkey_local_machine/system/currentcontrolset/services, and then delete all the "Oracleservice." The key value at the beginning.
3. Open: Control Panel-admin tool-〉 Service; then Delete Service Oracleorahome92tnslistener
4. Locate folder: oracle/ora92/database; then delete all the following files Pws*.*, Init*.*, sp*.*;
5. Locate the folder: Oracle/ora92/network/admin, and then delete the two files Tnsnames.ora and Listener.ora.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.