What is SQL

Networked applications are becoming increasingly numerous and versatile. In many cases, the basic scheme of operation is a series of scripts that drive the behavior of a database. Due to the diversity of languages and existing databases, how to communicate with each other and would be really complicated to arrange, if not for the existence of standards that allows us to perform the basic operations una universal form.

It is exactly what this is about the Structured Query Language ()SQL that is no more than a standard language for communicating with the database. We speak therefore of a standard language that allows us to work with any language (ASP or PHP) in combination with any type of database (MS Access, SQL Server, MySQL ..).

Being a standard does not mean that it is identical for each database. In practice, certain databases implement specific functions that need not necessarily work in others. Apart from this universality, SQL has two other features much appreciated. On one hand, is extremely powerfil and versatile, for another, its accessible to learn.



< Newer articles | Older articles >

SQL eBooks suggestions

Securing PHP Web Applications Harnessing Hibernate Programming Microsoft? SQL Server? 2008 Beginning PL/SQL: From Novice to Professional PHP: The Good Parts Expert PHP and MySQL Inside Microsoft SQL Server 2005: The Storage Engine Hibernate Recipes: A Problem-Solution Approach Backup & Recovery Pro SQL Server 2008 Administration Inside Microsoft? SQL Server? 2005: T-SQL Querying Oracle PL/SQL Language Pocket Reference Advanced iOS 4 Programming: Developing Mobile Applications for Apple i CLR via C# JD Edwards EnterpriseOne, The Complete Reference