A book which helped me when I first started doing SQL is SQL Queries
for Mere Mortals by Hernandez/Viescas. Extremely well written and easy
to understand. Que has an intro to SQL book that is excellent too!
Hope this helps.
DaveChristman
Cannon Fodder <technews_at_invalid.sorry> wrote in message news:<Pine.LNX.4.21.0107250437030.4429-100000_at_charlie.mygroup>...
> Hi,
>
> Which book 'out there' on understanding SQL is the best? Would
> the free documentation from the postgresql web sites be just as
> good?
>
> I'm trying to create a system that keeps track of items in an
> organizational fashion. It's something similar to keeping track
> of a fictional company's internal staff
> organization. Questions for which I'm thinking up
> procedural-based algorithmic functions:
>
> Who is the CEO, the floor manager, the immediate supervisor, and
> the co-workers, and who has supervisory rights over which people?
> What fundamental fields might be used to achieve this:
> 'PersonID', 'ImmediateSupervisorID', 'StaffLevelID', 'FirstName'
> and 'LastName'?
>
> What happens if a person gets promoted? Who has to be notified
> about the promotion, and what would be the most efficient method
> for doing that notification? Conversely, what entities need to
> be 'notified' about a demotion? How should those entities be
> notified in either case (promotion or demotion).
>
> What if a supervisor (from any level) decides to go
> to another department and leaves his underlings behind?
>
> What if new staff gets hired? What if old staff gets fired?
>
> What if the CEO's spouse takes a domineering interest in the
> company, and becomes the Immediate Supervisor of the CEO? Would
> the spouse have the following values: PersonID='-1',
> ImmediateSupervisorID=NULL, StaffLevelID='-1', and
> 'FirstName="MrsCEO"?
>
> There are scores of other questions that I am attempting to
> study for algorithms. But if a free linux-based SQL engine
> (mySQL, postgresql) could solve most of these questions already,
> I'm all for it...in the meantime, any comments or advice about
> any the questions I've posted are quite welcome.
>
> Please post messages back to the NG, or they'll bounce.
>
> -CF
