I have to agree. I can see having an exam candidate know how to create user accounts, grant privileges, etc. But, I don't understand the emphasis on manipulating data tables. That should definitely be the job of a database admin.
> > Message: 1 > Date: Mon, 18 May 2009 14:58:01 +0200 > From: Reinier Kleipool <[email protected]> > Subject: [lpi-examdev] SQL knowledge for LPIC-1 > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > 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.... > _______________________________________________ lpi-examdev mailing list [email protected] http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev
