Home DBMS Introduction to SQL

at
Introduction to SQL



Pronounced as SEQUEL: Structured English Query Language
1. Pure non-procedural query language
2. Designed and developed by IBM, Implemented by Oracle
3. 1978 System/R IBM- 1st Relational DBMS
4. 1979 Oracle and Ingres
5. 1982 SQL/DS and DB2 IBM
6. Accepted by both ANSI + ISO as Standard Query Language for any RDBMS
7. SQL86 (SQL1): first by ANSI and ratified by ISO (SQL-87), minor revision on 89 (SQL-89)
8. SQL92 (SQL2): major revision
9. SQL99 (SQL3): add recursive query, trigger, some OO features, and non-scholar type
10. SQL2003: XML, Window functions, and sequences (Not free)
11. Supports all the three sublanguages of DBMS: DDL, DML, DCL
12. Supports Aggregate functions, String Manipulation functions, Set theory operations, Date Manipulation functions, rich set of operators ( IN, BETWEEN, LIKE, IS NULL, EXISTS)


13. Supports REPORT writing features and Forms for designing GUI based applications
Share To:
Mukesh Rajput

Mukesh Rajput

I am a Computer Engineer, a small amount of the programming tips as it’s my hobby, I love to travel and meet people so little about travel, a fashion lover and love to eat food, I am investing a good time to keep the body fit so little about fitness also..

DBMS

Post A Comment:

0 comments:

Subscribe to: Post Comments (Atom)