Re: Where do I start?
Date: Mon, 07 May 2001 03:28:27 GMT
Message-ID: <vDoJ6.10540$ks3.4309857_at_news1.mntp1.il.home.com>
I agree with Eric. There is a lot to be said for someone beginning their relational database theory understanding by using Access. That's where I began and I believe it has made ALL the difference in understanding relational database theory.
I believe that the next step would be to build a strong foundation in SQL. Everything in Oracle will evolve from this foundation.
Finally, understanding the architecture and administration of Oracle will solidify one's understanding of a TRUE rdms.
Good luck.
"Eric from Speco" <eric_at_speco.com> wrote in message
news:9cc6hd$3ah$1_at_bob.news.rcn.net...
> I'm just getting to Oracle myself so I have a perspective that many
> experienced users may have long forgotten. My first impression when
> introduced to Oracle was "holy #$&*" there's too much to learn.
>
> As Mr. Bell pointed out you'll likely recieve instruction as to what
you'll
> need to learn. In the mean time I would recommend reading Beginner's
guide
> to Oracle from Oracle press. It'll give you an overview of the different
> packages oracle offers and give you some fundamentals.
>
> No prior experience most likely means you won't need coding skills.
However
> you will want understand the lingo.Therefore I think it would be more
> productive to familiarize yourself with db theory first. Any community
> college should have a course for this. Don't enroll in the course just
buy
> the book they're using. At the same time you can practice w/ msaccess (I'm
> really sticking my neck out here recommending a MS product...but it has a
> graphical design enviornment and is relativly cheap.
>
> You can practice w/ msaccess to create tables and queries. You can use
the
> query wizard to build a query and then view the underlying SQL code that
> made the query. (word of caution here. vbSQL is not real SQL don't get
too
> involved in the syntax for joining tables. It'll get you on your way
> though).
>
> Once you're comfortable with msaccess stop using it! Uninstall it from
your
> computer and smash the CD. Get Personal Oracle (I think it's still free on
> their website.) Now you can create tables and queries with SQL.
>
>
>
>
>
> The Martian <dmcgrat1_at_hotmail.com> wrote in message
> news:ub_F6.29563$U4.6400316_at_news1.rdc1.tn.home.com...
> > There is a job opening up where I work in about 9 mos. working w/
Oracle.
> > No prior experience is necessary; they will train whomever they select.
I
> > want to make myself as strong a candidate as I can, by starting to
> > self-study. I have minimal experience as a coder (some Pascal, some
> > FORTRAN, but not much of either). Where would be the best place for me
to
> > start studying? Thanks!
> >
> > Dave McGrath
> > dmcgrat1_at_hotmail.com
> >
> >
> >
>
>
Received on Mon May 07 2001 - 05:28:27 CEST