Welcome to NESR! Most features of this site require registration, including replying to threads, sending private messages, starting new threads, and uploading files. Click here to register.

Results 1 to 10 of 10

SQL

  1. 03-27-06, 08:40 PM #1
    Rye
    Rye is offline
    Lifer Rye's Avatar
    Join Date
    Nov 2002
    Location
    Behind Enemy Lines
    Posts
    1,624

    SQL

    Gotta start getting my feet wet in SQL...any good advice for curriculum/books. Got the dummies book, but I might need something a bit more structured perhaps with sample databases.

    0 Not allowed! Not allowed!
    '95 ZX7/9
    '02 XR650R
    '78 KZ1000
    Reply With Quote Reply With Quote
  2. 03-29-06, 07:36 AM #2
    GMAN226
    GMAN226 is offline
    Lifer GMAN226's Avatar
    Join Date
    Jul 2001
    Location
    Coventry RI
    Age
    52
    Posts
    1,731

    SQL

    I work with a couple of good SQL Databases. Give me a call at work. I can probably get you some stuff
    G-man
    401-604-2196

    0 Not allowed! Not allowed!
    Gerard
    Reply With Quote Reply With Quote
  3. 03-29-06, 09:12 AM #3
    benVFR
    benVFR is offline
    Lifer
    Join Date
    Oct 2001
    Location
    Bedford, MA
    Posts
    5,234

    SQL

    SQL itself at a basic level is not too bad.

    Understanding complex database schemas and the ins and outs of a particular database takes longer but it's just details.

    Look for a book more on the computer science side then the implementation side to start.

    I wish I still had the book(s) I used in college. Can't recommend them to you cause I don't remember the titles.

    I've been working with Oracle a lot the last year (and now I work at Oracle) and it's just ridiculously complex but that's probably your best bet to learn. And you can download a version of 10g for free for learning now.

    0 Not allowed! Not allowed!
    Reply With Quote Reply With Quote
  4. 03-29-06, 10:58 AM #4
    TurboRush91
    TurboRush91 is offline
    Member
    Join Date
    Nov 2005
    Location
    Portsmouth, NH
    Age
    46
    Posts
    227

    SQL

    Originally posted by benVFR
    SQL itself at a basic level is not too bad.

    Understanding complex database schemas and the ins and outs of a particular database takes longer but it's just details.

    Look for a book more on the computer science side then the implementation side to start.

    I wish I still had the book(s) I used in college. Can't recommend them to you cause I don't remember the titles.

    I've been working with Oracle a lot the last year (and now I work at Oracle) and it's just ridiculously complex but that's probably your best bet to learn. And you can download a version of 10g for free for learning now.
    As said above, SQL itself is pretty straight forward... I do mostly development with java but occasionally have to write my own queries to troubleshoot stuff and see what the hell is going on, but the SQL and DB for dummies are a good place to start and whenever I hit an issue, Google == my friend

    Might be worth looking for some books have excerises with samples already in place.

    I guess it really depends on how complex you envision things being... worst case scenerio you hit one of the many IT geeks on here for help

    0 Not allowed! Not allowed!
    Reply With Quote Reply With Quote
  5. 03-29-06, 12:19 PM #5
    HBerry
    HBerry is offline
    Work U HBerry's Avatar
    Join Date
    Jun 2004
    Location
    Nashua
    Age
    41
    Posts
    2,624

    SQL

    I'm taking a SQL class right now, making the DB is actually pretty easy, its all the extra shit they make you do in class that sucks.

    0 Not allowed! Not allowed!
    --HBerry

    LRRS# 285 - Retired
    04 ZX-6R
    88 EX500 - Broke
    Reply With Quote Reply With Quote
  6. 03-29-06, 01:46 PM #6
    CitizenFrye
    CitizenFrye is offline
    I feel it in my Nuggets CitizenFrye's Avatar
    Join Date
    Apr 2005
    Location
    RI
    Age
    61
    Posts
    353

    SQL Fundamentals

    This book is pretty good...

    SQL Fundamentals 2nd Ed.
    ISBN 0-13-066947-4

    0 Not allowed! Not allowed!
    <h5 style="color:ccc"><i>Put the Fun Between your Legs</i></h5>
    <h5 style="color:ccc"><i> CBR1000RR </i></h5>
    Reply With Quote Reply With Quote
  7. 03-29-06, 10:06 PM #7
    Rye
    Rye is offline
    Lifer Rye's Avatar
    Join Date
    Nov 2002
    Location
    Behind Enemy Lines
    Posts
    1,624

    SQL

    Originally posted by GMAN226
    I work with a couple of good SQL Databases. Give me a call at work. I can probably get you some stuff
    G-man
    401-604-2196

    Thanks G. I'll probably hit you up for that. I have been trying to convince the IT folks to give me Embarcadero and a development box to fugg with practicing some basic queries, but my company is ultra sensitive to this being practice tool... I can understand to some degree as I could conceivably choke the server.

    Ben, I will be doing some implementation work. I just took a job @ a financial software/consulting firm and I need to start getting some query skills and better understanding of dB structure. I was hired for my business side background and the "technical" skills will have to follow. I don't think I will be doing any programming so maybe a simple stored procedure but that is gonna be it.


    Hberry...let me know what's up with that course if you have a chance.

    0 Not allowed! Not allowed!
    '95 ZX7/9
    '02 XR650R
    '78 KZ1000
    Reply With Quote Reply With Quote
  8. 03-30-06, 07:50 AM #8
    HBerry
    HBerry is offline
    Work U HBerry's Avatar
    Join Date
    Jun 2004
    Location
    Nashua
    Age
    41
    Posts
    2,624

    SQL

    The course I am taking is called Database Management at UMass Lowell for my MIS degree. The first half of the class is spent going over queries and understanding what a database looks like and now we are getting into designing our own. I can send you a document that shows how to do queries if you would like?

    0 Not allowed! Not allowed!
    --HBerry

    LRRS# 285 - Retired
    04 ZX-6R
    88 EX500 - Broke
    Reply With Quote Reply With Quote
  9. 03-30-06, 06:58 PM #9
    Rye
    Rye is offline
    Lifer Rye's Avatar
    Join Date
    Nov 2002
    Location
    Behind Enemy Lines
    Posts
    1,624

    SQL

    I'll take what I can get. I might look at courses at the locl Universities too.

    My e-mail is:
    rye_02151@yahoo

    0 Not allowed! Not allowed!
    '95 ZX7/9
    '02 XR650R
    '78 KZ1000
    Reply With Quote Reply With Quote
  10. 03-31-06, 08:18 AM #10
    HBerry
    HBerry is offline
    Work U HBerry's Avatar
    Join Date
    Jun 2004
    Location
    Nashua
    Age
    41
    Posts
    2,624

    SQL

    This is my prof. website: http://faculty.uml.edu/xli/Courses/63.403/default.htm

    The one that I was referring to was "Introduction to SQL, Part 1" but I think you should be able to find helpful information in many of them.

    0 Not allowed! Not allowed!
    --HBerry

    LRRS# 285 - Retired
    04 ZX-6R
    88 EX500 - Broke
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Page generated in 0.029 seconds with 14 queries.