Results 1 to 14 of 14

Thread: Sql

  1. #1
    Senior Member
    Join Date
    Jul 2003
    Location
    Nott'm, East Midlands
    Posts
    1,954
    Thanks
    0
    Thanked
    0 times in 0 posts

    Sql

    Lo all,

    I will need to learn SQL for my new job, so thought it would be a good idea and show initiative if I took some steps to help myself learn SQL.

    I will be using both Business Objects and Oracle.

    Are there any websites / programs / books that I should be looking into / at?

    Any help appreciated,

    Kind Regards,

    Nick

  2. #2
    HEXUS.net Webmaster
    Join Date
    Jul 2003
    Location
    UK
    Posts
    3,108
    Thanks
    1
    Thanked
    0 times in 0 posts

  3. #3
    ICY
    ICY is offline
    Registered+
    Join Date
    Oct 2003
    Posts
    15
    Thanks
    0
    Thanked
    0 times in 0 posts
    www.mysql.com

    check the user manual

  4. #4
    HEXUS.net Webmaster
    Join Date
    Jul 2003
    Location
    UK
    Posts
    3,108
    Thanks
    1
    Thanked
    0 times in 0 posts
    I will be using both Business Objects and Oracle.
    Mysql.com won't be much help if he's going to be doing Oracle and/or Business Objects as MySQL isn't a proper ANSI based SQL language

  5. #5
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,773
    Thanks
    22
    Thanked
    40 times in 24 posts
    Although it's Jet-SQL primarily used for MSSQL Server, www.devguru.com has a very useful and quick to use reference (also very handy for other languages).
    Simon


  6. #6
    Kirstie Allsopp Theo's Avatar
    Join Date
    Jul 2003
    Location
    Sunny Bolton
    Posts
    2,777
    Thanks
    17
    Thanked
    23 times in 20 posts
    • Theo's system
      • Motherboard:
      • Asus P5B Wifi deluxe
      • CPU:
      • E6600 @ 3150Mhz
      • Memory:
      • 2x2GB OCZ 6400
      • Storage:
      • 1x80GB Maxtor
      • Graphics card(s):
      • 640MB 8800GT
      • Monitor(s):
      • ASUS M221u
      • Internet:
      • Be Value
    Lead_Head YGPM

  7. #7
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    Ah Oracle. You will be needing these in the near future:

    COMMIT;
    COMMIT;
    COMMIT;
    COMMIT;
    COMMIT;
    COMMIT;
    COMMIT;

    If you have no idea wtf I am on about worry not; you will soon
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  8. #8
    Senior Member Kezzer's Avatar
    Join Date
    Sep 2003
    Posts
    4,863
    Thanks
    12
    Thanked
    5 times in 5 posts
    Luckily for me i had some personal tutorials on mySQL so i now understand it to an extent. It's not hard once you get the hang of it.

  9. #9
    Senior Member
    Join Date
    Jul 2003
    Location
    Nott'm, East Midlands
    Posts
    1,954
    Thanks
    0
    Thanked
    0 times in 0 posts
    Theo - thanks for those pages, will work through them at the w/end.

    Thanks all for the feedback, I've been told theres some books at my work to guide me through, but it will be even easier when I work through the links given by u lot.

    Cheers again,
    Nick

  10. #10
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    If you get stuck at work just post a message here. I'd say that there's quite a lot of SQL experience on the Hexus forums. I've been using it for about 7 years mainly on Squirrel Server and MySQL but have used Oracle here and there.

    You are fortunate to be using Oracle; you cannot have a better RDBMS to put on your CV.
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  11. #11
    Kirstie Allsopp Theo's Avatar
    Join Date
    Jul 2003
    Location
    Sunny Bolton
    Posts
    2,777
    Thanks
    17
    Thanked
    23 times in 20 posts
    • Theo's system
      • Motherboard:
      • Asus P5B Wifi deluxe
      • CPU:
      • E6600 @ 3150Mhz
      • Memory:
      • 2x2GB OCZ 6400
      • Storage:
      • 1x80GB Maxtor
      • Graphics card(s):
      • 640MB 8800GT
      • Monitor(s):
      • ASUS M221u
      • Internet:
      • Be Value
    Lead_Head - do you fancy this weeks lessons, too? It's just an advancement on last week, but with basic php involved

    Let me know, and I'll upload them for you.

  12. #12
    Senior Member
    Join Date
    Jul 2003
    Location
    Pit, stone.
    Posts
    643
    Thanks
    0
    Thanked
    0 times in 0 posts
    Theo, could you copy me too? I'm doing Visual Foxpro at work, or at least I need to learn some more, which uses some SQL statements like SELECT and I think a broader overview would be useful..

    Cheers!
    Well Hello!

  13. #13
    DsW
    DsW is offline
    Senior Member
    Join Date
    Aug 2003
    Location
    Glasgow
    Posts
    292
    Thanks
    0
    Thanked
    0 times in 0 posts
    The O'Reilly Oracle PL/SQL book is a good book if you'll be doing any PL/SQL programming.

    cheers,
    dave

  14. #14
    Member
    Join Date
    Sep 2003
    Posts
    95
    Thanks
    0
    Thanked
    1 time in 1 post
    Hi mate,

    if you head over to technet.oracle.com you will find everything you ever need to know about Oracle SQL. You can also download a 8.1.7 ot 9i database to install and play with at home.

    Oracle is THE RDBMS to have on your CV but it is also worth knowing a bit about mySQL, DB2 and SQL Server. Anything you learn in Oracle can be easily transfered to the other RDBMS vendors but most of the functions sum() etc are non standard SQL.

    Shout of you have any difficulties

    HT

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •