If you
need specifics for a home learning environment setting up Oracle 8.1.7.4 on a
Gentoo linux box at home is a great learning exersize. (I've yet to do the
Gentoo thing, RedHat right now)
(You
need at least two computers at home...List how many computers do you have at
home.....be honest...even the dead ones...)
And to
do so without useing the Database configuration assistant. Then go through
upgrades to 9.2.0.4
Set up
some locally managed tablespaces, enable archive logging, write some hotbackup
and coldbackup scripts, alter datafiles, make new ones, load some bogus data, do
exports, imports. Drop table and recover them from exports, break the database,
recover from backups....set up procedures for adding new users of pretend
application. Create roles for developers, users and analysts...write a PL/SQL
program to generate gobs of fake test data. Hotbackups everynight, nightly
processing jobs, trunc tables and move data around....
Fiddle
with connection manager, OMS, OEM, the agent and Oracle Names. Run various DBA
tools TOAD, dbVisualizer do some connections with JDBC and setup apache with PHP
and write a few goofy pages to query the data dictionary and format output to
your browser. Convert OraHoo0.5 from Oracle function to OCI functions (that's a
fun exercise)
All of
that is free and downloadable with plenty of documentation. That experience
alone will do a ton for you and keep you busy at home for months. pretty much
all of the network, OS and database skills are covered. And you can say you've
been exposed to performing these tasks and if you put all your scripts your
write on a cd you can take it with you for a long time. We all have our pile
o'scripts we take with from place to place.
Have
fun!
Brad
O.
-----Original Message----- From: Saira Somani-Mendelin
[mailto:saira_somani@yahoo.com] Sent: Wednesday, December 17, 2003
1:24 PM To: Multiple recipients of list ORACLE-L Subject:
RE: Career Advice
Is it that difficult
though? Just to get familiar with it… if you’ve worked with other similar
software before?
I guess you’d be
looking at a lot of theory, and not nearly enough practice. But then, how do I
get obtain these more attractive, marketable skills? I must start somewhere,
no?
Thanks,
Saira
-----Original
Message----- From:
ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of eric king Sent: December 17, 2003 1:55
PM To: Multiple recipients of
list ORACLE-L Subject: Re:
Career Advice
That right, packaged software like
SAP and PeopleSoftware should be learned in the real implementation or real
usage case. By simply getting the software and use it yourself, it is very
difficult to even grasp the basic idea about those business
transactions.
Your enthusiasm is
admirable, but I think that it would be extremely difficult for you to learn
any of these packages without actually being in an environment where
they are used.
It may be that Tecsys is a
complex set of apps on the same level as SAP or Oracle Apps, and
if so, then maybe that background would prepare
you to tackle this on your own.
Either way, it
will be difficult without access to official support, which you won't have unless
you're in a working environment that includes the app you are attempting
to learn.
You would also not have
exposure to the people that are actually using the stuff, which is
pretty important for software that is directly used by most of the user
community, unlike a database.
HTH
Jared
"Saira
Somani-Mendelin" <saira_somani@yahoo.com> Sent by:
ml-errors@fatcity.com
12/17/2003
09:44 AM Please respond to
ORACLE-L
To: Multiple recipients of list
ORACLE-L <ORACLE-L@fatcity.com>
cc:
Subject: Career
Advice
As an
applications analyst/junior dba, I feel I need to learn more but I'm not
sure of the direction I should take, so I'm asking for advice.
Should
I become interested in Oracle Apps? Or should I learn another suite like
SAP or Siebel or PeopleSoft? The difficulty is that my company does not
use any of these. We use a smaller package by Tecsys called Elite and
they don't have as many customers - or should I say, as many customers
with deep pockets.
I know I can get my hands on a working copy of
SAP, what about the others? I believe you can purchase an evaluation copy
of Apps from the Oracle Store. Has anyone actually tried to train
themselves on any of these products? Has anyone installed Apps at home
for testing?
Sorry if this question has been presented on the list
before.
Thanks, Saira
-- Please see the official
ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira
Somani-Mendelin INET: saira_somani@yahoo.com
Fat City
Network Services -- 858-538-5051 http://www.fatcity.com San
Diego, California -- Mailing list and web hosting
services --------------------------------------------------------------------- To
REMOVE yourself from this mailing list, send an E-Mail message to:
ListGuru@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.net
--
Author: Odland, Brad
INET: Brad.Odland_at_qtiworld.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
