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

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

However if u wish to teach them the DBA job then:

1) Ask them to install Oracle 10g on a single server and a RAC too.

2) Teach them Backup and Recovery Fundamentals via simulated case
studies. Thomas Kyte talks at length about some of this stuff.

3) Performance issues and troubleshooting.

Can give us more of an idea of what the aims and objectives of the
training is?
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

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

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

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

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