On 11/02/2015 09:44, Anselm Lingnau wrote: > Fabian Thorns <[email protected]> wrote: > >> I'm not sure why we have SQL on the exams right not, > > ISTR that this was originally added because many programs these days > offer logging into SQL databases, and system administrators should be > able to formulate SQL queries in order to get at these logs. > Could you provide some examples? In my (limited) experience almost all programs I'm using just log to text file (journald beeing the main exception).
> In addition, many programs these days use SQLite as a lightweight > structured method for storing configuration and data files, and it is > frequently useful for a system administrator to be able to access and > manipulate that information. > I see this mainly in desktop applications, like firefox and thunderbird, that provide some gui to modify them. I almost never used sqlite to change such data. But as before this could be just my limited experience. > The SQL required in LPIC-1 isn't exactly rocket science, and it is > fairly well-defined and limited as LPI exam topics go. (Note that the > LPI objectives do not require knowledge of the DDL.) I don't have a > problem with this being on the exam. > I agree that's limited, and I'm not strongly advocating for removal. It's true that knowing about SQL basis is needed for a sysadmin, like knowing about switching loops. For both I just don't think they are topics for a Linux specific certification. Up to now it has been far more common for me having to create a database (in MySQL or Postgres) and setting some user access to it when installing some web application, than having to execute some standard SQL query to modify or read some setting. But before someone proposing the addition of these topic, I'd like to say that I don't think they are appropriate for LPI 1. Regards Simone -- Simone Piccardi Truelite Srl [email protected] (email/jabber) Via Monferrato, 6 Tel. +39-347-1032433 50142 Firenze http://www.truelite.it Tel. +39-055-7879597 Fax. +39-055-7333336 _______________________________________________ lpi-examdev mailing list [email protected] http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev
