CS540A Links

Student: Hao Huang    ID: 2860A    
Keyword Index
Looking for English keywords (CTRL+F with NETSCAPE e.g.) normally offers access to information in English language; clicking on the chosen subject will directly lead you to the right URLs. If you prefer, you may, however, use the alphabetical index instead.   ... to the index

Keywork Index

 A   B   C   D   E   F   G   H   I   J   K   L   M 

 N 

  O   P   Q   R   S   T   U   V   W   X   Y 

 Z 

My Home Page:
http://demo.npu.edu/huanghao/index.html

My Web Sites’ Bookmarks:
http://demo.npu.edu/huanghao/mybookmark/My%20Bookmark.html  

CS540A  --  Database Administration  -- Useful Links

Reading Material:

CS540A DBA Oracle9i Database List of Books
http://216.133.192.99/student/index.htm  Classes’ Handouts

SC540A’s News:
http://216.133.192.99/course.htm

CS540A Handout web page:
http://npu21.npu.edu:7777/handout/cs540a/

  or login to npu21,
http://npu21.npu.edu/home/oracle/handout/cs540

Oracle9i Online Documentation:
è   OTN’s  name/passwd:      huaxxxxo@worldnet.att.net / hxxxxxxx9
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/index.htm
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/nav/docindex.htm  

Class 1: include hw1
Find Database Administrator’s Guide in HTML or PDF (a90117.pdf), read Chapter 1.
Oracle9i Database Administrator's Guide : Chapter 1 The Oracle Database Administrator

Find Database Concepts in HTML or PDF (a88856.pdf), read Chapter 1.
Oracle9i Database Concepts : Chapter 1 Introduction to the Oracle Server

Class 2: in the beginning of hw2 ( There are links in hw2 )
Oracle9i Database Concepts : Chapter 1 Introduction to the Oracle Server 
Oracle9i Database Administrator's Guide : Chapter 2 Creating an Oracle Database

Class 3:
Homework Reading Material:
Oracle9i Database Administrator's Guide : Chapter 4 Starting Up and Shutting Down

Class  4:
Reading Material: (in homework)
Oracle9i Database Administrator's Guide : Chapter 6 Managing Control Files
Oracle9i Database Administrator's Guide : Chapter 7 Managing the Online Redo Log

Class 6:
Oracle9i SQL Reference
http://npu21.npu.edu:7777/handout/cs540a/drop_datafile_issue.txt

Class 7:
Oracle9i SQL Reference: 14 SQL Statements: CREATE TABLE
Oracle9i SQL Reference: 10 SQL Statements: ALTER TABLE
Oracle9i SQL Reference: 12 SQL Statements: CREATE INDEX
Oracle9i SQL Reference:   8 SQL Statements: ALTER INDEX
Oracle9i SQL Reference: 15 SQL Statements: CREATE VIEW   
Oracle9i SQL Reference: 11 SQL Statements: ALTER VIEW

Class 8:
PL/SQL  Flashback Queries Go Back and Recover

Class 9:
For other Oracle Management features, please refer to:
oracle password management policy.txt

Oracle9i Database Master Index
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/index.htm

Oracle9i Database Online Documentation
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/nav/docindex.htm

Oracle9i Database Master Glossary
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/mix.901/q73068/toc.htm

Database Administrator’s Guide in HTML or PDF (a90117.pdf)
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90117/toc.htm

Database Concepts in HTML or PDF (a88856.pdf)
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a88856/toc.htm