| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: (Fwd) Oracle8i Database Administration Boot camp
No they can do it. Here is what one of thier students was able to accomplish after a one day HTML class.
-> -----Original Message-----
-> From: Garner, John (NESL-IT)
-> [mailto:john.garner_at_northern-electric.co.uk]
-> Sent: Monday, July 30, 2001 3:06 PM
-> To: Multiple recipients of list ORACLE-L
-> Subject: RE: (Fwd) Oracle8i Database Administration Boot camp
-> [small/Sacr
->
->
-> Its all sales!!
->
-> The people that think they can do it quick will pay the
-> cash..... LA LA LA
->
-> BAG OF SHITE I say!!!
->
-> -----Original Message-----
-> Sent: 30 July 2001 20:57
-> To: Multiple recipients of list ORACLE-L
-> [small/Sacr
->
->
-> I would be curious how one can obtain to be "amoung the
-> best" after a single
-> 7.5 hour course which I assume has an 1 hour lunch when most
-> training does
-> similar in about 80-180 hours.
->
-> There is some smart people in this world, and I found out I
-> am not one of
-> them, but trying to tackle this list of objectives I just
-> can't see possible
-> in 6.5 hours.
->
-> Understanding the Oracle Server Architecture
-> Responsibilities of a DBA
-> What is an Oracle 8.1 server?
-> Oracle8i JVM architecture
-> Operating system environment
-> Important subdirectories in ORACLE_HOME
-> Oracle instance components
-> Database files
-> Logical storage structures
-> Blocks, extents and segments
-> Different types of segments
-> Tablespaces
-> Logical structural design
-> Control files
-> Redo log files
-> System change numbers
-> Oracle architectures
-> Optimal flexible architecture
-> Oracle Memory Structures and Processes
-> Oracle instance review
-> Data block buffer cache
-> Redo log buffer cache
-> Shared pool area
-> Large pool area
-> Java pool size
-> Checkpoints
-> Determining when checkpoints occur
-> Program global areas
-> Background processes
-> Using the data dictionary
-> Base tables and static views in the data dictionary
-> Dynamic views in the data dictionary
-> ALL_ views
-> DBA_ views
-> USER views
-> Additional views
-> V$ views
-> GV$ views
-> Useful database data dictionary views
-> Creating an Oracle Instance and Database
-> Database utilities
-> New SQL*Plus features in Oracle 8i
-> The server manager tool
-> Server manager commands
-> Server manager set and show commands
-> The parameter file
-> Oracle installer
-> Setting up a parameter file
-> Important parameters for database creation
-> Starting an Oracle server
-> The STARTUP command
-> Shutdown steps
-> SHUTDOWN command options
-> ALTER DATABASE command
-> Preparation for creating a database
-> Steps for creating a database
-> Setup for UNIX
-> Setup for NT
-> Removing Oracle servers
-> The CREATE DATABASE command
-> Creating a database script
-> What is created?
-> Preinstalled users
-> Preinstalled roles
-> After database creation
-> Troubleshooting database creation
-> Alert and trace files
-> Database limits
-> Working with data dictionary views
-> Dynamic versus static parameters
-> Managing tablespaces and datafiles
-> Logical and physical structures
-> Tablespaces
-> The SYSTEM tablespace
-> CREATE TABLESPACE command
-> CREATE TABLESPACE clauses
-> Creating a tablespace
-> Dictionary-managed space
-> Dictionary-managed tablespaces
-> Locally-managed space
-> Locally-managed tablespaces
-> Managed space for SYSTEM tablespace
-> ALTER TABLESPACE command
-> Temporary tablespaces
-> CREATE TEMPORARY TABLESPACE Command
-> Read-only tablespaces
-> Coalescing tablespaces
-> Using the ALTER TABLESPACE command
-> Taking tablespaces ONLINE and OFFLINE
-> Tablespace offline options
-> Renaming a data file
-> Adding more space to a database
-> Autoextending a data file
-> DROP TABLESPACE command
-> Data dictionary views
-> Oracle8i Tables and Indexes
-> Oracle8i size ceilings
-> Managing large tables with Oracle7
-> Oracle8i data storage
-> What is partitioning?
-> A partitioned table
-> Partition features
-> Advantages of partitioning
-> Creating a partitioned table
-> The partition key
-> Partition syntax
-> Accessing a partitioned table
-> Data dictionary views
-> Using MAXVALUE
-> Partitioning rules to follow
-> Partition naming rules
-> Partition extended table name syntax
-> Restrictions on partition extended name
-> Multi-column partition keys
-> Inserting into a multi-column partition key
-> Modifying partition key values
-> Setting physical attributes for partitions
-> Partition management
-> Oracle8 indexes
-> Index-organized tables
-> Temporary tables
-> Reverse key indexes
-> Managing Rollback and Temporary Segments
-> Database block
-> Block utilization parameters
-> Data dictionary views on storage structures
-> Rollback segments
-> Private versus public rollback segments
-> Typical layout for rollback segments
-> Space usage
-> Sizing rollback segments
-> The OPTIMAL parameter
-> CREATE ROLLBACK SEGMENT command
-> ALTER/DROP ROLLBACK SEGMENT command
-> Using the SET TRANSACTION command
-> Data dictionary views for rollback segments
-> Recommendations for rollback segments
-> Temporary segments
-> Tablespaces and temporary segments
-> Administration of control and redo log files
-> Control file contents
-> Working with control files
-> Multiplexing control files
-> Review of redo log files
-> Writing to redo log files
-> Log sequence numbers
-> Checkpoints
-> Checkpoint events
-> Adding and clearing online redo log files
-> Dropping online redo log files
-> Renaming online redo log files
-> ARCHIVE LOG LIST command
-> Data dictionary views for redo log files
->
->
->
-> "Walking on water and developing software from a
-> specification are easy if
-> both are frozen."
->
-> Christopher R. Spence
-> Oracle DBA
-> Fuelspot
->
->
->
-> -----Original Message-----
-> Sent: Monday, July 30, 2001 2:56 PM
-> To: Multiple recipients of list ORACLE-L
->
->
-> fyi
->
-> ------- Forwarded message follows -------
-> To: <training_at_telecommand.com>
-> Date sent: Sat, 28 Jul 2001 17:45:32 -0700
->
-> Dear IT Professional,
->
-> The training division of Telecommand, Inc. is conducting a
-> 1-Day rigorous
-> hands-on class on Oracle8i database administration. The
-> training will take
-> place in the latest Sun Solaris 8 environment. You will be
-> learning in a
-> ultra small class of 12 students. Ravi Verma who has over 12 years of
-> experience in Oracle database administration is teaching the
-> course. At the
-> end of the day you will be among the very best in the field
-> of Oracle 8i
-> Database administration.
->
-> Please sign up at http://www.telecommand.com/training/
->
-> Following are the details:
->
-> Date: Friday 09/07/2001 and Saturday 09/08/2001
->
-> Place: Computer Science Laboratory at the California State
-> University,
-> Sacramento
->
-> Time: 9:30 AM to 5:00 PM
->
-> Class Size: 12
->
-> Fee: $250.0 We can keep the cost low because we have no overheads!!!
-> Telecommand, Inc. is CMAS certified for classroom training.
->
-> Instructor: Ravi Verma
->
-> Sign up: http://www.telecommand.com/training/
->
-> Course detail:
->
-> This course will teach students the fundamental skills
-> required to manage
-> Oracle databases. Students will learn database
-> administration skills by
-> designing, setting up, configuring, and managing their own
-> Oracle8i server.
-> By the end of the class, each student will have gone through
-> the main tasks
-> necessary to manage Oracle8i databases. New Oracle8i
-> features such as the
-> Oracle8i JVM, locally-managed tablespaces, partitioned
-> tables, global and
-> local indexes, index-organized tables, function-based indexes,
-> object-relational features, the large pool and the Java pool will be
-> covered.
->
-> Audience: Database administrators, application developers, and system
-> administrators.
-> Prerequisites: Oracle for Application Developers. Previous working
-> experience with Oracle is recommended. A solid understanding
-> of SQL and
-> PL/SQL is required. A base understanding of the operating
-> system used for
-> class (UNIX or NT) is needed as well.
->
-> ******
->
-> ...
->
->
-> ------- End of forwarded message -------
-> --
-> Please see the official ORACLE-L FAQ: http://www.orafaq.com
-> --
-> Author: Eric D. Pierce
-> INET: PierceED_at_csus.edu
->
-> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
-> San Diego, California -- Public Internet access /
-> Mailing Lists
-> --------------------------------------------------------------------
-> To REMOVE yourself from this mailing list, send an E-Mail message
-> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
-> and in the
-> message BODY, include a line containing: UNSUB ORACLE-L (or
-> the name of
-> mailing list you want to be removed from). You may also
-> send the HELP
-> command for other information (like subscribing).
-> --
-> Please see the official ORACLE-L FAQ: http://www.orafaq.com
-> --
-> Author: Christopher Spence
-> INET: cspence_at_FuelSpot.com
->
-> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
-> San Diego, California -- Public Internet access /
-> Mailing Lists
-> --------------------------------------------------------------------
-> To REMOVE yourself from this mailing list, send an E-Mail message
-> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
-> the message BODY, include a line containing: UNSUB ORACLE-L
-> (or the name of mailing list you want to be removed from). You may
-> also send the HELP command for other information (like subscribing).
-> *************************************************************
-> *******************************
-> E mail Disclaimer
->
-> You agree that you have read and understood this disclaimer
-> and you agree to be bound by its terms.
->
-> The information contained in this e-mail and any files
-> transmitted with
-> it (if any) are confidential and intended for the addressee
-> only. If you have
-> received this e-mail in error please notify the originator
-> or telephone
-> 0191 210 2060 or e-mail postmaster_at_northern-electric.co.uk.
->
-> This e-mail and any attachments have been scanned for certain
-> viruses prior to sending but neither Northern Electric plc
-> nor any of the companies in the Northern Electric group of
-> companies from whom this e-mail originates shall be liable
-> for any losses as a result of any viruses being passed on.
->
-> No warranty of any kind is given in respect of any
-> information contained in this e-mail and you should be aware
-> that that it might be incomplete, out of date or incorrect.
-> It is therefore essential that you verify all such
-> information with us before placing any reliance upon it.
->
-> Northern Electric plc
-> Carliol House
-> Market Street
-> Newcastle-upon-Tyne
-> NE1 6NE
-> Registered in England and Wales: Number 2366942
->
->
-> *************************************************************
-> *******************************
-> --
-> Please see the official ORACLE-L FAQ: http://www.orafaq.com
-> --
-> Author: Garner, John (NESL-IT)
-> INET: john.garner_at_northern-electric.co.uk
->
-> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
-> San Diego, California -- Public Internet access /
-> Mailing Lists
-> --------------------------------------------------------------------
-> To REMOVE yourself from this mailing list, send an E-Mail message
-> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
-> the message BODY, include a line containing: UNSUB ORACLE-L
-> (or the name of mailing list you want to be removed from). You may
-> also send the HELP command for other information (like subscribing).
->
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: epost_at_kcc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jul 30 2001 - 17:21:15 CDT
 |
 |