What is SQL and why it is used for please help urgent

Asked By georgia mendez 40 points N/A Posted on - 03/07/2012

Hi there,

I know a very little on SQL severs. Could you please clarify me a little bit on that ?

Thanks.

• Status: Open
• Question Views: 857
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Sharath Reddy

Go To Solution

Answered By Hoting Gracia 5 points N/A #90116

What is SQL and why it is used for please help urgent

Hi , Georgia hope the following steps will guide you in fixing of this issue.:

 

–>SQL is an acronym for Structured Query Language. It can be used in performing a communication with database. 

 

–>As per ANSI , SQL is standard language for relational database management systems which can be also called as RDBMS and in SQL the statements are used to perform certain tasks such as updating data on database, retrieving data from database. 

 

–>The common RDBMS that uses SQL are followed by Oracle, Sybase, Microsoft SQL Server, etc. Even most of the Database Systems uses SQL ,but anyhow the standard SQL commands "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to perform almost everything that one can do anything with the database. 

 

Thank you..:-)

About Hoting Gracia

Questions
0

Answers
154

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 03/07/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #90117

What is SQL and why it is used for please help urgent

The letters SQL stands for Structured Query Language. It is a special purpose programming language created for handling data in RDBMS or Relational Database Management System. It is originally based on tuple relational calculus and relational algebra and is composed of a data manipulation language and a data definition language.

It is the standard language used for manipulating and accessing data in databases. It is one of the first languages circulated commercially and became the standard of ANSI or the American National Standards Institute in 1986 and also of ISO or the International Organization for Standards in 1987. The program during those times is not entirely portable among other database systems that might lead to vendor lock-in.

SQL was first created by Raymond F. Boyce and Donald D. Chamberlin at IBM in early 1970s. They first called it SEQUEL or Structured English Query Language. It was first intended to control and get data stored in System R, which is IBM’s first quasi-relational database management system. System R was developed by a group in the 1970s at IBM San Jose Research Laboratory.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 08/30/2013
• Question Category: MS SQL Server