Monday, 16 January 2017

What is The SQL Language And Its Sub Languages

SQL is The Structure Query Language

  • SQL is used to Operate all relational data model Produts
  • In 19770 E.F.Codd Introduced Relational Data Model
  • And Also Introduced a new Language In Data Base side 
  • The Language is DSL/ALPHA Language. It a Non-Procedure Language
  • In IBM System/R Team developed simplefication of the DSL ALPH Laguage colled SUQRE
  • Again IBM Modifies SQURE Language and introduced a new Language SEQUEL Language
  • Again Modified the SEQUEL and Introduced One more new language is SQL
  • ANSI (American Standard Institute Provide ) provide the SQL is the Standard Language for all Relational Data Base
  • So SQL language also called as ANSI SQL
  • Based Ansi SQL standard Oracle Created Oracle SQL, Microsoft Created Sql Sever, IBM Createf DB2 etc.

Oracle SQL Language having the Following Sub Languages

  1. Data Query Language(DQL)
  2. Data Definition Language(DDL)
  3. Data Manipulation Language(DML)
  4. Data Control Language(DCL)
  5. Transaction Control Language(TCL)
  6. System Control Language(SYSL)
  7. Session Control Language(SCL)

Top Questions on Above Class:

  1. Which Sub Languages are using in DBA's?
  2. Why Sub Languages in SQL
  3. What is the different Between DDL and DML?
  4. What is DDL?
  5. What is DML?
  6. What is DCL?
  7. What is TCL?
  8. What is SCL?
  9. What is DQL?

No comments:

Post a Comment