Hello,
The testing should say 'This person is qualified to administer systems.'
To me that includes understanding SQL as while the applications
mentioned are not to be tested, the underlying commands necessary to
install the applications requires issuing SQL statements. Of course the
administrator can just parrot the commands, but I would rather they know
what they are doing just in case there are issues. As for what to test,
use the SQL99 Standard and only on CREATE, SELECT, ALTER, DROP, and
DELETE commands. Definitely limit it to the biggees that will be used. I
can not tell you how many times as an administrator I am asked to tie in
administrative tools into a database so someone can write a pretty
report for someone else or an application install requires me to issue
these commands. As an example, the local highschool system administrator
is now in need of learning SQL.
Best regards,
Edward Haletky
Alan McKinnon wrote:
Hi,
I do agree with your observation, but not with your conclusion.
Yes, SQL knowledge is very handy. However, an LPI cert tests the
essential knowledge at a specific level and certifies that the person
holding the certificate at least has a clue.
By no stretch of the imagination can we consider SQL knowledge to be an
essential skill for a Linux admin, especially as not one of the examples
you mention are relevant or tested at LPIC-1 level. It seems very silly
to me to not test Nagios on the exam but somehow require a person to
know how Nagios talks to a database.
For that matter, which SQL dialect would the candidate be tested on?
alan
On Wed, 2007-11-07 at 07:47 -0500, Edward L. Haletky wrote:
Hello,
I would expect an Administrator to have basic SQL knowledge at the very
least. Almost all tools these days plugin to an SQL server for some
reason. Look at an Intrusion Detection System (Snort/Barnyard/BASE
(Acid)), System Monitoring Package (Nagios), Hardware Monitoring via
Vendor code, etc. The list is pretty long so SQL queries are becoming
more useful in daily Administrative jobs. Granted, they do not need to
be DB admins but knowledge of the syntax or where to get the syntax is
very important.
Best regards,
Edward Haletky
AstroArch Consulting, Inc.
[EMAIL PROTECTED] wrote:
Hi!
So, I was thinking a lot about what I heard at the TAC meeting about the update of the LPIC-1 objectives. And I am really not sure if 106.3 SQL Data Management is really fitting. I forgot the exact job title, but I wouldn't expect a "Professional" Linux User / power user / junior level administrator to have SQL knowledge. I don't see for which tasks in that level it would be needed. My opinion.
This is my first email here, so sorry if I didn't keep any specific format that
I was suppose to use, I couldn't find any information about that.
Amy
_______________________________________________
lpi-examdev mailing list
[email protected]
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev
_______________________________________________
lpi-examdev mailing list
[email protected]
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
lpi-examdev mailing list
[email protected]
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev
