Purchase Solution

SQL Characteristics, History, and Example

Not what you're looking for?

Ask Custom Question

SQL Information
--------------------------------------------------------------------------------
I need about page about basic SQL, I am looking for your opinion.

a. Characteristics
b. Why was it created?
c. Is there anything unique about it?
d. History
e. small sample example of code
f. What makes it different than other languages?

Purchase this Solution
Solution Summary

In this solution, you will learn all about SQL. Specifically, you will learn about the following with many references.
a. Characteristics
b. Why was it created?
c. Is there anything unique about it?
d. History
e. small sample example of code
f. What makes it different than other languages?

Solution Preview

SQL (Structured Query Language) is a database language. It is widely used with a DataBase Management System (DBMS) to query, create and modify databases. Originally it was meant to work with Relational Databases, however now it also supports other databases including Object-Relational Database Management Systems (ORDBMS).

Why created?
It was created to test a database system based on Edgar Codd's paper on Relational databases "A Relational Model of Data for Large Shared Data Banks" [1]. Its creators Donald D. Chamberlin and Raymond F. Boyce were working at IBM on a relational database system called "System R".

Characterisitics and uniqueness:
Every programming language is unique, however SQL is different from other "general" programming languages. The basic SQL does not have the concept of general purpose programming as done in C or Java. Extension to ANSI SQL like PL/SQL provides many improvements that allow general programming with SQL. Some aspects of SQL is closer to any declarative programming language like Prolog, Haskell, Miranda, etc. In any case it ...

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Networking Questions

This quiz consists of some basic networking questions.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • SQL and Differences in Implementation

    Characteristics and uniqueness: Every programming language is unique, however SQL is different from other "general" programming languages. The basic SQL does not have the concept of general purpose programming as done in C or Java.

  • Database Systems SQL Statement Examples

    Strategic Planning for Database Systems SQL Statements Write 2 SQL statements a piece (SELECT INSERT, UPDATE, and DELETE) based upon database tables of your choice (i.e. customers, orders, vendors etc).

  • Migration from Access

    For example, Oracle and others include Java in the database, while PostgreSQL allows functions to be written in a wide variety of languages, including Perl, Tcl, and C.

  • Develop database tables using a relational database system

    For example, Oracle and others include Java in the database, while PostgreSQL allows functions to be written in a wide variety of languages, including Perl, Tcl, and C.

  • security and setup

    The database is divided into the columns and rows. The columns are also called as attribute or fields, which give the general characteristics of the entity whose database you are creating.

  • SQL QUERIES

    Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection (use salaries to restrict the data). 2.

  • Writing SQL Queries Using a Database and Tables

    Using the database and tables (see attachment), write SQL queries using BETWEEN, LIKE, and UNION: - Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use Emp_salary to restrict the data

  • Write SQL queries using BETWEEN, LIKE and UNION

    247061 Write SQL queries using BETWEEN, LIKE and UNION Using the database and tables from the attached file, write SQL queries using BETWEEN, LIKE and UNION: Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict

  • SQL Statements To Run In SQl Server

    94940 SQL Statements To Run In SQl Server Write SQL queries using Between, Like and Union: ? Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection.

View More Related Solutions