Upon environment:
Windows2000 Oracle 9i
Teaching situation: full English (due to my English is limited, not all understand)
Course Arrangement: Total 20 lessons, each lesson is generally about 2 hours, additional small tests, one of them, once the final exam.
Examination range: The content of the class and the test content, the difficulty is simpler than the DBA test.
First lecture
First section
1. Teacher introduces yourself: Eric, Americans who are born in Japan, speak Japanese and English (that is, I don't understand Chinese), have professor Oralce certification qualifications, and is 50 years old.
2. Eric's email: Eric@beihangsoft.cn
3. I found some Oralce related learning websites (not Eric recommended because he couldn't understand Chinese):
1) Oracle Chinese Community: http://www.racle.com.cn/cgi-bin/forum_show.cgi
2) Oracle Free FTP: 218.94.123.17 users: Download Password: Oracle
3) Oracle Technology Network: http://www.oradb.net/newuser.htm
4) Free Oracle entry: http://fengyu.china.com/
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 exemplifies the common relationship database, such as SQL Server, DB2, Sybase and Oralce, etc., and also saying that non-relational databases are also useful, such as our familiar Access. Then introduced the C / S structure, I think these everyone is already a light car, I will not have repeated it.
6. The teacher recommended a few studies of DBA reference books.
OCP Oracle9i Database-Fundamentals I Exam Guide (Chinese Version)
Publisher: Machinery Industry Press
Translation author :( US) Jason S.Couchman waiting to chime translated
Publishing date: January 2003
Pricing: 78 ¥
National Standard No .: ISBN 7-111-11112-5 / TP.2650
Applicable level: Intermediate √ Advanced √
Remarks: 1cd
OCP Oracle9i Database-Fundamentals I Exam Guide (English)
OCP ORACLE9I DATABASE: Fundamentals I Exam Guide
Publisher: Machinery Industry Press
Translation author :( US) Jason S.Couchman waiting
Publishing Date: April 2002
Pricing: 95 ¥
National Standard No .: ISBN 7-111-10096-4 / TP.2380
Applicable level: Intermediate √ Advanced √
Remarks: 1cd
OCP Oracle9i SQL Exam Guide (English version) (if you have no foundation for SQL, you have to buy more)
OCP Introduction to Oracle9i: SQL Exam Guide
Press: Machinery Industry Press translation of: [US] Jason S.Couchman the
Publishing Date: April 2002
Pricing: 89 ¥
National Standard No .: ISBN 7-111-09756-4 / TP.2292
Remarks: 1cd
OCP Oracle9i SQL Exam Guide (Chinese Version)
OCP Introduction to Oracle9i: SQL Exam Guide
Publisher: Machinery Industry Press
Original Publishing House: McGraw-Hill
Translation author :( US) Jason S.Couchman the Pan translated Qiuzhong
Pricing: 58 ¥
National Standard No .: ISBN 7-111-11279-2 / TP.2697
Applicable level: Intermediate √ Advanced √
Remarks: 1cd
7. Then the teacher introduced several websites about the exam.
www.prometric.com
Www.3test.com/tcl/index.jsp
Www.register.prometric.com
Www.transcender.com
Http://otn.racle.com/pls/db92/db92.docindex?remark=homepage
http://download-west.Orcle.com/docs/cd/b10501_01/server.920/A96524/
Section 2:
Prepare for creating a database: Delete the original redundant information, if you are not used for the newly installed Oracle, please do not perform the following steps
Delete the previous database information:
1. Use the Windows button R to open the Run window: Enter the command regeidt, open the registry
2. Find hkey_local_machine / system / currentControlSet / Services, then remove all key values starting with "ORACleService.".
3. Open: Control Panel -) Administrative Tools -> Services; then delete service OracleraHome92TNSListener
4. Find a folder: Oracle / ORA92 / DATABASE; then remove all the following files PWS *. *, Init *. *, Sp *. *;
5. Find a folder: Oracle / Ora92 / Network / Admin, then delete two files of tnsnames.ora and listener.ora.
Everything OK, next get out of class. .
