Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL

Options
  • 15-07-2009 4:38pm
    #1
    [Deleted User]
    Posts: 5,589 ✭✭✭


    Right, I am looking to finally come to terms with SQL.

    Can anyone recommend a good guide? The ones I've found are either written for complete novices and don't actually do anything more then adding a new database, while the rest seem to be for specific objects and assume a decent level of knowledge.

    I am looking to make a database of people with basic attirbutes that I can then run queries on through a webpage. Any good guides on such a thing? I have Apache, PHP and MySQL installed on a box.


Comments

  • Options
    #2
    Sparks
    Registered Users Posts: 40,038 ✭✭✭✭Sparks


    Well, for a start, there are libraries that will help, like MDB2. After that, for the basic SQL stuff itself, to be honest any of the basic tutorials are okay to start with, and the tutorial in MySQL manual itself is even reasonably good.


  • Options
    #3
    [Deleted User]
    Posts: 5,589 ✭✭✭ [Deleted User]


    Cheers, most of the basic stuff seems stop at:

    Now you've installed MySQL, just intall wordpress and you are set to go.


  • Options
    #4
    PixelPixie
    Closed Accounts Posts: 38 ✭PixelPixie


    I find "Beginning MySQL Database Design and Optimization" by J.Stephens and C.Russel (APRESS) to be excellent. It starts with the MySQL basics, and goes on to Column and Table types, keys, indexes and normalization, Operators, branching, functions, joins, temporary tables, transactions and MySQL programming in subsequent chapters.
    I'd recommend it highly.


  • Options
    #5
    TinCool
    Registered Users Posts: 2,894 ✭✭✭TinCool


    The w3schools website is an extremely useful reference. It covers all the basics giving various examples.


  • Options
    #6
    PixelPixie
    Closed Accounts Posts: 38 ✭PixelPixie


    TinCool wrote: »
    The w3schools website is an extremely useful reference. It covers all the basics giving various examples.
    I second that! W3schools has excellent tutorials on all aspects of web scripting and programming from (x)html to JavaScript to PHP to SQL. I recommend it to my web authoring students.
    However, you can't beat a good book for those times when you're connectionless or can't use your laptop. A good book is invaluable imo.:)


  • Advertisement
Advertisement