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

Home -> Community -> Usenet -> c.d.o.server -> Re: database projects for fresher's training

Re: database projects for fresher's training

From: wannabe DBA <nasser.ali_at_gmail.com>
Date: 1 Jun 2006 04:47:53 -0700
Message-ID: <1149162473.880321.202750@i39g2000cwa.googlegroups.com>


Cool,

Then i suggest:

Go with the mini olympics design of small database, insert normalised data, create selects and reports.

Tehn make sure they create a front end using php or java.

The front end could be a little report application that inserts data, deletes data etc.

Secondly another assignment of a Video Hire Shop.

Containing Data:

Customers, Videos, Addresses, Recievable and payables tables.

nirav wrote:
> No, the idea is to train them as programmers and provide comprehensive
> training so that they can hone their skills..they are not expected to
> be DBAs..
> nirav wrote:
> > Thanks a lot...by assigments I mean mini projects which a team of 3 or
> > 4 freshers can finish in may be 3 or 4 weeks.
> >
> > With thanks..
> > Nirav
> > wannabe DBA wrote:
> > > By Assignments i think you mean what sorts of excercises?
> > >
> > > I would personally ask them to design a small database consisting of a
> > > few tables for a olympics events where there are:
> > >
> > > Athletes, Officials, Events, Sports Complexes, Locations etc.
> > >
> > > Ask them to create tables and denormalise and insert data. Once that is
> > > done ask them to pull some data out using some SQL scripts.
> > >
> > > Then ask them to put a front end on in terms of a FORM. preferably in
> > > HTML DB or PHP.
> > >
> > > They should be taught PL/SQL basics too.
> > >
> > > nirav wrote:
> > > > Hi ,
> > > >
> > > >
> > > > Our company is recruiting many freshers and there is a suggestion to
> > > > train them by providing various problems/sample projects. So for oracle
> > > > related technology, what could be the kind of assisgments that could
> > > > help the freshers pick up good database skills?
> > > >
> > > > I shall be very thankful for your inputs..
> > > > Nirav
Received on Thu Jun 01 2006 - 06:47:53 CDT

Original text of this message

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