SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Junior Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    SQL.. where to start?

    I am in the process of ungrading my skills and am thinking about taking up SQL. Can anyone suggest a good starting point?
    Should I lean more towards Oracle?
    Any books that are good for a newbie like me to pick up to get my feet wet?

    -Hambone

    ------------------

  2. #2
    Senior Member
    Join Date
    Aug 2001
    Location
    Denver, CO
    Posts
    295
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    If you are looking for Oracle specifically, then you must have to have a good understanding of Oracle Architecture such as how SGA works. If you are looking for general SQL improvment then Oracle9I SQL certification may helps. If you are completely have no clue what is SQL then try "SQL The complete reference" . If you are in a database testing industry then you have to know all major database vendors such as SQL Server 2000, Oracle, AS400 DB2, and UDB.

    Bottom line.. practice practice practice ..study alone doesn't helps.

    Good luck.

    ------------------
    How many ways can I break your code
    ================================
    IBM Certified Database Administrator
    Sun Certified Java Programmer
    Oracle Certified Associate

  3. #3
    Senior Member
    Join Date
    May 2001
    Location
    Ankh-Morpork
    Posts
    2,882
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    In theory at least, SQL is SQL. In practice, there may be some differences on how you do things, but your basic SQL syntax should be the same. Certainly Oracle is very prevalent, so it wouldn't hurt to learn more about it (including the Oracle SQL*Plus interface). MySQL is open source and freely downloadable for most platforms, so this could be a convenient tool for you to learn on. I don't have any good book recommendations, as the couple I have are not particularly good, especially for beginners. (I am an advanced beginner, or maybe beginning intermedidate at best?)

    ------------------
    Charles Reace

    charles{DOT}reace{AT}verizon{DOT}net
    web site | [url=http://www.ebookworm.us/[/url]

    [i]...Sound trumpets! Every trumpet in the host! / Sixty thousand, on these words, sound, so high the mountains sound, and the valleys resound.</i] (The Song of Roland)

  4. #4
    Advanced Member
    Join Date
    Aug 2001
    Location
    Minneapolis, MN
    Posts
    953
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    Where to start? If'n it were my nickle (adjusted up from two cents...for inflation), I would start out first with acquiring solid knowledge in database design and theory. If you don't have a good grounding in understanding databases, I think that you would be cheating yourself.

    ------------------
    Jason Trebilcock
    Cyberentomological Detection, Prevention, and Eradication Specialist
    Wells Fargo
    Jason Trebilcock

    "The single biggest problem in communication is the illusion that it has taken place."

    -George Bernard Shaw, Irish playwright and Nobel Prize winner, 1856-1950

  5. #5
    Member
    Join Date
    Jan 2001
    Location
    San Jose
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    Start here http://technet.oracle.com

    ------------------


    [This message has been edited by qashark (edited 03-06-2002).]

  6. #6
    Senior Member
    Join Date
    Dec 1999
    Location
    Chicago,Illinois,USA
    Posts
    2,537
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    As Charles says, SQL is pretty much SQL, at least in terms of the basics. You can then learn the specific "extensions" relative to given databases after you have the foundation.

    One logical choice to get at least some more information is the SQL Portal. You might also check out SQL Course. Of course, just doing a search on +"SQL tutorial" in a Web browser can also help you out. For example, there is an Oracle/SQL tutorial, although it is a little too little, in my opinion. There are many others, however. Some are dedicated to SQL Server or Oracle and others are just general SQL.

    As E-Quality mentioned, you need to get a database. You can practice SQL with Access, of course, if you have it. You can also, as Charles suggested, try MySQL, which is free. There are also tutorials around for MySQL, such as how to set it up and how to work with it.

    ------------------

  7. #7
    Junior Member
    Join Date
    Nov 2001
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    I assume that what you want is to be able to test the "back-end" of typical business client-server applications. To get started you really don't need to know much about database theory or the plumbing of oracle. You should be very comfortable with writing queries (mostly run interactively) and be able to insert and modify data (you don't need to be quite so comfortable with this at the beginning). As previously noted, SQL has a standard syntax which you can learn on any SQL compliant database, but they all have their differences too (the interactive environment especially). It is possible to install oracle on a PC running Windows NT/2000 professional or linux. If you do that, I would recommend the book ORACLE8i The Complete Reference. It starts off assuming you know nothing about databases and goes to a moderately high level. It also includes a good reference section in addition to the tutorial portion.

    ------------------

  8. #8
    Senior Member
    Join Date
    Dec 2000
    Location
    Portland, OR
    Posts
    403
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    I would hope that you already have a database all setup that you can play with. If this is not the case, you willprobably need some help in setting one up.

    Also it depends a little on which platform you plan on using.

    If you are starting form scratch (new install) on a PC, I'd say (can't believe I'm saying this) start with a MS SQL product - SQL7, or SQL 2000. Its pretty easy to set up (even I could do it), and pretty easy to move around in.

    On a UNIX box, I had to set up a sybase DB once, but this was over 3 years ago, and I can't recall if it was easy or not. I think it was a struggle though. I'm probably blocking it out of my head actually... LOL

    But generally SQL is SQL, but the exact dialect may change a little. Many books are available, and they should give you enough to get started. I took a SQL class in Boston once.. It was an intro class, and to tell you the truth, the handout were all I needed to get started.. granted I don't do a whole heck of a lot with it besides insert, modify, and query, and I don't performance tests the stored proceddures, but I can use SQL to find out what I need for the most part.


    Good luck!

    ------------------
    It Depends.
    It Depends.

  9. #9
    Advanced Member
    Join Date
    Dec 1999
    Location
    Toronto
    Posts
    794
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by Charles Reace:
    In theory at least, SQL is SQL. In practice, there may be some differences on how you do things, but your basic SQL syntax should be the same.<HR></BLOCKQUOTE>What about ";" at the end of the query?
    It should/should not be there.
    Yury
    Testing, Performance Testing, Performance Engineering

  10. #10
    Junior Member
    Join Date
    Nov 2001
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL.. where to start?

    The semi-colon is part of the oracle sqlplus syntax and is not part of the sql itself.

    ------------------

 

 
Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 7.50%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 01:36 AM.

Copyright BetaSoft Inc.