Posts

All About XML, JSON and AJAX

Image
  What is XML? XML (Extensible Markup Language) is a markup language used for storing and transporting data. It is a simple and flexible text-based format that uses a set of tags to describe data elements and attributes. XML documents are structured as a tree-like hierarchy of elements, where each element can contain other elements, attributes, or data. XML is widely used in web development, and it is often used for exchanging data between different systems or applications. It is also used for storing and describing data in a way that is both human-readable and machine-readable. For example, many web services and APIs use XML to define the structure and format of their data. What is JSON? JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write and easy for machines to parse and generate. It uses a syntax that is similar to JavaScript objects, with key-value pairs and nested data structures. JSON is widely used in web deve...
Post a Comment
Read more

Learning SQL

Image
 What is SQL? SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It is commonly used to perform operations such as inserting, updating, and deleting data, as well as querying and retrieving data from a database. SQL is used in a wide variety of applications, including web development, business intelligence, data analysis, and more. SQL is a standard language, meaning that it is widely recognized and supported across many database management systems. There are various versions of SQL, including MySQL, Oracle, Microsoft SQL Server, PostgreSQL, and more. Although there are some differences in syntax and functionality between different versions, the basic principles of SQL remain the same. More about SQL: -SQL is a declarative language, meaning that it focuses on describing the desired result, rather than specifying how to achieve that result. For example, when querying a database, you specify the conditions that the data shou...
Post a Comment
Read more

SQL Components

Image
  SQL is a comprehensive language that has its own DDL and DML components: A.  DATA DEFINITION LANGUAGE Data Definition Language ( DDL ) is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others.  DDL is also used to specify additional properties of the data. The storage structure and access methods used by the database system by a set of statements in a special type of DDL called a data storage and definition language. These statements define the implementation details of the database schema, which are usually hidden from the users. The data values stored in the database must satisfy certain consistency constraints.    DATA MANIPULATION LANGUAGE The SQL commands that deal  with the manipulation of data present in the database belong to DML or Data Manipulation Language and this includes most of the SQL statements. It is the component of the SQL statement that controls access to data and to the ...
Post a Comment
Read more

DBMS and the Differences of Access and Excel

Image
  What is a Database? A database allows you to store information related to a specific topic in an organized way. You can sort, extract, and summarize data-related information in addition to storing the data itself. Microsoft Office Access, a database program, is among the software tools that enable you to achieve this program for production and administration. What type of Software is Microsoft Office Excel? Excel is a  spreadsheet software   program that is  traditionally used to   manage numerical  information graphic tools, and pivot tables. What Type of Software is Microsoft Office Access? Access is called a  relational database  management  program, because the  tables are linked, or  related .  The real power of Access comes in being able  to link and extract information from multiple  tables to answer specific questions. Differences between Access and Excel The main difference between Excel and ...
Post a Comment
Read more

DBMS FUNCTIONS, ADVANTAGES AND DISADVANTAGES

Image
  DBMS FUNCTIONS DATA DEFINITION The DBMS must be able to accept data definitions(external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form.  DATA MANIPULATION The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database. DATA SECURITY AND INTEGRITY  The DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator.   DATA RECOVERY AND CONCURRENCY   The DBMS must have the capability of recover from, or minimize the effects of a system crash.   DATA DICTIONARY  The DBMS must provide a system database called the database dictionary. ADVANTAGES OF DBMS   REDUCED DATA REDUNDANCY  In database system, data redundancy is avoided by keeping a single copy of the data.   DATA INTEGRITY ...
Post a Comment
Read more