Information Management (LAB)

 WHAT IS JSON?      JSON stands for JavaScript Object Notation. It is a lightweight data format used for storing and transporting data, often utilized when data is sent from a server to a web page. JSON is text-only and "self-describing," making it easy to understand. The format is syntactically identical to the code for creating JavaScript objects, which allows data to be easily converted into native JavaScript objects. JSON's human-readable text format stores and transmits data objects consisting of attribute-value pairs and arrays or other serializable values.

         WHAT IS XML?      XML stands for extensible Markup Language. It is a markup language much like HTML but is designed to store and transport data. XML is self-descriptive and uses custom tags to define the structure and meaning of the data within. It is a text-based format that is both human-readable and machine-readable. XML is widely used for the representation of arbitrary data structures, such as those used in web services. The flexibility of XML comes from its extensibility, allowing it to work with new data without breaking existing applications.

 WHAT IS SQL?      SQL, which stands for Structured Query Language, is a standardized programming language used for managing and manipulating relational databases. It allows users to execute queries, retrieve data, insert new records, update existing ones, and delete records from a database. SQL is essential for a wide range of data operations, making it a fundamental skill for data analysts and other professionals who work with databases.

EMBEDDED DATAB MANIPULATION LANGUAGE             Embedded Data Manipulation Language (DML) refers to the subset of a database language used for the retrieval and manipulation of data. This language is embedded within a host programming language, allowing for operations such as select, insert, delete, and update on a database. It is a crucial aspect of database management, enabling users to interact with the database content efficiently and effectively. The most common example of DML is SQL, which is widely used in relational databases for managing structured data.

 INTERACTIVE DATA MANIPULATION LANGUAGE           Interactive Data Manipulation Language (IDML) refers to a set of commands used in computer programming and database management that allows users to interactively create, read, update, and delete data. This language is a crucial component of database management systems, enabling users to handle data in a dynamic and user-responsive manner. IDML is particularly important in the context of SQL databases, where it forms a subset of the broader Data Manipulation Language (DML), which also includes scripting and programming capabilities for more complex and automated data operations.

 DATA DEFINITION LANGUAGE                     Date definition language s a subset of SQL used in database management systems to define and manage all structures in a database. This includes creating, altering, and deleting tables, indexes, and constraints. DDL is crucial for setting up and modifying the scheme of a database, which defines how data is organized and how relationships between data are handled.