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 Tips

Options
  • 12-08-2005 4:05pm
    #1
    Fra
    Closed Accounts Posts: 2 ✭


    Hey Am new on boards as i've started a new job in SQL programming for a data warehouse compnay can anyone give me a few tips on wee i canget good examples for SQl that relate to Datawarehouse domain....

    Thanks


Comments

  • Options
    #2
    Fra
    Closed Accounts Posts: 2 ✭Fra


    Fra wrote:
    Hey Am new on boards as i've started a new job in SQL programming for a data warehouse compnay can anyone give me a few tips on wee i canget good examples for SQl that relate to Datawarehouse domain....

    Thanks
    Test


  • Options
    #3
    Evil Phil
    Registered Users Posts: 7,468 ✭✭✭Evil Phil


    There's a number of places you can go.

    http://www.w3schools.com/ can give you basic tutorials on SQL.
    http://www.sql.org/ is much more indepth.

    http://www.google.com/ can provide you with a lot, you should also become familiar with some of the developer sights as a reference point.

    What database are you working with?


  • Options
    #4
    PhantomBeaker
    Registered Users Posts: 304 ✭✭PhantomBeaker


    I've found the first few chapters (after installation and the like) of the manual for postgresql (http://www.postgresq1.org/ ) to be quite useful. It gives you worked examples of most of your basic (and most common) operations: insert, delete, update, select. Along with joins, creating tables and views. That sorta stuff.

    Just remember, if it's not postgresql you might have a different set of features available (like mysql can't do views last time I checked - dunno about nested queries).

    Hope that helps


  • Options
    #5
    Merrion
    Registered Users Posts: 1,421 ✭✭✭Merrion


    http://groups.google.com probably has a newsgroup for the database you are working on. That is a great place to get help/code.


  • Options
    #6
    Civilian_Target
    Registered Users Posts: 5,618 ✭✭✭Civilian_Target


    If you're starting out on SQL for the first time - Queens University Belfast lecture notes for their Database course are online at http://main.cs.qub.ac.uk/~mfarid/teaching/data_proc_data_base/Class_Notes_CSC202_CSC322.pdf

    Theres a lot of theory in there you won't need, but the worked SQL examples (in Chapter 14 i think) could prove quite useful to you.


  • Advertisement
  • Options
    #7
    Syth
    Registered Users Posts: 1,865 ✭✭✭Syth


    PhantomBeaker wrote:
    I've found the first few chapters (after installation and the like) of the manual for postgresql (http://www.postgresq1.org/ ) to be quite useful. It gives you worked examples of most of your basic (and most common) operations: insert, delete, update, select. Along with joins, creating tables and views. That sorta stuff.

    Just remember, if it's not postgresql you might have a different set of features available (like mysql can't do views last time I checked - dunno about nested queries).

    Hope that helps
    That url is wrong, it should be http://www.postgresql.org/. Don't know how you mixed up '1' and 'l', they are on different sides of the keyboard!

    I vaugly recall reading an article about new features in a recent reease of mysql, one of which was nested quries.


Advertisement