Hello everyone,

Today I was strolling trough the LPIC-1 objectives and discovered (to my surprise) that cadidates are supposed to know
105.3 SQL data management
insert, update, select, delete, from, where, group by, order by, join.
Isn't this a bit tough for a (junior) system administrator. In my daily practice I often have to install (set-up or configure) applications with a database footprint, but I never use insert, update, group by, order by, and join. The commands I *DO* use like: create database, grant all on database.* to u...@host identified by 'secret'. And the command to source a SQL script to prep a database are *NOT* in the exam objectives.

Why is that???

I think a competent system administrator should be able to create and load databases and protect them. I do not think he needs to know all intricacies of the SQL language. Thats a DBA job....

--
OSA logo        Vriendelijke Groet / Kind Regards,
Reinier Kleipool
*Open Source Academy*
Rotterdamserijweg 122
3042 AS Rotterdam
the Netherlands
T: +31 654 227144
E: [email protected] <mailto:[email protected]>


begin:vcard
fn:Reinier Kleipool
n:Kleipool;Reinier
org:Open Source Academy
adr:;;Rotterdamserijweg 122;Rotterdam;;3042 AS;the Netherlands
email;internet:[email protected]
title:Curriculum Advisor
tel;cell:+31 654 227 144
x-mozilla-html:TRUE
url:http://www.OpenSourceAcademy.nl
version:2.1
end:vcard

_______________________________________________
lpi-examdev mailing list
[email protected]
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Reply via email to