Biggest SQL certification bang for the buck

Biggest SQL certification bang for the buck

Post by Alan Rehli » Mon, 28 Oct 2002 08:34:46



I am just getting started in SQL and wonder what type of certification
is most widely accepted ? Also am interested in XML... any
SQL-specific advice for getting certified in both SQL and XML ?
Thanks in advance, Alan
 
 
 

Biggest SQL certification bang for the buck

Post by Daniel Morga » Wed, 30 Oct 2002 01:17:35



> I am just getting started in SQL and wonder what type of certification
> is most widely accepted ? Also am interested in XML... any
> SQL-specific advice for getting certified in both SQL and XML ?
> Thanks in advance, Alan

None. No hiring manager I have ever met, myself included, could care less.

And I say this from the position of teaching a certificate program myself.
The twist is that at the University of Washington we do not teach people
to pass a paper certification test with multiple choice or True/False
answers. The certificate is the university's own and to obtain it requires
almost a year of hands-on experience with Oracle 8i or 9i. The object of
the Oracle Application Development Certificate program at the university
is the same as the object of a certificate from the School of Medicine.
Not to be able to pass some test somewhere else ... but rather to be able
to actually do the work.

Daniel Morgan
http://www.extension.washington.edu/extinfo/certprog/oad/oad_crs.asp

 
 
 

Biggest SQL certification bang for the buck

Post by xAvai » Wed, 30 Oct 2002 13:14:22


Hello,

I would have to disagree with Daniel on this one.
While I don't think a certificate is better than real life experience,
it definitely doesn't hurt.
I know a lot of places that require for you to be certified,
especially consulting companies, where they have to show their
customers that they know more than the company next door.
It shows your employer that you are trainable and enjoy continuing
your education. According to Salary Surveys, it makes a difference on
how much you get paid.
Also, it might be what makes a difference next time you apply
somewhere and the other person has the same qualifications you do.

For MS certifications check this link out www.microsoft.com/mcp

Hope that helps.

BZ



> > I am just getting started in SQL and wonder what type of certification
> > is most widely accepted ? Also am interested in XML... any
> > SQL-specific advice for getting certified in both SQL and XML ?
> > Thanks in advance, Alan

> None. No hiring manager I have ever met, myself included, could care less.

> And I say this from the position of teaching a certificate program myself.
> The twist is that at the University of Washington we do not teach people
> to pass a paper certification test with multiple choice or True/False
> answers. The certificate is the university's own and to obtain it requires
> almost a year of hands-on experience with Oracle 8i or 9i. The object of
> the Oracle Application Development Certificate program at the university
> is the same as the object of a certificate from the School of Medicine.
> Not to be able to pass some test somewhere else ... but rather to be able
> to actually do the work.

> Daniel Morgan
> http://www.extension.washington.edu/extinfo/certprog/oad/oad_crs.asp

 
 
 

Biggest SQL certification bang for the buck

Post by Alan Rehli » Thu, 31 Oct 2002 07:04:09


Daniel and BZ
Thanks for the feedback.  You two seem to reinforce another impression
that I have ... that there are 2 camps, Oracle vs. Microsoft ?
Is it safe to say that Oracle training is more database-oriented and
Microsoft training is more server-oriented ?  And apparently XML has no
direct connection in your opinions ?
Thanks, Alan

> Hello,

> I would have to disagree with Daniel on this one.
> While I don't think a certificate is better than real life experience,
> it definitely doesn't hurt.
> I know a lot of places that require for you to be certified,
> especially consulting companies, where they have to show their
> customers that they know more than the company next door.
> It shows your employer that you are trainable and enjoy continuing
> your education. According to Salary Surveys, it makes a difference on
> how much you get paid.
> Also, it might be what makes a difference next time you apply
> somewhere and the other person has the same qualifications you do.

> For MS certifications check this link out www.microsoft.com/mcp

> Hope that helps.

> BZ



> > > I am just getting started in SQL and wonder what type of certification
> > > is most widely accepted ? Also am interested in XML... any
> > > SQL-specific advice for getting certified in both SQL and XML ?
> > > Thanks in advance, Alan

> > None. No hiring manager I have ever met, myself included, could care less.

> > And I say this from the position of teaching a certificate program myself.
> > The twist is that at the University of Washington we do not teach people
> > to pass a paper certification test with multiple choice or True/False
> > answers. The certificate is the university's own and to obtain it requires
> > almost a year of hands-on experience with Oracle 8i or 9i. The object of
> > the Oracle Application Development Certificate program at the university
> > is the same as the object of a certificate from the School of Medicine.
> > Not to be able to pass some test somewhere else ... but rather to be able
> > to actually do the work.

> > Daniel Morgan
> > http://www.extension.washington.edu/extinfo/certprog/oad/oad_crs.asp

 
 
 

Biggest SQL certification bang for the buck

Post by Daniel Morga » Thu, 31 Oct 2002 09:08:06



> Daniel and BZ
> Thanks for the feedback.  You two seem to reinforce another impression
> that I have ... that there are 2 camps, Oracle vs. Microsoft ?
> Is it safe to say that Oracle training is more database-oriented and
> Microsoft training is more server-oriented ?  And apparently XML has no
> direct connection in your opinions ?
> Thanks, Alan


> > Hello,

> > I would have to disagree with Daniel on this one.
> > While I don't think a certificate is better than real life experience,
> > it definitely doesn't hurt.
> > I know a lot of places that require for you to be certified,
> > especially consulting companies, where they have to show their
> > customers that they know more than the company next door.
> > It shows your employer that you are trainable and enjoy continuing
> > your education. According to Salary Surveys, it makes a difference on
> > how much you get paid.
> > Also, it might be what makes a difference next time you apply
> > somewhere and the other person has the same qualifications you do.

> > For MS certifications check this link out www.microsoft.com/mcp

> > Hope that helps.

> > BZ



> > > > I am just getting started in SQL and wonder what type of certification
> > > > is most widely accepted ? Also am interested in XML... any
> > > > SQL-specific advice for getting certified in both SQL and XML ?
> > > > Thanks in advance, Alan

> > > None. No hiring manager I have ever met, myself included, could care less.

> > > And I say this from the position of teaching a certificate program myself.
> > > The twist is that at the University of Washington we do not teach people
> > > to pass a paper certification test with multiple choice or True/False
> > > answers. The certificate is the university's own and to obtain it requires
> > > almost a year of hands-on experience with Oracle 8i or 9i. The object of
> > > the Oracle Application Development Certificate program at the university
> > > is the same as the object of a certificate from the School of Medicine.
> > > Not to be able to pass some test somewhere else ... but rather to be able
> > > to actually do the work.

> > > Daniel Morgan
> > > http://www.extension.washington.edu/extinfo/certprog/oad/oad_crs.asp

I would agree. Oracle is not server oriented because it doesn't make its money selling an O/S.

Daniel Morgan

 
 
 

Biggest SQL certification bang for the buck

Post by Niall Litchfiel » Sat, 02 Nov 2002 23:40:22



Quote:> Bottom line, IMHO, when you walk out of Microsoft SQL Server training, you
> have a better understanding of how to get SQL Server up and running.
Again,
> IMHO, when you walk out of Oracle training, you now have to go to another
> training class to understand Windows or Solaris or Unix or whatever.

My only problem with the MS course that I attended was that it somewhat
oversold itself. Looking for a DBA type course I found the 'administering a
sql server 2000 database' course. It did indeed get the software up and
running. However it claims that

This course provides students with the knowledge and skills required to
install, configure, administer, and troubleshoot the client-server database
management system of Microsoft SQL ServerT 2000

It did very well indeed on the install,configure,administer section and
almost zero on 'troubleshoot'. In contrast the equivalent Oracle courses had
very helpful instructors who took the time to explain how things might
actually work in practice, what you would monitor and what sort of things to
consider changing. Obviously much of this is down to the individual
instructor but I wasn't over impressed.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

 
 
 

Biggest SQL certification bang for the buck

Post by BP Margoli » Sun, 03 Nov 2002 00:05:10


Niall,

Quote:> Obviously much of this is down to the individual
> instructor but I wasn't over impressed.

Absolutely, completely agree with you. In fact, probably the best technical
instructor I ever had was in an Oracle DBA course ... of course, I should
also mention that the worst technical instructor I ever had was in an Oracle
Data Warehousing course. The Oracle DBA instructor added to the course
material. The Oracle Data Warehousing course "recited" the text, and was
unable to even comprehend questions asked about the material.

Having done a (very) little bit of technical teaching myself, I know the
problems faced by teachers. Perhaps the best example I can offer is that I
once taught a DTS class. Two of the students were very advanced DTS
programmers. They had been told that the class would be a "boot camp" and
were expecting an intensive, in-depth examination of the inner workings of
DTS. The course was actually an intensive, "shallow" examination of the
features supported by DTS (in other words, the standard MS course
curriculum). The intent of most courses is to expose the students to the
abilities of a product, rather than make them experts in the product.
Basically, the intent is, more than anything, to teach the students "how to
think" in terms of using the product.

What these two had apparently overlooked was that the term "boot camp" comes
from the armed forces, and it takes civilians and produces **Privates**, not
Generals. These two were looking to become Generals. I might add that I had
outlined the class objectives at the beginning of the course, and it was at
this time that they mentioned that they were expecting something different.
Unfortunately, they were not the only two students in the class, and the
other students had never used DTS before, so it was impossible to change the
course to their liking. Of course, you can imagine how these two rated both
the class and my teaching, when in fact it was, I feel confident in stating,
their misunderstanding of the course objectives that was at fault ... but I
probably digress here    :-)

Getting back on track, perhaps ... class descriptions are a bit like resumes
... one emphasizes the positives and glosses over the negatives. I will
certainly accept that most class descriptions ... regardless of vendor ...
oversell themselves.

I don't know if you have ever taught a class, but I can tell you that a
knowledgeable instructor usually knows way more than the class material.
However there is a list of topics that are supposed to get covered during
the allocated time span, and even if the instructor wants to add (valuable)
material to the course material, there is always a clock ticking, and this
constraint usually has to be factored in when considering what can be added
... not to mention that it seems there is always at least one student who
just doesn't seem to "get it" and slows down the class.

Teaching is a lot more difficult than it might look ... I know, since I've
been there and done that   :-)

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.




> > Bottom line, IMHO, when you walk out of Microsoft SQL Server training,
you
> > have a better understanding of how to get SQL Server up and running.
> Again,
> > IMHO, when you walk out of Oracle training, you now have to go to
another
> > training class to understand Windows or Solaris or Unix or whatever.

> My only problem with the MS course that I attended was that it somewhat
> oversold itself. Looking for a DBA type course I found the 'administering
a
> sql server 2000 database' course. It did indeed get the software up and
> running. However it claims that

> This course provides students with the knowledge and skills required to
> install, configure, administer, and troubleshoot the client-server
database
> management system of Microsoft SQL ServerT 2000

> It did very well indeed on the install,configure,administer section and
> almost zero on 'troubleshoot'. In contrast the equivalent Oracle courses
had
> very helpful instructors who took the time to explain how things might
> actually work in practice, what you would monitor and what sort of things
to
> consider changing. Obviously much of this is down to the individual
> instructor but I wasn't over impressed.

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer

> ******************************************

 
 
 

Biggest SQL certification bang for the buck

Post by Daniel Morga » Sun, 03 Nov 2002 01:30:19



> Niall,

> > Obviously much of this is down to the individual
> > instructor but I wasn't over impressed.

> Absolutely, completely agree with you. In fact, probably the best technical
> instructor I ever had was in an Oracle DBA course ... of course, I should
> also mention that the worst technical instructor I ever had was in an Oracle
> Data Warehousing course. The Oracle DBA instructor added to the course
> material. The Oracle Data Warehousing course "recited" the text, and was
> unable to even comprehend questions asked about the material.

> Having done a (very) little bit of technical teaching myself, I know the
> problems faced by teachers. Perhaps the best example I can offer is that I
> once taught a DTS class. Two of the students were very advanced DTS
> programmers. They had been told that the class would be a "boot camp" and
> were expecting an intensive, in-depth examination of the inner workings of
> DTS. The course was actually an intensive, "shallow" examination of the
> features supported by DTS (in other words, the standard MS course
> curriculum). The intent of most courses is to expose the students to the
> abilities of a product, rather than make them experts in the product.
> Basically, the intent is, more than anything, to teach the students "how to
> think" in terms of using the product.

> What these two had apparently overlooked was that the term "boot camp" comes
> from the armed forces, and it takes civilians and produces **Privates**, not
> Generals. These two were looking to become Generals. I might add that I had
> outlined the class objectives at the beginning of the course, and it was at
> this time that they mentioned that they were expecting something different.
> Unfortunately, they were not the only two students in the class, and the
> other students had never used DTS before, so it was impossible to change the
> course to their liking. Of course, you can imagine how these two rated both
> the class and my teaching, when in fact it was, I feel confident in stating,
> their misunderstanding of the course objectives that was at fault ... but I
> probably digress here    :-)

> Getting back on track, perhaps ... class descriptions are a bit like resumes
> ... one emphasizes the positives and glosses over the negatives. I will
> certainly accept that most class descriptions ... regardless of vendor ...
> oversell themselves.

> I don't know if you have ever taught a class, but I can tell you that a
> knowledgeable instructor usually knows way more than the class material.
> However there is a list of topics that are supposed to get covered during
> the allocated time span, and even if the instructor wants to add (valuable)
> material to the course material, there is always a clock ticking, and this
> constraint usually has to be factored in when considering what can be added
> ... not to mention that it seems there is always at least one student who
> just doesn't seem to "get it" and slows down the class.

> Teaching is a lot more difficult than it might look ... I know, since I've
> been there and done that   :-)

> -------------------------------------------
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.





> > > Bottom line, IMHO, when you walk out of Microsoft SQL Server training,
> you
> > > have a better understanding of how to get SQL Server up and running.
> > Again,
> > > IMHO, when you walk out of Oracle training, you now have to go to
> another
> > > training class to understand Windows or Solaris or Unix or whatever.

> > My only problem with the MS course that I attended was that it somewhat
> > oversold itself. Looking for a DBA type course I found the 'administering
> a
> > sql server 2000 database' course. It did indeed get the software up and
> > running. However it claims that

> > This course provides students with the knowledge and skills required to
> > install, configure, administer, and troubleshoot the client-server
> database
> > management system of Microsoft SQL ServerT 2000

> > It did very well indeed on the install,configure,administer section and
> > almost zero on 'troubleshoot'. In contrast the equivalent Oracle courses
> had
> > very helpful instructors who took the time to explain how things might
> > actually work in practice, what you would monitor and what sort of things
> to
> > consider changing. Obviously much of this is down to the individual
> > instructor but I wasn't over impressed.

> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer

> > ******************************************

I agree with all that you've said. One of the advantages of teaching at a
university is the ability to write my own curriculum and to be as creative as I
wish. The first hour of the first class I devote to introducing myself and
having the students introduce themselves ... just as Oracle does at the
beginning of their training classes.

The difference is that I take notes on my student's levels of experience,
background, and experience ... and then customize the instruction and examples
to the class. To a class of SQL Server retreads examples are phrased in terms of
SQL Server. For the mainframers examples are different. Report writers get
examples that make sense from their perspective.

One thing I refuse to allow into the classroom is PowerPoint slides. They are
totally lacking in spontaneity and are, to me, just a dumbing down of the
material.

Daniel Morgan

 
 
 

Biggest SQL certification bang for the buck

Post by Greg Tee » Sun, 03 Nov 2002 03:50:21


On Fri, 01 Nov 2002 16:30:19 GMT, Daniel Morgan <

Quote:>One thing I refuse to allow into the classroom is PowerPoint slides. They are
>totally lacking in spontaneity and are, to me, just a dumbing down of the
>material.

>Daniel Morgan

Absolutely!
 
 
 

Biggest SQL certification bang for the buck

Post by Martin Dohert » Sun, 03 Nov 2002 04:06:28


Daniel, how do you conduct your classes - do you start with a
traditional presentation followed by practical reinforcement? What aids
do you use - (whiteboard? overhead projector?) What kind of student
participation do you encourage during the "lecture"?

I agree with you about the stultifying effects of most powerpoint
presentations, but on occasion a clear diagram with judicious use of
color etc. can go a long way to explaining a concept. Unfortunately the
drive by many education providers to standardize course content  leads
to the bulk packs of slides which mostly contains lists of phrases
("talking points") but very little actual information.

Martin Doherty



>>Niall,

>>>Obviously much of this is down to the individual
>>>instructor but I wasn't over impressed.

>>Absolutely, completely agree with you. In fact, probably the best technical
>>instructor I ever had was in an Oracle DBA course ... of course, I should
>>also mention that the worst technical instructor I ever had was in an Oracle
>>Data Warehousing course. The Oracle DBA instructor added to the course
>>material. The Oracle Data Warehousing course "recited" the text, and was
>>unable to even comprehend questions asked about the material.

>>Having done a (very) little bit of technical teaching myself, I know the
>>problems faced by teachers. Perhaps the best example I can offer is that I
>>once taught a DTS class. Two of the students were very advanced DTS
>>programmers. They had been told that the class would be a "boot camp" and
>>were expecting an intensive, in-depth examination of the inner workings of
>>DTS. The course was actually an intensive, "shallow" examination of the
>>features supported by DTS (in other words, the standard MS course
>>curriculum). The intent of most courses is to expose the students to the
>>abilities of a product, rather than make them experts in the product.
>>Basically, the intent is, more than anything, to teach the students "how to
>>think" in terms of using the product.

>>What these two had apparently overlooked was that the term "boot camp" comes
>>from the armed forces, and it takes civilians and produces **Privates**, not
>>Generals. These two were looking to become Generals. I might add that I had
>>outlined the class objectives at the beginning of the course, and it was at
>>this time that they mentioned that they were expecting something different.
>>Unfortunately, they were not the only two students in the class, and the
>>other students had never used DTS before, so it was impossible to change the
>>course to their liking. Of course, you can imagine how these two rated both
>>the class and my teaching, when in fact it was, I feel confident in stating,
>>their misunderstanding of the course objectives that was at fault ... but I
>>probably digress here    :-)

>>Getting back on track, perhaps ... class descriptions are a bit like resumes
>>... one emphasizes the positives and glosses over the negatives. I will
>>certainly accept that most class descriptions ... regardless of vendor ...
>>oversell themselves.

>>I don't know if you have ever taught a class, but I can tell you that a
>>knowledgeable instructor usually knows way more than the class material.
>>However there is a list of topics that are supposed to get covered during
>>the allocated time span, and even if the instructor wants to add (valuable)
>>material to the course material, there is always a clock ticking, and this
>>constraint usually has to be factored in when considering what can be added
>>... not to mention that it seems there is always at least one student who
>>just doesn't seem to "get it" and slows down the class.

>>Teaching is a lot more difficult than it might look ... I know, since I've
>>been there and done that   :-)

>>-------------------------------------------
>>BP Margolin
>>Please reply only to the newsgroups.
>>When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
>>can be cut and pasted into Query Analyzer is appreciated.





>>>>Bottom line, IMHO, when you walk out of Microsoft SQL Server training,

>>you

>>>>have a better understanding of how to get SQL Server up and running.

>>>Again,

>>>>IMHO, when you walk out of Oracle training, you now have to go to

>>another

>>>>training class to understand Windows or Solaris or Unix or whatever.

>>>My only problem with the MS course that I attended was that it somewhat
>>>oversold itself. Looking for a DBA type course I found the 'administering

>>a

>>>sql server 2000 database' course. It did indeed get the software up and
>>>running. However it claims that

>>>This course provides students with the knowledge and skills required to
>>>install, configure, administer, and troubleshoot the client-server

>>database

>>>management system of Microsoft SQL ServerT 2000

>>>It did very well indeed on the install,configure,administer section and
>>>almost zero on 'troubleshoot'. In contrast the equivalent Oracle courses

>>had

>>>very helpful instructors who took the time to explain how things might
>>>actually work in practice, what you would monitor and what sort of things

>>to

>>>consider changing. Obviously much of this is down to the individual
>>>instructor but I wasn't over impressed.

>>>--
>>>Niall Litchfield
>>>Oracle DBA
>>>Audit Commission UK
>>>*****************************************
>>>Please include version and platform
>>>and SQL where applicable
>>>It makes life easier and increases the
>>>likelihood of a good answer

>>>******************************************

>I agree with all that you've said. One of the advantages of teaching at a
>university is the ability to write my own curriculum and to be as creative as I
>wish. The first hour of the first class I devote to introducing myself and
>having the students introduce themselves ... just as Oracle does at the
>beginning of their training classes.

>The difference is that I take notes on my student's levels of experience,
>background, and experience ... and then customize the instruction and examples
>to the class. To a class of SQL Server retreads examples are phrased in terms of
>SQL Server. For the mainframers examples are different. Report writers get
>examples that make sense from their perspective.

>One thing I refuse to allow into the classroom is PowerPoint slides. They are
>totally lacking in spontaneity and are, to me, just a dumbing down of the
>material.

>Daniel Morgan

 
 
 

Biggest SQL certification bang for the buck

Post by Daniel Morga » Sun, 03 Nov 2002 06:48:34


Martin Doherty wrote:
> Daniel, how do you conduct your classes - do you start with a
> traditional presentation followed by practical reinforcement? What aids
> do you use - (whiteboard? overhead projector?) What kind of student
> participation do you encourage during the "lecture"?

> I agree with you about the stultifying effects of most powerpoint
> presentations, but on occasion a clear diagram with judicious use of
> color etc. can go a long way to explaining a concept. Unfortunately the
> drive by many education providers to standardize course content  leads
> to the bulk packs of slides which mostly contains lists of phrases
> ("talking points") but very little actual information.

> Martin Doherty

> Daniel Morgan wrote:

> >BP Margolin wrote:

> >>Niall,

> >>>Obviously much of this is down to the individual
> >>>instructor but I wasn't over impressed.

> >>Absolutely, completely agree with you. In fact, probably the best technical
> >>instructor I ever had was in an Oracle DBA course ... of course, I should
> >>also mention that the worst technical instructor I ever had was in an Oracle
> >>Data Warehousing course. The Oracle DBA instructor added to the course
> >>material. The Oracle Data Warehousing course "recited" the text, and was
> >>unable to even comprehend questions asked about the material.

> >>Having done a (very) little bit of technical teaching myself, I know the
> >>problems faced by teachers. Perhaps the best example I can offer is that I
> >>once taught a DTS class. Two of the students were very advanced DTS
> >>programmers. They had been told that the class would be a "boot camp" and
> >>were expecting an intensive, in-depth examination of the inner workings of
> >>DTS. The course was actually an intensive, "shallow" examination of the
> >>features supported by DTS (in other words, the standard MS course
> >>curriculum). The intent of most courses is to expose the students to the
> >>abilities of a product, rather than make them experts in the product.
> >>Basically, the intent is, more than anything, to teach the students "how to
> >>think" in terms of using the product.

> >>What these two had apparently overlooked was that the term "boot camp" comes
> >>from the armed forces, and it takes civilians and produces **Privates**, not
> >>Generals. These two were looking to become Generals. I might add that I had
> >>outlined the class objectives at the beginning of the course, and it was at
> >>this time that they mentioned that they were expecting something different.
> >>Unfortunately, they were not the only two students in the class, and the
> >>other students had never used DTS before, so it was impossible to change the
> >>course to their liking. Of course, you can imagine how these two rated both
> >>the class and my teaching, when in fact it was, I feel confident in stating,
> >>their misunderstanding of the course objectives that was at fault ... but I
> >>probably digress here    :-)

> >>Getting back on track, perhaps ... class descriptions are a bit like resumes
> >>... one emphasizes the positives and glosses over the negatives. I will
> >>certainly accept that most class descriptions ... regardless of vendor ...
> >>oversell themselves.

> >>I don't know if you have ever taught a class, but I can tell you that a
> >>knowledgeable instructor usually knows way more than the class material.
> >>However there is a list of topics that are supposed to get covered during
> >>the allocated time span, and even if the instructor wants to add (valuable)
> >>material to the course material, there is always a clock ticking, and this
> >>constraint usually has to be factored in when considering what can be added
> >>... not to mention that it seems there is always at least one student who
> >>just doesn't seem to "get it" and slows down the class.

> >>Teaching is a lot more difficult than it might look ... I know, since I've
> >>been there and done that   :-)

> >>-------------------------------------------
> >>BP Margolin
> >>Please reply only to the newsgroups.
> >>When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> >>can be cut and pasted into Query Analyzer is appreciated.

> >>"Niall Litchfield" <n-litchfi...@audit-commission.gov.uk> wrote in message
> >>news:3dc29256$0$8510$ed9e5944@reading.news.pipex.net...

> >>>"BP Margolin" <bpma...@attglobal.net> wrote in message
> >>>news:3dbf5075_1@news1.prserv.net...

> >>>>Bottom line, IMHO, when you walk out of Microsoft SQL Server training,

> >>you

> >>>>have a better understanding of how to get SQL Server up and running.

> >>>Again,

> >>>>IMHO, when you walk out of Oracle training, you now have to go to

> >>another

> >>>>training class to understand Windows or Solaris or Unix or whatever.

> >>>My only problem with the MS course that I attended was that it somewhat
> >>>oversold itself. Looking for a DBA type course I found the 'administering

> >>a

> >>>sql server 2000 database' course. It did indeed get the software up and
> >>>running. However it claims that

> >>>This course provides students with the knowledge and skills required to
> >>>install, configure, administer, and troubleshoot the client-server

> >>database

> >>>management system of Microsoft SQL ServerT 2000

> >>>It did very well indeed on the install,configure,administer section and
> >>>almost zero on 'troubleshoot'. In contrast the equivalent Oracle courses

> >>had

> >>>very helpful instructors who took the time to explain how things might
> >>>actually work in practice, what you would monitor and what sort of things

> >>to

> >>>consider changing. Obviously much of this is down to the individual
> >>>instructor but I wasn't over impressed.

> >>>--
> >>>Niall Litchfield
> >>>Oracle DBA
> >>>Audit Commission UK
> >>>*****************************************
> >>>Please include version and platform
> >>>and SQL where applicable
> >>>It makes life easier and increases the
> >>>likelihood of a good answer

> >>>******************************************

> >I agree with all that you've said. One of the advantages of teaching at a
> >university is the ability to write my own curriculum and to be as creative as I
> >wish. The first hour of the first class I devote to introducing myself and
> >having the students introduce themselves ... just as Oracle does at the
> >beginning of their training classes.

> >The difference is that I take notes on my student's levels of experience,
> >background, and experience ... and then customize the instruction and examples
> >to the class. To a class of SQL Server retreads examples are phrased in terms of
> >SQL Server. For the mainframers examples are different. Report writers get
> >examples that make sense from their perspective.

> >One thing I refuse to allow into the classroom is PowerPoint slides. They are
> >totally lacking in spontaneity and are, to me, just a dumbing down of the
> >material.

> >Daniel Morgan

I do about 90% on my notebook computers, one loaded with 8.1.7.4 the other with 9.2
accompanied by lecture. The other 10%, maybe less, on the whiteboard, with a few
viewfoils of material from tahiti.com or similar web sites. Also, though I should
probably not admit it here, postings to these usenet groups I find worthy of being
used as educational material (feel free to draw your own conclusions).

I intentionally use almost no prepared code and write everything on-the-fly from
memory. I do this not because I am that good but rather because I know I will make
mistakes. I consider 75% of the learning experience seeing how to do things correctly
and 25% from becoming familiar with the ORA messages, learning how to interpret them,
how to debug problems, and how to fix them.

The Certificate program consists of 3 quarters. The first concentrates on basic
architecture (as distinguished from DB2, SQL Server, Informix, Sybase, COBOL),
tables, constraints, indexes, views, sequences, materialized views, and a lot of SQL
ranging from SELECT COUNT(*) to nested subqueries and in-line views, and built-in
functions including the analytics. Mid-term and final are done by students on their
own computers and are all real-world problem solving. No T/F, No multiple choice.

The second quarter is packages, procedures, functions, triggers, and some of the more
commonly used built-in packages like UTL_FILE, DBMS_OUTPUT, DBMS_UTILITY,
DBMS_PROFILE. We spend a lot of time on static cursors, ref cursors, dynamic SQL,
nested loops, and the mid-term and final are presented as pure business problems
where the students build the tables, populate the data, and write code to solve a
problem. Last year's problem involved writing a function that calculated distances
between cellular phone sites starting with coordinates given in latitude and
longitude and required an intentional Cartesian Product to get the correct answer.

The third quarter is DBA for developers. We trash an Oracle database and rebuild from
scratch, examine SQL.BSQ, run catalog, catproc, etc. from scratch. Create a security
model using roles, profiles, protocol.ora, etc., create users, and then play around
with IMP, EXP, SQL*Loader, and otherwise have a blast.

The average student spends 3 hours per week in class and twice that much time with
self-assigned homework.

I hope that answers the question. But standardization? No way. I have researched the
programs at other universities and what we teach here is very very different. And
each time it is taught it changes to match the students, new releases from Oracle,
and whatever catches my fancy at the moment. When I was consulting at Boeing class
projects related to a mythical ...

read more »

 
 
 

1. Biggest SQL certification bang for the buck

I am just getting started in SQL and wonder what type of certification
is most widely accepted ? Also am interested in XML... any
SQL-specific advice for getting certified in both SQL and XML ?
Thanks in advance, Alan

2. Can i AVOID a trusted connection between a DOMAIN and a WORKGROUP ?

3. SHMVIRTSIZE --- How much bang for the buck?

4. Oracle Forms

5. Performance bang for buck

6. closing connection to sql db

7. Bang for the buck?

8. wildcard,

9. Big Bucks in Big-D

10. make big bucks!!!

11. BIG BUCKS ! (fwd)

12. make big bucks!!!

13. BIG BUCKS ! (fwd)