sql

SQL is the most popular computer language used to create, modify and retrieve data from relational database management systems. The language has evolved beyond its original purpose to support object-relational database management systems. It is an American National Standards InstituteANSI/International Organization for StandardizationISO standard.

History - A seminal academic publishingpaper, acm.org - "A Relational Model of Data for Large Shared Data Banks", by Dr. Edgar F. Codd, was published in June, 1970 in the Association for Computing Machinery (ACM) journal, Communications of the ACM. Codd's model became widely accepted as the definitive model for ''relational'' database management systems (RDBMS).During the 1970s, a group at IBM's San Jose research center developed a database system "System R" based upon Codd's model. Structured English Query Language (''"SEQUEL"'') was designed to manipulate and retrieve data stored in System R. The acronym ''SEQUEL'' was later condensed to SQL due to a trademark dispute (the word 'SEQUEL' was held as a trademark by the Hawker-Siddeley aircraft company of the UK). It should be noted that although SQL was influenced by Dr. Codd's work, it was not designed by Dr. Codd himself; the SEQUEL language design was due to Donald D. Chamberlin and Raymond F. Boyce at IBM.refchamber , and their concepts were published to increase interest in SQL.The first non-commercial non-SQL relational database was developed in 1974.(Ingres from U.C. Berkeley.)In 1978, methodical testing commenced at customer test sites. Demonstrating both the usefulness and practicality of the system, this testing proved to be a success for IBM. As a result, IBM began to develop commercial products that implemented SQL based on their System R prototype, including the System/38 (announced in 1978 and commercially available in August 1979), SQL/DS (introduced in 1981), and DB2 (in 1983).www-03.ibm.comAt the same time Relational Software, Inc. (now Oracle Corporation) saw the potential of the concepts described by Chamberlin and Boyce and developed their own version of a RDBMS for the Navy, CIA and others; and in the summer of 1979, Relational Software, Inc. introduced Oracle V2 (Version2) for VAX computers, as the first commercially available implementation of SQL. Oracle is often incorrectly cited as beating IBM to market by two years, but in a great public relations coup, beat IBM's release of the System/38 by only a few weeks. Considerable public interest then developed; soon many other vendors developed versions, and Oracle's future was ensured.It is often suggested that IBM was slow to develop SQL and relational products, possibly because it wasn't available initially on the mainframe and Unix environments, and that they were afraid it would cut into lucrative sales of their IMS database product, which used navigational database models instead of relational. But at the same time as Oracle was being developed, IBM was developing the System/38, which was intended to be the first relational database system, and was thought by some at the time, because of its advanced design and capabilities, that it might have become a possible replacement for the mainframe and Unix systems.SQL was adopted as a standard by the ANSI (American National Standards Institute) in 1986 and International Organization for StandardizationISO (International Organization for Standardization) in 1987. ANSI has declared that the official pronunciation for SQL is IPA/Es_kju_El/ , although many English-speaking database professionals still pronounce it as ''sequel''. Another widespread misconception is that "SQL" is an initialism that stands for "Structured Query Language" — this is not the case.The SQL standard has gone through a number of revisions:

Scope - The SQL standard is not freely available. SQL:2003 may be purchased from iso.org - ISO or webstore.ansi.org - ANSI. A late draft is available as a wiscorp.com - zip archive from wiscorp.com - Whitemarsh Information Systems Corporation. The zip archive contains a number of Portable Document FormatPDF files that define the parts of the SQL:2003 specification.Although SQL is defined by both ANSI and ISO, there are many extensions to and variations on the version of the language defined by these standards bodies. Many of these extensions are of a proprietary nature, such as Oracle Corporation's PL SQLPL/SQL or Sybase, IBM's SQL PL(SQL Procedural Language) and Microsoft's Transact-SQL. It is also not uncommon for commercial implementations to omit support for basic features of the standard, such as the DATE or TIME data types, preferring some variant of their own. As a result, in contrast to ANSI C programming languageC or ANSI Fortran, which can usually be ported from platform to platform without major structural changes, SQL code can rarely be ported between database systems without major modifications. There are several reasons for this lack of portability between database systems:

the complexity and size of the SQL standard means that most databases do not implement the entire standard.

the standard does not specify database behavior in several important areas (e.g. indexes), leaving it up to implementations of the standard to decide how to behave.

the SQL standard precisely specifies the syntax that a conformant database system must implement. However, the standard's specification of the semantics of language constructs is less well-defined, leading to areas of ambiguity.

many database vendors have large existing customer bases; where the SQL standard conflicts with the prior behavior of the vendor's database, the vendor may be unwilling to break backward compatibility.

some believe the lack of compatibility between database systems is intentional in order to ensure vendor lock-in.SQL is designed for a specific, limited purpose — querying data contained in a relational database. As such, it is a Setset-based, Declarative programming languagedeclarative computer language rather than an Imperative programmingimperative language such as C or BASIC programming languageBASIC which, being programming languages, are designed to solve a much broader set of problems. Language extensions such as PL SQLPL/SQL are designed to address this by turning SQL into a full-fledged programming language while maintaining the advantages of SQL. Another approach is to allow programming language code to be embedded in and interact with the database. For example, Oracle and others include Java programming languageJava in the database, while PostgreSQL allows functions to be written in a wide variety of languages, including Perl, Tcl, and C programming languageC.One joke about SQL is that "SQL is neither structured, nor is it limited to queries, nor is it a language." This is founded on the notion that ''pure'' SQL is not a classic programming language since it is not ''Turing completenessTuring-complete''. On the other hand, however, it is a programming language because it has a grammar, syntax, and programmatic purpose and intent. The joke recalls Voltaire's remark that the Holy Roman Empire was "neither holy, nor Roman, nor an empire."SQL contrasts with the more powerful Fourth-generation programming languagedatabase-oriented fourth-generation programming languages such as Focus softwareFocus or SAS_SystemSAS, however, in its relative functional simplicity and simpler command set. This greatly reduces the degree of difficulty involved in maintaining SQL source code, but it also makes programming such questions as 'Who had the top ten scores?' more difficult, leading to the development of procedural extensions, discussed #Originsabove. However, it also makes it possible for SQL source code to be produced (and optimized) by software, leading to the development of a number of natural language database query languages, as well as 'drag and drop' database programming packages with 'object oriented' interfaces. Often these allow the resultant SQL source code to be examined, for educational purposes, further enhancement, or to be used in a different environment.

SQL keywords - SQL keywords fall into several groups.

Connection - The first commands used are to connect to a database. A default database can also be selected.

!CONNECT USE is used to select a default database. Example: USE my_db CONNECT DATABASE

Data retrieval - The most frequently used operation in transactional databases is the data retrieval operation.

Select (SQL)SELECT is used to retrieve zero or more rows from one or more tables in a database. In most applications, !SELECTDML command. In specifying a !SELECT* Commonly available keywords related to SELECT include:

** FROM is used to indicate which tables the data is to be taken from, as well as how the tables Join (SQL)join to each other.

** WHERE is used to identify which rows to be retrieved, or applied to GROUP BY.

** GROUP BY is used to combine rows with related values into elements of a smaller set of rows.

** !HAVING** ORDER BY is used to identify which columns are used to sort the resulting data. Example: SELECT * FROM my_table WHERE id > 10;

Data manipulation - First there are the standard Data Manipulation Language (DML) elements. Data Manipulation LanguageDML is the subset of the language used to add, update and delete data.

Insert (SQL)INSERT is used to add zero or more rows (formally tuples) to an existing table.

Update (SQL)UPDATE is used to modify the values of a set of existing table rows.

Merge (SQL)MERGE is used to combine the data of multiple tables. It is something of a combination of the !INSERTUPDATEDelete (SQL)DELETE deletes all data from a table (non-standard, but common SQL command).

Truncate (SQL)TRUNCATE removes zero or more existing rows from a table. Example: INSERT INTO my_table (field1, field2, field3) VALUES ('test', 'N', NULL); UPDATE my_table SET field1 = 'updated value' WHERE field2 = 'N'; DELETE FROM my_table WHERE field2 = 'N';

Data transaction - Transaction, if available, can be used to wrap around the DML operations.

Begin work (SQL)BEGIN WORK (or Start transaction (SQL)START TRANSACTION, depending on SQL dialect) can be used to mark the start of a database transaction, which either completes completely or not at all.

Commit (SQL)COMMIT causes all data changes in a transaction to be made permanent.

Rollback (SQL)ROLLBACK causes all data changes since the last !COMMITROLLBACKCOMMIT&l t;/code>? and !ROLLBACKBEGIN WORK or similar statement, the semantics of SQL are implementation-dependent. Example: UPDATE inventory SET quantity = quantity - 3 WHERE item = 'pants';

Data definition - The second group of keywords is the Data Definition Language (DDL). DDL allows the user to define new tables and associated elements. Most commercial SQL databases have proprietary extensions in their DDL, which allow control over nonstandard features of the database system.The most basic items of DDL are the !CREATEDROP commands.

Create (SQL)CREATE causes an object (a table, for example) to be created within the database.

Drop (SQL)DROP causes an existing object within the database to be deleted, usually irretrievably.Some database systems also have an Alter (SQL)ALTER command, which permits the user to modify an existing object in various ways -- for example, adding a column to an existing table. Example: CREATE TABLE my_table ( my_field1 INT UNSIGNED, my_field2 VARCHAR(50), my_field3 DATE NOT NULL, PRIMARY KEY (my_field1, my_field2) )

Data control - The third group of SQL keywords is the Data Control Language (DCL). Data Control LanguageDCL handles the authorisation aspects of data and permits the user to control who has access to see or manipulate data within the database.Its two main keywords are:

GRANT — authorises a user to perform an operation or a set of operations e.g. ''grant all privileges to user identified by passwd?''

!REVOKE
Other - ANSI-standard SQL supports -- as a single line comment identifier (some extensions also support curly brackets for multi-line comments). Example: SELECT * FROM inventory -- Retrieve everything from inventory table

Database systems using SQL -

List of relational database management systems

List of object-relational database management systems

Criticisms of SQL - Technically, SQL is a declarative computer language for use with "relational databases". Theorists note that many of the original SQL features were inspired by, but in violation of, tuple calculus. Recent extensions to SQL achieved relational completeness, but have worsened the violations, as documented in The Third Manifesto.In addition, there are also some criticisms about the practical use of SQL:

The language syntax is rather complex (sometimes called "COBOL-like").

It does not provide a standard way to split large commands into multiple smaller ones that reference each other by name (however some implementations allow for set-based functions to grant this functionality). This tends to result in "run-on SQL sentences".

Implementations are inconsistent and, at times, incompatible between vendors.

It is at times too difficult a syntax for Database administratorDBAs (DataBase Administrators) to extend.

Over-reliance on "Null (SQL)NULLs", which some consider a flawed or over-used concept.

For larger statements, it is often difficult to factor repeated patterns and expressions into one or fewer places to avoid repetition and avoid having to make the same change to different places in a given statement.

Unexplained difference between value-to-column assignments in UPDATE and INSERT syntax.

Alternatives to SQL - A distinction should be made between alternatives to relational and alternatives to SQL. The list below are proposed alternatives to SQL, but are still (allegedly) relational. See navigational database for alternatives to relational.

IBM BS12

Tutorial D

c2.com - TQL Proposal (Not to be confused with Luca Cardelli's TQL)

hibernate.org - Hibernate Query Language (HQL) - A Java-based tool that uses modified SQL

Quel introduced in 1974 by the U.C. Berkeley Ingres project.

External links -

mcjones.org - ''The 1995 SQL Reunion: People, Projects, and Politics'' (early history of SQL)

Tutorials -

bitesizeinc.net - BiteSize Inc.'s ''Learn SQL'' tutorial

sqlzoo.net - ''A Gentle Introduction to SQL'' at SQLzoo

sql-tutorial.net - SQL Tutorial

aam.ugpl.de - SQL Help and Tutorial

sql-ex.ru - SQL Exercises. SQL DML Help and Tutorial

References - # notechamber Donald D. Chamberlin and Raymond F. Boyce, 1974. "portal.acm.org - SEQUEL: A structured English query language", International Conference on Management of Data, Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control, Ann Arbor, Michigan, pp. 249-264# c2.com - Discussion on alleged SQL flaws (C2 wiki)Category:SQL Category:Declarative programming languagesCategory:Programming !languagesca:SQLcs:SQLda:Struct ured? Query !Languagede:SQLes:SQLeo:SQLfr:S tructured? Query !Languageid:SQLia:SQLis:SQLit:S QLhe:SQLku:SQLlt:SQLhu:SQL? programozási nyelvnl:SQLja:SQLno:Structured Query !Languagepl:SQLpt:SQLru:SQLsk:S QLfi:SQLsv:SQLth:SQLtr:SQLvi:S QLuk:Мова? програмування SQLzh:SQL

Changes Training Centre
Changes Training Centre (CTC) is a private post-secondary educational institution fully registered and accredited by the Private Career Training Institutions Association of British Columbia (PCTIA). Featuring Diploma programs in General Insurance, Accounting and Payroll, Management, Administration, and more. Certifications include PMCP, Real Estate, and CFP. Contact us at 604-852-1233, (toll free 1-877-852-1233) email info@changestraining.com or go to www.changestraining.com for more information.
http://www.changestraining.com/

Jaribu Limited
Ms Access Development, London Database Development and Web Design. Jaribu Business Solutions is a London UK based consulting firm specialising in customised software development, Databases and Systems. In the past five years we have delivered successful solutions for various industries such as Investment Banking, Local Authorities and Television Production.
http://www.jaribu.co.uk/

Centerlogic
Centerlogic can help. We partner with businesses in the Northwest to find new ways to manage technology and access information. Through an interactive process, Centerlogic diagnoses business needs and develops enduring technology solutions that will give our customers a competitive advantage.
http://www.centerlogic.com/

Integrio Systems - custom software development & offshore outsourcing
Custom software development & programming in Vancouver, Canada. Web site design and hosting. Offshore outsourcing facilities in Ukraine.
http://www.integrio.net/

RMSource, Inc.
RMSource, Inc., is an information technology consulting firm that provides a complete range of strategic outsourcing services. We invite you to browse our web site, and contact us at 877.319.3051.
http://www.rmsource.com/

Datakonsult Mats Hindhede
Home page of Datakonsult Mats Hindhede
http://www.hindhede.se/

Manuales Gratis - Top Tutoriales
Manuales gratis y Tutoriales gratis preparados para su descarga. SQL Server, Office, Windows XP Server los manuales que necesites completamente GRATIS
http://www.toptutoriales.com/

IT- und CAD-Lösungen
Eine EDV-Dienstleistung für jede Firma. Lassen Sie Ihre Mitarbeiter weiterbilden. Informieren Sie sich über ein Bildungsscheck und nutzen Sie diese Möglichkeit, damit Ihre Mitarbeiter leistungsfähig bleiben. Haben Sie Engpässe oder möchten Sie Ihr Produkt besser präsentieren...?
http://www.megaedv.de/

Stedica Webhost4life
Internet business solutions, web development, sites, hosting, multimedia and DVD.
http://webhost4life.com.mx/

Datablue Professional IT Services
DataBlue is the Value Add Distributor of IBM Middleware Technologies in Greece. The goal of the company is to promote the IBM State of the Art technologies in the Greek market either directly or through a network of selected resellers / IBM Business Partners . Although all IBM technologies are distributed, emphasis is placed on the WEB technologies centered around Websphere Application Server and Rational Tools, the DB2 technologies and the related BI applications, as well as the Tivoli family of products. DataBlue also promotes non-IBM products, like Track It! which complement the IBM families.
http://www.datablue.gr/

Control a scanner or camera from .NET, VB, Delphi, web.
Add ability to work with scanner or camera from your application. You can fully control an image acquisition process, use an automatic document feeder, clean up images using noise removal, auto border crop, blank page detection, save acquired images to disk or SQL server, upload images onto Web or FTP server.
http://www.vintasoft.com/

-= servers.hu - professzionális internet megoldások
A servers.hu oldalain található: Magyar tárhely szolgáltatás, webdesign, perl cgi scriptek futtatása, web, internet, host, hosting service, A legjobb szolgáltatások a lehető legjobb áron! Tárhely szolgáltatások /web, php, email,mysql,.../ Domain szolgáltatások /regisztráció, fenntartás, stb./ E-mail szolgáltatások /levelezőlista, virtuális email, hírlevél/ Server szolgáltatások /felkészítés, elhelyezés, Linux CD-k/ Minden szolgáltatásunk megrendelhető kedvező, havi fizetéssel, illetve éves fizetéssel is. Rendeljen akár azonnal, online rendszerünk segítségével! Úgy érzi, túl magasak a havi díjak? Szeretné, ha válogathatna a lehetőségek közül, vagy komplett megoldást keres? Tekintse meg ajánlatunkat!
http://www.servers.hu/

100% GRATUIT ! HEBERGEMENT-PHP,Mysql ,Hebergement Frontpage
HEBERGEMENT -PHP,Mysql , Extensions Frontpage et la gestion avec PLESK en ligne. et demandez nous vos 10 Mo d'espace web offerts sans pub!
http://www.azur-creaweb.com/

WSUN Technologies - Enterprise Standard Web Solutions
domain registration, web design, software development, network architecture, reverse engineering, reverse engineer, dial-up, dial up, dsl, internet access, aps, software design, mainframe circuit boards, mission, technical, highest standard, wifi network, hotzone, hotspot, radius, port saint lucie, florida, roanoke virginia, broadband, ethernet adapter, laptop, desktop, air waves, lan, modem, 56k, integrated, wifi coverage, wifi map, free software downloads, network uptime, webhosting, web hosting, hosting, design, website management, outsource, hosting package, linux, redhat, sql, php, free email, free church web sites, free non profit hosting
http://www.wsuntech.com

Baes Informatie Technologie
Baes Informatie Technologie, uw partner in automatisering! Wij leveren maatwerksoftware tegen standaard prijzen.Baes IT is een jong IT bedrijf dat nog oog heeft voor uw toekomst. Onze service stopt niet bij de verkoop. Bij ons krijgt u de beste computers tegen zeer concurerende prijzen.
http://www.baes.nl/

Microsoft Office Reporting Tools
WDReportGen / XLReportGen are report generators for Microsoft Excel/Word that use Microsoft Excel/Word as reporting tools and output reports in Microsoft Word document, Microsoft Excel spreadsheet, HTML, XML, RTF, Lotus 1-2-3 or other format.
http://www.ljzsoft.com/

Simply4you.it: Informatica e Programmazione
Simply4you.it - Informatica & Programmazione : visual basic, vb, active server pages , ASP, java, javscript, c, c++, SQL, database, oracle, Perl, CGI, Delphi, PHP, Free source code
http://www.simply4you.it

CoCoLab
software development for programming languages, compiler construction, program analysis and program transformation
http://www.cocolab.de/

Web site management made easy
WidgetSprocket Content Management Platform gives you the control to easily add to and update your own web site, when ever you need to. You don’t need to know how to code, or spend hours studying manuals. With a small learning curve and a very basic understanding of HTML you will be managing your site like a seasoned web designer in no time at all.
http://www.widgetsprocket.com/

SOftStuf Software, Inc
Custom software developed using microsoft technologies. Websites created using ASP.Net and Atlas. Winforms applications developed using C#.
http://www.softstufsoftware.com/

MySQL
MySQL's official homepage by TCX DataKonsult AB.
http://www.mysql.com/

Microsoft Corporation
Designs, develops, manufactures, licenses, sells and supports a wide range of software products. (Nasdaq: MSFT).
http://www.microsoft.com/

SQLCourse
Interactive/On-line SQL Tutorial with SQL Interpreter & live practice database.
http://www.sqlcourse.com/