Don Davis | 1 Jun 01:05 2009

Re: OT: SQL query

Thank you.  Now I need to specify first the taks reading test then the 
taks ELA.  Students will have either, but it needs to return an empty 
value for the one they don't have.

So far the query looks like:
SELECT students.student_id, students.last_name, students.first_name, 
students.student_id, dob.birthday, students.grade, 
lpac_0708.enrollment_date, 
QUOTE('6/4/2009'),lpac_0708.parent_permission_date, QUOTE('May 
2008'),wcm.broad, special_ed.spec_ed, QUOTE('May 2008') from students 
LEFT OUTER JOIN dob ON dob.student_id = students.student_id LEFT OUTER 
JOIN lpac_0708 ON lpac_0708.student_id=students.student_id LEFT OUTER 
JOIN wcm ON students.student_id=wcm.student_id LEFT OUTER JOIN 
special_ed ON students.student_id = special_ed.student_id LEFT OUTER 
JOIN taks ON taks.student_id = students.student_id;"
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

Don Davis | 1 Jun 01:21 2009

Re: OT: SQL query

Don Davis wrote:
> Thank you.  Now I need to specify first the taks reading test then the 
> taks ELA.  Students will have either, but it needs to return an empty 
> value for the one they don't have.
> 
I'm going with a couple of CASE statements:
CASE WHEN EXISTS (SELECT test_subject from taks WHERE 
students.student_id = taks.student_id AND 
taks.test_subject='Reading')THEN taks.scale_score ELSE 'N/A' END

This returns all scale scores but I need it to return the specific scale 
score.
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

Michael Burek | 1 Jun 02:56 2009

Re: OT: SQL query

SELECT
	students.student_id,
	students.last_name,
	students.first_name,
	students.student_id,
	dob.birthday,
	students.grade,
	lpac_0708.enrollment_date,
	QUOTE('6/4/2009'),
	lpac_0708.parent_permission_date,
	QUOTE('May 2008'),
	wcm.broad,
	special_ed.spec_ed,
	QUOTE('May 2008'),
	ISNULL (taks_reading.scale_score, '') as ReadingGradeLetter,
	ISNULL (taks_ela.scale_score, '') as ElaGradeLetter
FROM students
	LEFT OUTER JOIN dob
		ON dob.student_id = students.student_id
	LEFT OUTER JOIN lpac_0708
		ON lpac_0708.student_id=students.student_id
	LEFT OUTER JOIN wcm
		ON students.student_id=wcm.student_id
	LEFT OUTER JOIN special_ed
		ON students.student_id = special_ed.student_id
	LEFT OUTER JOIN taks as taks_reading
		ON taks_reading.student_id = students.student_id
			AND taks_reading.subject = 'Reading'
	LEFT OUTER JOIN taks as taks_ela
		ON taks_ela.student_id = students.student_id
(Continue reading)

Spambox | 1 Jun 04:50 2009

Re: RHCE exam

I've taken it and I teach courses to prepare others for it.  It is one of the most difficult certifications in its field... and one of the most respected due to its difficulty.  Jeremiah is correct, that the chief sources of its difficulty are it's breadth and the time limit -- none of the components, taken individually and without a time limit, are that difficult.  But taken in the context of the exam, you are truly required to have a mastery of a broad array of configuration tasks.

The best resource for self-study I've seen is the Michael Jang RHCE Prep Guide (should easily find it with Google or on Amazon).  ACC also offers a continuing education course based on the Jang book which begins a week from tomorrow (I teach it) -- but don't take the course expecting it alone to fully prepare you (even Red Hat's own RH300 class rarely does that -- there's a high failure rate even for those who've taken the class).  You'll need to plan to do a LOT of practice and self study even if you supplement your plan with a course.

Good luck -- and don't hesitate to let me know how I can assist you!

Scott Purcell

On Sun, May 31, 2009 at 3:19 PM, Jeremiah T. Gray <jtg-wwTFxEynDWb3oGB3hsPCZA@public.gmane.org> wrote:
Ditto.  They have study guides online, and the RHCE material seems rather extensive. https://www.redhat.com/certification/rhce/prep_guide/
Hmm, actually it doesn't look technically hard (unless they prohibit use of man), but it's definitely covering a lot of ground, and it's timed.



On May 31, 2009, at 1:06 PM, George Goodyear wrote:

From the people I have heard from took the exam, all of the Redhat exams are hard except for maybe the most basic one.

Carlos

Jeffrey Gipson wrote:
Anyone ever taken the RHCE exam?  How hard is it?  I'm thinking about  studying and taking it.

Cheers.

--
Jeff Gipson
Process Networks Plus, Inc.




_______________________________________________ ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg


_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
Don Davis | 1 Jun 13:40 2009

Re: OT: SQL query


Thank you. I should have figured out the ISNULL from your previous 
response.

> 	ISNULL (taks_reading.scale_score, '') as ReadingGradeLetter,
> 	ISNULL (taks_ela.scale_score, '') as ElaGradeLetter

Oops. I kept trying WHERE when I should have been using AND.
> 	LEFT OUTER JOIN taks as taks_reading
> 		ON taks_reading.student_id = students.student_id
> 			AND taks_reading.subject = 'Reading'
> 	LEFT OUTER JOIN taks as taks_ela
> 		ON taks_ela.student_id = students.student_id
> 			AND taks_ela.subject = 'ELA'

This has been very helpful.

What if I want to work with two tables (jr_high_1, and jr_high_2) as if 
they're one?
(They have similar but not identical fields; the field names are the 
same when they exist, they just aren't all available in both.)
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

Jeffrey Gipson | 1 Jun 13:54 2009

Re: RHCE exam

What's the ACC course and Section Number?

I've been abusing Linux for a decade and I'm pretty comfortable with  
most aspects of the OS.  I've been avoiding LVM and IPV6 like a  
plague, so I'll have to learn that.  My first week of using Linux I  
learned A) Not to generally login as root and B) how to install Linux  
5 times in 4 days.

I actually bought RHCE/M. Jang this weekend.  I guess it's the  
mysterious nature of the timed exam that concerns me the most.  Does  
the ACC course provide plenty of practice fixing troubled RedHat  
systems under time limit?

I was hoping I could maybe find a bunch of VMWare or XEN virtual  
machines that were already 'set-up' to have problems similar to RHCE  
for practice.

On a slightly different note, does anyone know what an RCHE does to  
one's pay-grade/career?  I'm also wondering if the RHCE will benefit  
me beyond adding initials to my résumé and 'opening doors.'

Thanks for the info.

On May 31, 2009, at 9:50 PM, Spambox wrote:

> I've taken it and I teach courses to prepare others for it.  It is  
> one of
> the most difficult certifications in its field... and one of the most
> respected due to its difficulty.  Jeremiah is correct, that the chief
> sources of its difficulty are it's breadth and the time limit --  
> none of the
> components, taken individually and without a time limit, are that
> difficult.  But taken in the context of the exam, you are truly  
> required to
> have a mastery of a broad array of configuration tasks.
>
> The best resource for self-study I've seen is the Michael Jang RHCE  
> Prep
> Guide (should easily find it with Google or on Amazon).  ACC also  
> offers a
> continuing education course based on the Jang book which begins a  
> week from
> tomorrow (I teach it) -- but don't take the course expecting it  
> alone to
> fully prepare you (even Red Hat's own RH300 class rarely does that --
> there's a high failure rate even for those who've taken the class).   
> You'll
> need to plan to do a LOT of practice and self study even if you  
> supplement
> your plan with a course.
>
> Good luck -- and don't hesitate to let me know how I can assist you!
>
> Scott Purcell
>
> On Sun, May 31, 2009 at 3:19 PM, Jeremiah T. Gray  
> <jtg@...> wrote:
>
>> Ditto.  They have study guides online, and the RHCE material seems  
>> rather
>> extensive. https://www.redhat.com/certification/rhce/prep_guide/Hmm,
>> actually it doesn't look technically hard (unless they prohibit use  
>> of man),
>> but it's definitely covering a lot of ground, and it's timed.
>>
>>
>>
>> On May 31, 2009, at 1:06 PM, George Goodyear wrote:
>>
>> From the people I have heard from took the exam, all of the Redhat  
>> exams
>> are hard except for maybe the most basic one.
>>
>> Carlos
>>
>> Jeffrey Gipson wrote:
>>
>> Anyone ever taken the RHCE exam?  How hard is it?  I'm thinking about
>> studying and taking it.
>>
>> Cheers.
>>
>> --
>> Jeff Gipson
>> Process Networks Plus, Inc.
>>
>>
>>
>>
>> ------------------------------
>>
>> _______________________________________________
>> ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
>>
>> _______________________________________________
>> ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
>>
>>
>>
>> _______________________________________________
>> ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
>>
> _______________________________________________
> ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

Attachment (smime.p7s): application/pkcs7-signature, 3482 bytes
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
Jeffrey Gipson | 1 Jun 13:56 2009

Re: New Member?

Theoretically, the same as anything else running Samba.  Are you  
having a specific problem?

On May 31, 2009, at 5:23 PM, ed wrote:

> Don Davis wrote:
>> ed wrote:
>>
>>> Well, Hello there!  That was fast.  How active is this group,  
>>> normally?  Down here, its the usual -- a few bullets daily, then a  
>>> shotgun-blast or two when there's an issue that grabs folk.   
>>> Pretty much the same here?
>>>
>>>
>> Yes. Sometimes we go days without a post.  Sometimes it's a regular  
>> torrent.
>>
> That's great!  Anyone have any experience hooking-up Ubuntu to  
> Active Directory?
>
> Cheers;
> Ed
>
> _______________________________________________
> ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

Attachment (smime.p7s): application/pkcs7-signature, 3482 bytes
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
Don Davis | 1 Jun 14:05 2009

Re: OT: SQL query

Don Davis wrote:
> Thank you. I should have figured out the ISNULL from your previous 
> response.
> 
>> 	ISNULL (taks_reading.scale_score, '') as ReadingGradeLetter,
>> 	ISNULL (taks_ela.scale_score, '') as ElaGradeLetter

ISNULL is not valid in Sqlite but COALESCE worked instead.
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

ed | 1 Jun 16:03 2009
Picon

Re: New Member?



Jeffrey Gipson wrote:
Theoretically, the same as anything else running Samba.  Are you having a specific problem?
Actually, I'm already hooked into AD (using "likewise"), but I'm looking for a way to provide a common desktop and suite of applications (some proprietary) to whomever logs into the domain via the Ubuntu machine.  Any thoughts?

Cheers;
Ed
==========================


On May 31, 2009, at 5:23 PM, ed wrote:

Don Davis wrote:
ed wrote:

Well, Hello there!  That was fast.  How active is this group, normally?  Down here, its the usual -- a few bullets daily, then a shotgun-blast or two when there's an issue that grabs folk.  Pretty much the same here?


Yes. Sometimes we go days without a post.  Sometimes it's a regular torrent.

That's great!  Anyone have any experience hooking-up Ubuntu to Active Directory?

Cheers;
Ed

_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg

_______________________________________________ ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg
Michael Burek | 1 Jun 16:32 2009

Re: OT: SQL query

> What if I want to work with two tables (jr_high_1, and jr_high_2) as if
> they're one?
> (They have similar but not identical fields; the field names are the
> same when they exist, they just aren't all available in both.)

SELECT students.id, jr.field1, jr.field2
FROM students
	INNER JOIN (SELECT *
				FROM jr_high_1
				UNION ALL
				SELECT *
				FROM jr_high_2
				) as jr
		ON students.student_id = jr.student_id
				
This works best if jr_high_1 and jr_high_2 have distinct values from
each other and are ready to go.
I think if you need to do any where clauses on jr_high_1 or jr_high_2,
then I think you need to select them into a temporary table before
joining.
_______________________________________________
ALG Mailing List http://austinlug.org/cgi-bin/mailman/listinfo/alg


Gmane