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: nirav <shivam71_at_gmail.com>
Date: 1 Jun 2006 05:06:07 -0700
Message-ID: <1149163567.107390.115970@f6g2000cwb.googlegroups.com>


Thanks a lot for your kind help.

-Nirav

wannabe DBA wrote:
> 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 - 07:06:07 CDT

Original text of this message

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