Discussion Locked

SQL

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

What is SQL? What is SQL for? What is advantage by using SQL?
Could you advice me on this, because I am at the first level to learn about SQL.
Which book/website are you recommend to me?

Thank you

7 replies

by pikikoko

Try reading these two books I found them helpful. Microsoft Press "INside SQL Server 7.0 and Micorsoft press " Sql Server 7.0 database Implementation online training kit"
SQL allows you to put questions to your data base in plain english. Let me know if these books are helpful.
Good luck
Mike

by raffi_

SQL is StructuredQueryLanguage.

It's purpose is twofold. The first is that it allows for the manipulation and creation of database structures. I can create db tables, indexes, keys etc.

The second is that it allows the manipulation of data within an existing DB structure. You can sort, delete extract(query) from the db.

SQL's advantages are many. It is, or was intended to be, platform independant. Therefore, a given set of SQL instructions would work for any database. In reality this is not true. Each software company has developed and tweaked it's own flavour of SQL. The big ones, MS_SQL, ORACLE etc., do support the ISO standard as well as there own.

I recommend that you get a hold of a DB that 'does' SQL. There are lots of 'free' ones out there -MYsql, DBman etc. and not so free Access, Oracle etc.

Here is a good link:
http://www.dcs.napier.ac.uk/~andrew/sql/

Regards
Raffi_

by d. brinson

SQL - Structured Query Language

It is a way to manipulate/view data in a relational database. There are many different "flavors" of SQL since every major producer (ORACLE, Microsoft, etc) puts its own unique mark on it. However, the "core" shouldbe platform independent.

As for bookmarks, there is any introductor SQL tutorial at:
w3.one.net/~jhoffman/sqltut.htm

Here are a couple other useful sites:
www.jcc.com/sql_stnd.html
www.vb-bookmark.com/vbSQL.html
www.sqlcourse.com/

Hope this helps.

This discussion is closed to new replies.