Programming Languages Directory

Site Topics

C Programming Language
Assembling Computers
CIS
Computer Science Careers
Women and Computer Science
ADA Programming Language
ALGOL Programming Language
APL Programming Language
AWK Programming Language
Basic Programming Language
C++ Programming Language
COBOL Programming Language
Delphi Programming Language
Eiffel Programming Language
Euphoria Programming Language
Forth Programming Language
FORTRAN Programming Language
HTML Programming Language
ICON Programming Language
Java Programming Language
Javascript Programming Language
LISP Programming Language

 

The Database Programming Language

Free resources updated everyday:

XXXLINKSXX

SQL originated in one of IBM’s research laboratories, as did relational database theory. In the early 1970s, as IBM researchers performed early development on relational DBMS system, they created a data sublanguage to operate on these systems. 

"A Relational Model of Data for Large Shared Data Banks," by Dr. E. F. Codd, was published in June 1970 in the Association of Computer Machinery (ACM) journal, Communications of the ACM. Codd's model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language ("SEQUEL") was developed by IBM Corporation, Inc., to use Codd's model. SEQUEL later became SQL (still pronounced "sequel").

In 1979, Relational Software, Inc. (now Oracle Corporation) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language.

Significant Language Features

  • Retrieveing Data Filtering Data
  • Creating Calculated Fields
  • Data Manipulation Functions
  • Summarizing Data
  • Grouping Data
  • Subqueries
  • Joining Tables
  • Combining Queries
  • Inserting, Updating and Deleting Data
  • Creating and Manipulating Tables

Areas of Application

  • Configuring ODBC Data Sources
  • Using Allaire ColdFUsion
  • Using DB2
  • Using Informix Dynamic Server 7.x
  • Using Microsoft Access
  • Using Microsoft ASP
  • Using Microsoft Query
  • Using Microsoft SQL Server
  • Using Microsoft Visual Basic
  • Using Microsoft Visual C++
  • Using Oracle
  • Using Sybase

Sample Program

Source Code: (SELECT)
1. Create a standard SELECT statement
SELECT * FROM employees
WHERE state = ‘CA’

2. Run that statment to test it

3. Add the words: CREATE VIEW viewname AS to the top of the select statement and run it
CREATE VIEW cal_employees AS
SELECT * FROM employees
WHERE state = ‘CA’

4. To use the view
INSERT cal_employees
VALUES(100, ‘fred’, ‘smith’) etc.
DELETE cal_employees
WHERE city = ‘Oakland’

This program create a standard SELECT statement and adding more clauses with the statement.

 

 

 

 

 

 


 



 

Site Topics

LOGO Programming Language
Mathematica Programming Language
MATLAB Programming Language
Miranda Programming Language
Modula-2 Programming Language
Oberon Programming Language
Pascal Programming Language
PERL Programming Language
PL/I Programming Language
Prolog Programming Language
Python Programming Language
REXX Programming Language
SAS Programming Language
Scheme Programming Language
SED Programming Language
Simula Programming Language
Smalltalk Programming Language
SNOBOL Programming Language
Database Programming Language
Visual Basic Programming Language
Visual C++ Programming Language
XML Programming Language

 

 

 

 

C Programming Language | Assembling Computers | CIS | Computer Science Careers | Women and Computer Science | ADA Programming Language | ALGOL Programming Language | AWK Programming Language | Basic Programming Language | C++ Programming Language | COBOL Programming Language | Delphi Programming Language | Eiffel Programming Language | Euphoria Programming Language | Forth Programming Language | FORTRAN Programming Language | HTML Programming Language | ICON Programming Language | Java Programming Language | Javascript Programming Language | LISP Programming Language | LOGO Programming Language | Mathematica Programming Language | MATLAB Programming Language | Miranda Programming Language | Modula-2 Programming Language | Oberon Programming Language | Pascal Programming Language | PERL Programming Language | PL/I Programming Language | Prolog Programming Language | Python Programming Language | REXX Programming Language | SAS Programming Language | Scheme Programming Language | SED Programming Language | Simula Programming Language | Smalltalk Programming Language | SNOBOL Programming Language | Database Programming Language | Visual Basic Programming Language | Visual C++ Programming Language | XML Programming Language | Home | Site Map