Thursday, January 7, 2016

What is SQL?


Structured Query Language.
  •  T-SQL language 
  • Getting information from the database using the SELECT statement.
  • Fetching Data
  • Transact-SQL (T-SQL) language 

SQL is a standard language for accessing databases.
 SELECT statement
  • SELECT
  • FROM
  • WHERE
  • ORDER BY

SQL Statements: DDL, DML and DCL:

  1. Data Definition Language (DDL)
  2. Data Manipulation Language (DML) 
  3. Data Control Language (DCL) 
  4. Transaction Control (TCL) 

No comments:

Post a Comment