Solved

General Suggestions For Learning SQL

Posted on 1999-01-28
5
531 Views
Last Modified: 2012-06-27
Both my friend and I are interested in learning SQL and know absolutely nothing about it or databasing.  She has a degree in electrical engineering and I have done a lot of C++ programming.

I was hoping someone could answer some general questions that would point the way to start learning SQL.

Would I be correct in thinking that SQL is general language that can be used for deposting/retrieving information from a variety of differnt database software packages and that oracle, sequel server, access etc are examples of database sotware packages?

Is there a standard SQL?  What is the latest version of this standard?  Does Microsoft SQL Server 7 use standard SQL or do they pollute it like Java.  If my friend and I learned SQL on MS SQL Server 7 would we be able to take the sql there and use it in other databases with a minimum of trouble?

Can you reccomend a good SQL book for my friend and I given our background?  What about software to practice sql programming with?  My friend and I have VB 6.  Can we use that to practice what we learn from an sql book?  If so, how?  If not, can you recccomend software for practicing sql with that could be put on a pc?  

Thanks
Steve
0
Comment
Question by:Steve34
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 4

Accepted Solution

by:
mrorph earned 200 total points
ID: 1026361
SQL ( Structured Query Language ) is, as you surmise, a standard language for constructing and accessing a relational database management system ( RDBMS ).  There *is*  a standard, developed by IBM - ANSI but the language features vary among database systems.  

Actually, Java isn't the SQL if you use what is called "passthrough". In this case, the SQL is relative to the database.  If you use Oracle, you can use the SQL that Oracle understands as opposed to say SQL Server or local SQL that the BDE of Borland's ( Inprise ) JBuilder understands.  Mind you that SQL is still basically the same, just minor differences.  ( Just enough to cause headaches from time to time ) <g>

If you learn the standard ANSI SQL ( 1992? ), you won't have any problem adapting to other platforms.

Here are some recommdations that I am sure will have you up to speed in no time:

( just copy and paste the link into the address field in your browser )

**** This one is excellent ****
The Practical Sql Handbook : Using Structured Query Language
http://www.amazon.com/exec/obidos/ASIN/0201447878/o/qid=917574430/sr=2-1/002-0843502-9855842

A Guide to the Sql Standard : A User's Guide to the Standard Database Language Sql
http://www.amazon.com/exec/obidos/ASIN/0201964260/ref=sim_books/002-0843502-9855842

**** Another good one ****
The Essence of SQL : A Guide to Learning Most of SQL in the LeastAmount of Time
http://www.amazon.com/exec/obidos/ASIN/0964981211/qid=917574430/sr=1-12/002-0843502-9855842

With VB, you have an all-purpose language, not necessarily a database language.  It will help you get your feet wet though.  Visual FoxPro has SQL statements native to the language, so you have more of an advantage there, but all in all, VB is easier to learn.

Hope this helps.

Donald


0
 

Author Comment

by:Steve34
ID: 1026362
Do any of the books above come with software where you can actually practice using SQL?   If not is there some cheap software you can install on a pc to practice sql?

Neither of us know VB, would it be too much to learn sql by using the VB editor & compiler?  Could we get away with typing sql code into the VB editor and then hit the compile button?
0
 
LVL 4

Expert Comment

by:mrorph
ID: 1026363
You aren't going to get a database with the books.  Although, don't quote me on that, because, it has been a while for me since I bought a SQL book.  You may get a sample DB on which to practice.  

As far as VB is concerned; all important is the version that you are using.  You can write queries through code but you really will need some type of back-end to write real SQL. You will need an understanding of the VB language as well.  You can use a VB-Access type of configuration, and VB comes with samples to illustrate the methods.  Visual FoxPro, Visual dBase and maybe Access ( don't know for sure ) will give you more robust SQL extensions.  I use Visual FoxPro ( a lot ) and if you could get a copy of that, you can use the command window to practice your SQL.  It also has a query wizard where you can construct queries and then view and modify the generated code.  It is a database language though whereas VB is all-purpose.

Either route you choose, you can still learn SQL because you have to use it to access data.  Although VFP and VdB have their own database manipulation language ( DML ), VB, Delphi, and Java do not, it is better to use SQL.

Feel free to inquire more.

Donald
0
 

Author Comment

by:Steve34
ID: 1026364
Okay.  I guess it is better to leave VB alone at this point and go find some sql software somewhere to practice sql programming along with a good book.

Thanks
0
 

Expert Comment

by:grepya
ID: 1026365
Another option no one seemed to mention was to try a FREE database product like MySQl, Postgresql etc... If you are running them on a unix system ( e.g. linux.. also free) you can also use a lot of free dev. tools ( C, C++, Perl, Java, Python etc.)... some of these you can  find for NT too but they are written with Unix in mind originally and hence work best on a unix system.  And seeing that much of the web database work finally has to run off of a unix server ( ultimately)... you will be one step ahead of the game from the start. Otherwise you will end up asking questions like " I have this Access database which I have been using with VB.. now how do I put it on the web using Apache and perl"
0

Featured Post

Webinar: Choosing a MySQL HA Solution

Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question