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

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

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

Re: RHCE exam

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

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

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

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

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

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

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

Re: New Member?

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

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