Uy_SQL

 WHAT IS SQL?     It is a domain-specific language used to manage data, especially in a relational database management system. It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.     Originally based upon  relational algebra  and  tuple relational calculus , SQL consists of many types of statements,  which may be informally classed as  sublanguages , commonly:  Data query Language  (DQL),  Data Definition Language  (DDL),  Data Control Language  (DCL), and  Data Manipulation Language  (DML).        SQL was one of the first commercial languages to use  Edgar F. Codd 's  relational model . The model was described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks". [8]  Despite not entirely adhering to  the relational model as described by Codd , SQL became t...

  EMBEDDED DATA MANIPULATION LANGUAGE       It consists of SQL statements used to retrieve, insert, update and delete records from database tables. DML statements are the only statements that can be rolled back or recovered. Deletes specified rows from a table. Also has a special format (DELETE WHERE CURRENT OF) for embedded SQL.       A popular data manipulation language is Structured Query Language or SQL, used to retrieve and manipulate data in a relational database. With SQL, you can perform operations on the database and also use it to create a database. SQL uses specific commands like Create, Drop, Insert, etc., to carry out the required tasks.

 INTERACTIVE DATA MANIPULATION LANGUAGE         It is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. Most SQL database implementations extend their SQL capabilities by providing  imperative , i.e. procedural languages. Examples of these are  Oracle 's  PL/SQL  and  IBM Db2 's  SQL_PL . Data manipulation languages tend to have many different flavors and capabilities between database vendors. There have been a number of standards established for SQL by  ANSI , [2]  but vendors still provide their own extensions to the standard while not implementing the entire standard. Data manipulation languages are divided into two types,  procedural programming  and  declarative programming . Data manipulation langua...

 DATA DEFINITION LANGUAGE         It is a data definition or data description language is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas. Many data description languages use a declarative syntax to define columns and data types. Structured Query Language (SQL), however, uses a collection of imperative verbs whose effect is to modify the schema of the database by adding, changing, or deleting definitions of tables or other elements. These statements can be freely mixed with other SQL statements, making the DDL not a separate language.