Posts

WHAT IS XML, JSON, AND AJAX?

 XML -Extensible Markup Language is a simple rxt-based format for representing structured information  -XML supports information exchange between computer systems such as websites, database, and third party applications. JSON -is perfect for sharing temporary data for example temporary data can be user generated data. Such as a submitted form on a website. JSON can also be used as a data format for any programming language to provide a high level of interoperability  AJAX -stands for Asynchronous JavaScript and XML, in a nutshell, it is the use of the XMLHttpRequest object to communicate with servers. It can send and receive information in various formats, including JSON, XML, HTML, and text files. 

What is SQL?

 SQL or Standard Query Language is an Programming language for storing and processing information in a relational database. A relational database stores information in tabular form with rows and columns representing different data attributes and the various relationships between the data values. 

Information Management - SQL

 A. Data Definition Language - DDL or Data Definition Language is  subset of SQL. It is  language for describing data and it's relationship in a database. You can generate DDL in a script for database objects. B. Interactive Data Manipulation Language - Represents a collection of programming languages explicitly used to make  changes to the database, such as CRUD operations to create, read, update, and delete data. Using INSERT, SELECT, UDTAE, and DELETE commands. C. Embedded Data Manipulation Language - Is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL.