This is a bit like book-selling: All you wanted to know about C++ and
Oracle in 24 hours, including the Idiot's guide to the Mystery of Life and
how to successfully avoid reincarnation with minimum effort. Avoid the
mistake of having to live your life all over again! Just send us US$60 and
believe in us and you will be saved.
Once you buy the book, or pay for the course, who cares if you don't come
back? They have your money. The business is not based on return customers,
they are aiming for people who want to make a quick career transition.
As for satisfaction guaranteed, I don't know what the customer-protection
laws are like in the U.S. but reading some of the software disclosure
legalese on some CD shrinkwrap, there don't appear to be any laws to protect
consumers. It's good for the economy! We can't afford to slow down
industry output...
To be fair, it's a competitive market for training schools. To stay afloat,
they end up having to market the impossible.... like some software
companies.
I always believed that vulnerable people tend to get taken advantage of
because people only do what's right if the consequences are worse if they do
what is wrong. It's not a will or character issue, it has more to do with
entropy - to conserve energy, people tend to take the easy route. They run
on autopilot most of the time, on habits.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-----Original Message-----
From: Garner, John (NESL-IT)
[SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 7: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: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Boivin, Patrice J
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).