Thursday, May 14, 2009

SQL - Structured Query Language


what is SQL?

SQL (Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.

SQL is a querying language for querying and modifying data and managing databases. SQL was standardized first by the ANSI and later by the ISO. Most database management systems implement a majority of one of these standards and add their proprietary extensions. SQL allows the retrieval, insertion, updating, and deletion of data.

OR

Structured Query Language (SQL) is a specialized language for updating, deleting, and requesting information from databases. SQL is an ANSI and ISO standard, and is the de facto standard database query language. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server. It is widely used in both industry and academia, often for enormous, complex databases.

 

In a distributed database system, a program often referred to as the database's "back end" runs constantly on a server, interpreting data files on the server as a standard relational database. Programs on client computers allow users to manipulate that data, using tables, columns, rows, and fields. To do this, client programs send SQL statements to the server. The server then processes these statements and returns replies to the client program.

 

Learn Oracle, SQL, PL/SQL, XML

http://it.toolbox.com/blogs/oracle-guide/learn-oracle-the-index-10395

 

Video Tutorials

Basics: SQL, PL/SQL, 

For Developers: Forms, Reports and Other Tools

For DBA's: Fundamentals and Performance

http://iselfschooling.com/

 

SQL Tutorial

http://www.w3schools.com/sql/default.asp

 

About SQL

http://oreilly.com/pub/ct/19

 

Basic SQL Tutorial

http://www.killerphp.com/mysql/basic-sql-tutorial.php

 

Tutorial: Writing Transact-SQL Statements

http://msdn.microsoft.com/en-us/library/ms365303.aspx

 

Beginner SQL Tutorial

http://beginner-sql-tutorial.com/sql.htm

 

Learn SQL through Blogs

 

http://mywebtutorials.blogspot.com/2009/03/sql-structured-query-language-tutorials.html

 

http://www.dec2007.com/2009/05/sql-tutorial-eg.html

 

 

www.sqlquiz.com  -This is a cool little site that does a little sql quiz.  Most of it is pretty generic stuff and will apply to any dbms

 

SQL Tutorial With Examples

 

http://www.sql-tutorial.net/

 

http://www.sql-tutorial.com/

 

http://www.academictutorials.com/sql/

 

http://www.1keydata.com/sql/sql.html

 

http://www.webdevelopersnotes.com/tutorials/sql/index.php3

 

http://www.globalguideline.com/sql/

 

http://www.quackit.com/sql/tutorial/

 

http://w2.syronex.com/jmr/edu/db/introduction-to-oracle/

 

http://www.tizag.com/sqlTutorial/sqltables.php

 

http://sqlzoo.net/

 

http://www.baycongroup.com/tocsql.htm

 

http://www.learn-sql-tutorial.com/DatabaseBasics.cfm

 

http://www.coderecipes.net/

 

http://www.thundersoftware.com/churchdb/sqltutorial/sql_tutorial.html

 

 

The Fifteen-Minute SQL Tutorial

http://docstore.mik.ua/orelly/perl/sysadmin/appd_01.htm

 

SQL Example, Codes and Tutorials

http://www.roseindia.net/sql/

 

Understanding how SQL databases work

http://php.about.com/od/learnmysql/ss/mysql.htm

 

SQL Server / T-SQL Tutorial

http://www.java2s.com/Tutorial/SQLServer/CatalogSQLServer.htm

 

Oracle SQL Tutorial

http://www.scribd.com/doc/8405803/sql-tutorial

 

http://www.tutorialized.com/tutorial/Oracle-PL-SQL-Tutorial/37326

 

Step by Step Oracle PL-SQL Tutorial

http://www.exforsys.com/tech-articles/pl-sql/step-by-step-oracle-plsql-tutorial.html

 

The SQL Language

http://www.php-editors.com/postgres_manual/tutorial-sql.html

 

Oracle/SQL Tutorial

http://www.db.cs.ucdavis.edu/teaching/sqltutorial/

 

SQL Tutorial

http://cas.sdss.org/dr7/en/help/howto/search/

 

EnterpriseDB SQL Tutorial: The SQL Language

http://www.developers.net/enterprisedbshowcase/view/1431

 

An Interactive SQL(Structured Query Language) Tutorial

http://www.bin-co.com/database/sql_tutorial/

 

http://www.xlinesoft.com/articles/interactive_sql_tutorial/index.htm

 

Speaking SQL

http://www.linuxjournal.com/article/2421

 

http://www.sqlcourse.com/

1 comment:

SEO tools said...

Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.

Post a Comment