Il 12/10/2017 10:10, Jeroen Baten ha scritto: > > Well said and I agree. > > When I suggested to Taki some years ago to add some basic SQL stuff to > LPI1 it was because I think of LPI1 as a junior systems management role. > More than only OS but also some basic knowledge of day to day > operations. Definitely not a DBA role, but being able to install an > application, LAMP or otherwise, should be one iof his day to day duties. >
I never directly used any of SQL query covered by topic 105.3 in any LAMP installation I did. To install a LAMP application usually you have to create an user and init a database. The first one is usually specific to the database engine you are using and often done by specific command outside SQL. The second one is SQL, but done just running the SQL script given by the application you install. Anyway I think that also backups are a common junior sysadmin task, but backup are still an LPI 2 topic. I agree that some database server management task (for common used database engines like postgresql and mariadb/mysql) should be covered, but not in LPI 1. Simone _______________________________________________ lpi-examdev mailing list lpi-examdev@lpi.org http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev