SQL
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
Desktop
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
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 fendi86
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 fendi86
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.
by fendi86
by fendi86
This discussion is closed to new replies.
Sort by Trending