Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: is learning MS access beneficial to learn oracle and sql server?

Re: is learning MS access beneficial to learn oracle and sql server?

From: <aaron_kempf_at_hotmail.com>
Date: 18 Mar 2003 16:05:31 -0800
Message-ID: <c6cc62d2.0303181605.751878cd@posting.google.com>


and just for the record, in the 20 jobs i have worked in the past 5 years-- i have seen something like a dozen FT Oracle Developers, and probably something like 1000 Access Developers--

there is OBVIOUSLY a greater need for the last mile-- getting data from the backend into the hands of analysts-- that ALWAYS use MS EXCEL as a client tool.

and while i am at it --- development in SQL Server is MUCH easier than Development in Oracle.

I have been doing both for many years--

I would honestly reccomend this:

  1. Start with Access MDB.
  2. Move to Access ADP against SQL Server.

It is the best environment in the world; and it is a lot faster, more scalable, and easier (for developers and end users) than Oracle Forms or any other product out there.

"Roman Zhovtulya" <roman_at_fh-offenburg.de> wrote in message news:<b57ql5$3f8$1_at_news.BelWue.DE>...
> Hi there,
> In my opinion there is as much difference between Access and Oracle as there
> is between a desktop app for "not-too-computer-literate" folks and a real
> database.
> If you want to learn Oracle, why not start directly with it.
> Access is quite a different type of database from what is normally known as
> "database".
> It might have, however, some similarities with SQL Server, but not much.
>
> What might be useful for you is to go through one of those online SQL
> courses (free), like http://www.sqlcourse.com/
> There you can also issue some queries online.
>
> Hope it helps.
>
> Roman Zhovtulya
> Offenburg University
>
>
>
> "amanda" <amanda94621_at_yahoo.com> wrote in message
> news:bbea23b7.0303181053.9a25edd_at_posting.google.com...
> > Hi,
> > Please bear with me.
> >
> > I am a computer student who has missed out on learning database course
> > (junior level) well because the prof. just taught nothing. He was sick
> > that semester and all he gave as assignment was to create some tables
> > and insert values. Actually, it was a 6 credit course for "Data
> > Structure (use C) and Database Design", called a leveling course for
> > grad studnet whose background is not from computer.
> >
> > Fortunately, I was taking "Inrto to SQL and PL/SQL" at a community
> > college (knowing that I would get nothing from the course at my
> > school) but the instructor there was teaching it for the first time
> > (he usually teach pascal and C++) and so the pace was quite slow.
> >
> > I basically learned on my own reading the text book which was too
> > easy. I don't feel that we finished as much as we could have. I also
> > had a surgery that semester and so the pace worked well for me at that
> > time.
> >
> > By the way, I jumped into computer field (Originally from my natural
> > science background: chemistry) without taking any course in MS office
> > cause I had no money; I plan to study those on my own but didn't
> > happen due to time constraint and illness.
> >
> > Later, I took a graduate level database course (DBMS), very
> > theorectical and so I am thorughly familiar with relational databse.
> >
> > What I would like to do is get serious skill in using Oracle Pl/SQL
> > as well sql server's stored procedure (not as a DBA but as someone who
> > can pick things up so that I can find a job). I have taken Java, Basic
> > C++ - like C, Visual Basic, and plan to take a Unix course at a
> > community college.
> >
> > I am not proficient in use of MS Access except for creating basic
> > tables.
> > Should I get a book on MS ACCESS (I have 2002 software) and if so,
> > what book if you know and do some exercise before getting serious on
> > SQL langauge, etc. Remembr that I have already learned "Intro do SQL
> > and very basic PL/SQL" and have theorectical background.
> >
> > I am asking because I don't want to buy books and then not used while
> > I am overwhlemed with what to learn on my own. I have so many books
> > some of which I tounched only a few pages once or twice, like "Regular
> > Expressions". Now..it is time for me to learn systematicllay instead
> > of buying books after books, not that I have any more money.
> >
> > Any suggetsion on how I should go about "establishing good Databse
> > skills" would GREATLY be appreciated.
> >
> > Amanda
Received on Tue Mar 18 2003 - 18:05:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US