Watch Our YouTube Channel
It is currently Tue Jan 23, 2018 1:55 am
 

All times are UTC



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: SQL commands
PostPosted: Tue Sep 08, 2015 7:43 am 
Offline

Joined: Thu Sep 12, 2013 8:31 am
Posts: 701
SQL commands are instructions, coded into SQL statements, which are used to communicate with the database to perform specific tasks, work, functions and queries with data.

SQL commands can be used not only for searching the database but also to perform various functions like, create tables, add data to tables, modify data, drop the table, set permissions for users.

SQL commands are grouped into four major categories depending on their functionality:

Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.

Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data.
These Data Manipulation Language commands are: SELECT, INSERT, UPDATE, and DELETE.

Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.

Data Control Language (DCL) - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.

other commands are
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL Wildcard
SQL LIKE
SQL ORDER BY
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL AS
SQL SELECT UNIQUE
SQL INSERT INTO
SQL INSERT INTO SELECT
SQL DELETE FROM

Learn basics of sql here...

_________________
Jeba Christy.C
Get attractive facebook cover images | Learn Basics of Software Testing | Read Latest News


Top
 Profile  
Reply with quote  
 Post subject: Re: SQL commands
PostPosted: Tue Nov 24, 2015 12:52 pm 
Offline

Joined: Tue Nov 24, 2015 12:46 pm
Posts: 1
SQL commands
1.SQL Commands is a website demonstrating how to use the most frequently used SQL clauses. SQL Commands is not a comprehensive SQL Tutorial, but a simple guide to SQL clauses available online for free.
2.Our SQL Commands reference will show you how to use the SELECT, DELETE, UPDATE, and WHERE SQL commands. Each of the SQL commands articles is illustrated with practical examples, designed to help you learn the SQL commands syntax. You can also do the SQL practice exercises at the end of each tutorial.
3.SQL commands are grouped into four major categories depending on their functionality:
Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data.
These Data Manipulation Language commands are: SELECT, INSERT, UPDATE, and DELETE.
Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.
Data Control Language (DCL) - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron