Tutorial sql w3

Solo disponible en BuenasTareas
  • Páginas : 21 (5058 palabras )
  • Descarga(s) : 0
  • Publicado : 20 de febrero de 2011
Leer documento completo
Vista previa del texto
SQL Tutorial

| SQL es un lenguaje estándar para acceder a bases de datos.
Nuestra SQL tutorial te enseña cómo usar SQL para tener acceso y manipular datos en:
MySQL, SQL Server, Access, Oracle, Sybase, DB2, y otros sistemas de base de datos. |

SQL Syntax SELECT Company, Country FROM Customers WHERE Country 'USA' |
SQL Result Company | Country |
Island Trading  | UK  |
Galeríadel gastrónomo  | Spain  |
Laughing Bacchus Wine Cellars  | Canada  |
Paris spécialités  | France  |
Simons bistro  | Denmark  |
Wolski Zajazd  | Poland  |

Try it yourself » |

Start learning SQL now!
-------------------------------------------------
SQL Demo

Learn by examples! With our editor, you can edit the SQL, and click on a button to view the result.
Try-It-Yourself!-------------------------------------------------
SQL Quiz Test

Test your SQL skills at W3Schools!
Start SQL Quiz!
-------------------------------------------------
SQL Quick Reference

An SQL Quick Reference. Print it and put it in your pocket.
SQL Quick Reference
-------------------------------------------------
SQL Data Types
Data types and ranges for Microsoft Access, MySQL and SQLServer.
SQL Data Types
-------------------------------------------------
W3Schools Exam
| W3Schools' Online CertificationThe perfect solution for professionals who need to balance work, family, and career building.More than 6000 certificates already issued!Get Your Certificate » |
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents yourknowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).

Free Online Website Builder - No Downloading Needed
Create a free Flash website with our simple, online web design editing platform. Stunningtemplates and user-friendly tools make website building easy and fun.
Start Creating your free website now!

Altova® XMLSpy® - The industry's leading XML editor!

Whether you're new to XML or already an advanced user, the user-friendly views and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to meet your XML and Web development needs from start to finish. New features inVersion 2010!
* XML editor * Graphical XML Schema / DTD editors * XSLT 1.0/2.0 editor, debugger, profiler * XQuery editor, debugger, profiler * XBRL validator, taxonomy editor, taxonomy wizard * Support for Office Open XML (OOXML) * Graphical WSDL 1.1/2.0 editor & SOAP debugger * JSON editing & conversion * Java, C#, C++ code generation * 32-bit and 64-bit versions * Andmuch more!Download a free trial today! |

Introduction to SQL
SQL es un lenguaje estándar para acceder y manipular bases de datos.

What is SQL?
* SQL stands for Structured Query Language
* SQL lets you access and manipulate databases
* SQL is an ANSI (American National Standards Institute) standard

What Can SQL do?
* SQL can execute queries against a database
* SQLcan retrieve data from a database
* SQL can insert records in a database
* SQL can update records in a database
* SQL can delete records from a database
* SQL can create new databases
* SQL can create new tables in a database
* SQL can create stored procedures in a database
* SQL can create views in a database
* SQL can set permissions on tables, procedures, and viewsSQL is a Standard - BUT....
Although SQL is an ANSI (American National Standards Institute) standard, there are many different versions of the SQL language.

However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

Note: Most of the SQL database programs also have their own...
tracking img