ESPIRITU BLOGS

 WHAT IS SQL?      SQL stands for Structured Query Language. SQL is used to communicate with a database. It is the standard language for relational database management systems. SQL statements are used to perform tasks such as updati ng data on a database or retrieving data from a database. Some common relational database management systems that use SQL are Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.      Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database. WHAT SQL CAN DO? SQL can execute queries against a database SQL can retrieve data from a database   SQL can insert records into a database   SQL can update records in a database  S...

 WHAT IS XML?     XML or Extensible Markup Language is a markup language and file formal for sorting, transmitting, and reconstructing arbitrary data.  It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. XML emphasizes simplicity, generality, and usability across the Internet. It is a textual data format with strong support via Unicode for different human languages. Although the design of XML focuses on documents, the language is widely used for the representation of arbitrary data structures such as those used in web services. JSON JavaScript Object Notation (JSON) is a standard text-based format for representing structured data based on JavaScript object syntax. It is commonly used for transmitting data in web applications. JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate and it is ...