"Donald A. Tevault" <[email protected]> writes: > > Alan McKinnon wrote: > > > > I find myself using INSERT, UPDATE, DELETE and SELECT quite a lot, > mostly on > > simple databases that store for example usernames and passwords, or mail > > aliases. > > > These commands are pretty standard across the majority of SQL > databases and > > are analogous to how you would edit a text file, or even using useradd, > > usermod, userdel and id. > > > I agree that JOINs are too complex for LPIC-1, you need to know some > database > > theory to grasp what they are all about, and that is outside the scope > of LPI > > exams. > > > > -- alan dot mckinnon at gmail dot com > > > Okay, you guys have convinced me. I'll modify my course to reflect some > of these comments.
Note that the objective 105.3 has a weight of only two. IOW, under the new weighting system a candidate will never receive more than two items on this objective. Also, the statement "Perform basic data manipulation" means just that. An LPIC-1 MQC must be able to perform some basic queries and updates on a database. The jury is obviously out on whether or not knowledge of JOIN in considered "basic", but at this point in time LPI thinks: yes :) As always, though, the point of this list is to discuss such issues for future exams and these comments have been great. -- Kevin Glendenning [email protected] _______________________________________________ lpi-examdev mailing list [email protected] http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev
