SQL Basic Tutorial

SQL Basic Tutorial

FREE

(4 stars)

(101)


Download for Android

10,000 - 50,000 downloads

Add this app to your lists
SQL is a standard programming language for accessing databases.

The SQL language is used to access and manipulate data in any database on the market, such as databases to MySQL, Oracle, DB2, SQL Server, Access.

SQL is a structured language and an ANSI standard for accessing and manipulating data from any database.

SQL is composed of SQL statements, each with a different value, including:

Creating a database (CREATE DATABASE)
Creation of a table (CREATE TABLE)
Creating a view (CREATE VIEW)
Creating an index on a table (CREATE INDEX)
Creating stored procedures (CREATE PROCEDURE)
Creating triggers (CREATE TRIGGER)
Consult the data stored in a table (SELECT)
Inserting data into a table (INSERT)
Modify existing data in a table (UPDATE)
Delete data stored in a table (DELETE)
Give permission to access data from a table (GRANT)
Delete permissions to access data in a table (REVOKE)
End transaction of a SQL statement (COMMIT)
Back transaction of an SQL statement (ROLLBACK)

Tags: sql tutorial, sql statement, sql et, ibasic tutorial, tutorial, tutorialjavascriptavançadosql, banco de dados sql server tutorial, ibasic tuturials, sql tutorial with screenshots and codes, inserire dati gps da a db mysql.

Comments and ratings for SQL Basic Tutorial
  • (64 stars)

    by sarahyasmin on 10/09/2012

    Thanks for all the information, it was very helpful i really like that you are providing information on PHP and MYSQL with basic JAVASCRIPT,being enrolled in http://www.wiziq.com/course/5871-php-mysql-with-basic-javascript-integrated-course