SQL Database Programming Language Help For Students
Introduction to SQL
SQL(Structured Query Language) is a database computer programming language designed for the retrieval and management of data in relational database. IBM first developed of SQL in 1970s. Also it is an ANSI/ISO standard. It has become a standard universal language used mostly in relational database management system(RDBMS). In a simple manner, SQL is a non-procedural, English-like language that processes data in groups of records rather than one record at a time. Few functions of SQL are:
- store data
- modify data
- retrieve data
- modify data
- delete data
- create tables and other database objects
- delete data
Example: How to SQL INSERT INTO Statement is used to add new rows of data to a table in the database
{` INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)] VALUES (value1, value2, value3,...valueN); `}OR
{` INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN); `}