
SQL Tutorial - FREE
by Android mob, Version: 2.4 , 91 KB Official Site
Package name: sqltutorial.tutorialsok.com , Last Update: 2013-03-20 12:41:18
38 ratings (3.211 average)
10,000-50,000 downloads
What's new in this version (2.4):
Description
This SQL tutorial, will explain you, step by step, in 50 lessons, all the SQL commands needed to control access to any database:
- Creation of a database (CREATE DATABASE)
- Create a table (CREATE TABLE)
- Creation of a view (CREATE VIEW)
- Creating an index on a table (CREATE INDEX)
- Creation of stored procedures (CREATE PROCEDURE)
- Creation of triggers (CREATE TRIGGER)
- Create the data stored in a table (SELECT)
- Insert 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)
- Retract the transaction of a SQL statement (ROLLBACK)