Has anyone considered teaching a more in depth version of awk (gawk). At the end of my classes I hand out a more in depth tutorial of both sed and awk.
We could also consider some perl scripting in 102. Perl is designed for administration and reporting. We could move bash scripting to 101. I believe a basic understanding of Bash scripting would provide students with a useful tool. Sandor -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, February 11, 2015 10:37 PM To: [email protected] Subject: lpi-examdev Digest, Vol 85, Issue 12 Send lpi-examdev mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of lpi-examdev digest..." Today's Topics: 1. SQL in 101 (Hendrik Jan Thomassen) 2. Re: SQL in 101 (Henk Snel) 3. Re: SQL in 101 (Bryan J Smith) 4. Re: SQL in 101 (Alexandru Juncu) 5. Re: Suggestion for 105.3 (Exam 101) mysqldump (Toru Nakatani) ---------------------------------------------------------------------- Message: 1 Date: Wed, 11 Feb 2015 18:45:05 +0100 From: Hendrik Jan Thomassen <[email protected]> Subject: [lpi-examdev] SQL in 101 To: [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii Matthew Rice wrote: > > My own personal reasons for not hating it in the objectives is that > I've seen a few times where "management" want to get reports out of a > DB and they turn to the techs to help them with that task. in > particular, having Excel/*Office connecting to the DB and then trying > to figure out some simple queries. This exactly illustrates my point that SQL as such has nothing to do with Linux system administration, but is "just another application domain". In this case: use of computers for business applications. There are so many other uses for a computer, even with Linux :-) The Linux OS is the common denominator under a plethora of different application domains: business administration, telecom, science, numerical control, web serving, ... ... ... I.m.h.o. the LPI certification should restrict itself to this common denominator under all application domains. -- Hendrik-Jan Thomassen <[email protected]> AT Computing Linux/UNIXperts, opleiders & oplossers Tel +31 24 352 72 82 Kerkenbos 1238 Tel cursussecretariaat: +31 24 352 72 72 6546 BE Nijmegen Fax +31 24 352 72 92 [email protected] www.atcomputing.nl 'If you think education is expensive, try ignorance.' ------------------------------ Message: 2 Date: Wed, 11 Feb 2015 20:30:48 +0100 From: Henk Snel <[email protected]> Subject: Re: [lpi-examdev] SQL in 101 To: "This is the lpi-examdev mailing list." <[email protected]> Message-ID: <cajpjjoj3o0ueto779iv0+gn3uf7aabinhzaw3nx4erryiuh...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" +1 Met vriendelijke groeten, *Henk Snel* Storage Consultant Mobiel: +31 (0) 653493434 E-mail: [email protected] <http://www.linkedin.com/in/henksnel> [image: Logo] Dodeweg 6c 3832 RC Leusden http://www.tenict.nl On Wed, Feb 11, 2015 at 6:45 PM, Hendrik Jan Thomassen <[email protected]> wrote: > Matthew Rice wrote: > > > > My own personal reasons for not hating it in the objectives is that > > I've seen a few times where "management" want to get reports out of > > a DB and they turn to the techs to help them with that task. in > > particular, having Excel/*Office connecting to the DB and then > > trying to figure out some simple queries. > > This exactly illustrates my point that SQL as such has nothing to do > with Linux system administration, but is "just another application > domain". In this case: use of computers for business applications. > There are so many other uses for a computer, even with Linux :-) > > The Linux OS is the common denominator under a plethora of different > application domains: business administration, telecom, science, > numerical control, web serving, ... ... ... > I.m.h.o. the LPI certification should restrict itself to this common > denominator under all application domains. > > -- > Hendrik-Jan Thomassen <[email protected]> > AT Computing > Linux/UNIXperts, > opleiders & oplossers Tel +31 24 352 72 82 > Kerkenbos 1238 Tel cursussecretariaat: +31 24 352 72 72 > 6546 BE Nijmegen Fax +31 24 352 72 92 > [email protected] www.atcomputing.nl > > 'If you think education is expensive, try ignorance.' > > _______________________________________________ > lpi-examdev mailing list > [email protected] > http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev > -- *Disclaimer:* Dit bericht (inclusief de eventuele bijlagen) is vertrouwelijk. Wanneer u dit bericht ten onrechte heeft ontvangen, dient u de afzender hiervan onmiddellijk per kerende e-mail op de hoogte te brengen en dit bericht te verwijderen uit uw systeem. Elk onbevoegd gebruik en/of onbevoegde verspreiding van dit bericht is niet toegestaan. U wordt erop gewezen dat e-mailberichten aan wijziging onderhevig kunnen zijn. Voor al onze aanbiedingen en of offerte(s) zijn onze algemene voorwaarden van toepassing. Deze voorwaarden zijn gedeponeerd bij de KvK te Utrecht. Onze voorwaarden kunnen op verzoek tevens toegezonden worden. TenICT is niet aansprakelijk voor de onjuiste en onvolledige overdracht van de informatie in dit bericht noch voor mogelijke vertraging in de ontvangst van dit bericht of schade aan uw systeem als gevolg van dit bericht. TenICT staat er niet voor in dat de integriteit van dit bericht behouden is gebleven noch dat dit bericht vrij is van virussen, niet is onderschept of vatbaar is geweest voor tussenkomst (door derden). -------------- next part -------------- An HTML attachment was scrubbed... URL: http://list.lpi.org/cgi-bin/mailman/private/lpi-examdev/attachments/20150211 /bd6fa0ef/attachment-0001.htm ------------------------------ Message: 3 Date: Wed, 11 Feb 2015 14:33:36 -0500 From: Bryan J Smith <[email protected]> Subject: Re: [lpi-examdev] SQL in 101 To: "This is the lpi-examdev mailing list." <[email protected]> Message-ID: <cad5acgjl+ejzmcjlyfgu3ifuerzro5ep_1erhyshrpljacc...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Well, Linux is slowly becoming just one "chunk of the infrastructure." I.e., MQ and SQL are almost becoming "mandatory services" for IaaS, and unavoidable. That said, I'd still argue it's LPIC-2, for now. - bjs On Wed, Feb 11, 2015 at 12:45 PM, Hendrik Jan Thomassen <[email protected]> wrote: > Matthew Rice wrote: >> >> My own personal reasons for not hating it in the objectives is that >> I've seen a few times where "management" want to get reports out of a >> DB and they turn to the techs to help them with that task. in >> particular, having Excel/*Office connecting to the DB and then trying >> to figure out some simple queries. > > This exactly illustrates my point that SQL as such has nothing to do > with Linux system administration, but is "just another application > domain". In this case: use of computers for business applications. > There are so many other uses for a computer, even with Linux :-) > > The Linux OS is the common denominator under a plethora of different > application domains: business administration, telecom, science, > numerical control, web serving, ... ... ... > I.m.h.o. the LPI certification should restrict itself to this common > denominator under all application domains. > > -- > Hendrik-Jan Thomassen <[email protected]> > AT Computing > Linux/UNIXperts, > opleiders & oplossers Tel +31 24 352 72 82 > Kerkenbos 1238 Tel cursussecretariaat: +31 24 352 72 72 > 6546 BE Nijmegen Fax +31 24 352 72 92 > [email protected] www.atcomputing.nl > > 'If you think education is expensive, try ignorance.' > > _______________________________________________ > lpi-examdev mailing list > [email protected] > http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev -- -- Bryan J Smith - http://www.linkedin.com/in/bjsmith ------------------------------ Message: 4 Date: Wed, 11 Feb 2015 21:26:23 +0100 From: Alexandru Juncu <[email protected]> Subject: Re: [lpi-examdev] SQL in 101 To: "This is the lpi-examdev mailing list." <[email protected]> Message-ID: <CAPhGq=zc-vrffnhk5kqzwjww3tjjcdmb3e_5howivzo6kzt...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 I think that SQL knowledge is important when dealing with web services. But since other services like Apache are treated in LPIC-2, maybe SQL (along with some specific service management of packages like MySQL or MariaDB), should also be include in LPIC-2 and not in LPIC-1. My $0.02 ------------------------------ Message: 5 Date: Thu, 12 Feb 2015 12:49:59 +0900 From: Toru Nakatani <[email protected]> Subject: Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump To: [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset=utf-8 This would be nice for you ! http://www.oss-db.jp/outline/eng_index.shtml On 2015/02/10 23:59, G. Matthew Rice wrote: > On Tue, Feb 10, 2015 at 9:58 AM, Harald Maa?en <[email protected]> wrote: >> There are only funny looking characters and pictures on that page. >> ;-) > > This doesn't get all of those "thingies" but it helps: > > > https://translate.google.com/translate?sl=ja&tl=en&js=y&prev=_t&hl=en&; > ie=UTF-8&u=http%3A%2F%2Fwww.oss-db.jp%2F&edit-text= > -- Toru Nakatani / LPI-Japan ------------------------------ _______________________________________________ lpi-examdev mailing list [email protected] http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev End of lpi-examdev Digest, Vol 85, Issue 12 ******************************************* _______________________________________________ lpi-examdev mailing list [email protected] http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev
