Uy_SQL

  Extensible Markup Language  (XML) - It l ets you define and store data in a shareable manner . XML supports information exchange between computer systems such as websites, databases, and third-party applications. JSON -  is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays. It is a commonly used data format with diverse uses in electronic data interchange, including that of web applications with servers. AJAX -  It is a set of web development techniques that uses various web technologies on the client-side to create asynchronous web applications. With Ajax, web applications can send and retrieve data from a server asynchronously without interfering with the display and behavior of the existing page.

 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.