Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

sql and databases

by toadi (Chaplain)
on Jul 26, 2000 at 19:15 UTC ( #24504=perlquestion: print w/replies, xml ) Need Help??

toadi has asked for the wisdom of the Perl Monks concerning the following question:


I know this isn't a real perl question. But I encouter the problem a lot.
I'm no real database programmer/analyst but I'm a webdeveloper and I need more then once building and and managing databases for web-apps.

IS there a good resource on the web to learn database-structuring(I know about the most used techniques like normalising) but I haven't got o structured doc to reffer to.

Is there a good online doc(on db's and SQL) or a good book(maybe from o'reilly) I could use to study this?


Replies are listed 'Best First'.
Re: sql and databases
by young perlhopper (Scribe) on Jul 26, 2000 at 19:38 UTC
    I really like this page. If you are looking for a 'quick reference' type of thing, this probably isn't it, but its a good intro and covers a lot of important topics. It's more about database design than an SQL language reference.

    Hope this helps,

      I agree, philip greenspun definitely has some good resources, for sql and web design and programming. Other stuff by him is here

(jcwren) Re: sql and databases
by jcwren (Prior) on Jul 26, 2000 at 20:27 UTC
    toadi, I can't point you at a good book to teach you about database techniques in general, but if you elect to go with mySQL, I can highly recommend the Paul Dubois book from New Riders Press. I can also tell you that as good as most O'Reilly books are, the 'mSQL & MySQL' books is a complete and total waste of money.

    I realize this wasn't the question you asked, but with the cost of technical books, I *hate* winding up with a bad book in my collection.


    e-mail jcwren
(Ovid) Re: sql and databases
by Ovid (Cardinal) on Jul 26, 2000 at 22:43 UTC
    If you'd like to learn SQL online, here's a good course. At least I'm told it's good. I haven't actually taken it :)


      but I found that one to, but it's to beginner aimed. I'm looking for the more intermediate kind of thing.

      Wel I can mak databases, connect to them make simple relation. But I want to be perfect and want to know what I'm doing wrong(maybe?) and what I can improve with some good literature.

      My opinions may have changed,
      but not the fact that I am right

RE: sql and databases
by infinityandbeyond (Sexton) on Jul 27, 2000 at 22:27 UTC
    Surprisingly, I learned a lot about SQL from the mysql documentation. If you want to learn to use it with DBI, you can get the ORA "DBI" book, or: perldoc DBI
Re: sql and databases
by prodevel (Scribe) on Jul 27, 2000 at 10:07 UTC
    I must first say that I'm biased towards Oracle, but you might want to check out if you EVER want to leverage Oracle on your site(s). You'll need access, though.

    Some basic oracle specific design docs are at:

    Just in case...

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://24504]
Approved by root
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2022-10-01 23:42 GMT
Find Nodes?
    Voting Booth?
    My preferred way to holiday/vacation is:

    Results (6 votes). Check out past polls.