Instructor's Notes

(If applicable)

• Oracle 9i Database Administration
• In this course, we will:
• Describe the major architectural components of Oracle9i, including the SGA, background processes and files that make up the physical database
• Query the Oracle 9i data dictionary (e.g. DBA_TABLES, DBA_TABLESPACES) to determine the structure of the database.
• Create administrative users, including granting and using the SYSDBA privilege
• Start and stop a database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT.
• Alter initialization parameter values, including the use of the Oracle 9i Server Parameter File.
• Create new users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles.

Instructor's Notes

(If applicable)

Instructor's Notes

(If applicable)

• This course provides you with the foundation skills necessary to create, maintain and manage an Oracle9i database. In this class we will focus on the techniques and skills necessary for day-to-day database administration tasks such as security, creating users, creating object (tables, tablespaces) and backup and recovery. An in-depth discussion of database architecture is provided.

Instructor's Notes

(If applicable)

• In this course, we will:
• Describe the major architectural components of Oracle9i, including the SGA, background processes and files that make up the physical database
• Query the data dictionary (e.g. DBA_TABLES, DBA_TABLESPACES) to determine the structure of the database.
• Create administrative users, including granting and using the SYSDBA privilege
• Start and stop a database, including the use of various shutdown modes such as IMMEDIATE, TRANSACTIONAL and ABORT.
• Alter initialization parameter values, including the use of the 9i Server Parameter File.
• Create new users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles.

Instructor's Notes

(If applicable)

Instructor's Notes

(If applicable)

• Recent Success Story:
• In addition to his rigorous training and courseware development schedule, Dave was able to speak at a number of Oracle User Group meetings over the last year. He typically delivered sessions on New Features in Oracle9i. Please visit our website, www.SkillBuilders.com, to see where Dave will be speaking next and to view the handouts that accompanied his past presentations. Dave also posts articles of interest on the website.
• Skills:
• Introductory and Advanced Oracle Subjects
• Introductory and Advanced DB2 Subjects
• Web site back end design and maintenance

Instructor's Notes

(If applicable)

• Material Layout
• The slide portion of each page is to show some bullets of key points, code samples, syntax diagrams, etc. This is where we put the focal point of the points we are trying to address at that point in time.
• The notes portion contains text to support the slide. It will amplify and clarify the materials in the slide. When you are in a classroom, you do not have to read the notes before proceeding. The instructor will probably tell you much of what is on the page. But we know that people forget or have trouble taking notes. So we developed this material style to provide you with built in notes for you to review later when you have the time. Outside the classroom, these notes provide valuable insights into the key points above.
• Some pages are completely notes. We had so much detail that we could not fit it onto the notes portion of the page with the slide so we went to another page that has no slide. We always indicate this is going to occur with some note in the lower right hand corner such as "continues…".

Instructor's Notes

(If applicable)

• Conventions Used
• For example, if this were a CODE WORD, you would know it was CODE because it is capitalized. This is simpler to see when it is in the midst of a sentence.
• When we have code that appears in multiple lines like a program sample, you will see:
• This is line 1 of code…
• This is line 2 of code…
• This is line 3 of code…
• This is line 4 of code…
• This is line 5 of code…


• All SkillBuilders Course Names will be bolded, as will any text book references, manual names, or other resources we reference outside this material. Lessons within a course, such as Introduction, will be italicized.

Instructor's Notes

(If applicable)