Posts

JavaScript Codes

Image
 What is XML?      > Data may be stored and sent using XML, which is independent of technology and software.                          What is XML?            XML stands for eXtensible Markup Language XML is a markup language much like HTML XML was designed to store and transport data XML was designed to be self-descriptive XML is a W3C Recommendation What is JSON?     > The JSON format is text-only, however the JSON syntax is developed on JavaScript object notation syntax. Any programming language may be used to write code that reads and produces JSON data.               JSON Syntax Rules Data is in name/value pairs Data is separated by commas Curly braces hold objects Square brackets hold arrays What is AJAX?      >AJAX is a deceptive acronym. Although XML may be used by AJAX apps to transfer data, plain text and JSON text are also frequently used.                What is AJAX? AJAX =  A synchronous  J avaScript  A nd  X ML. AJAX is not a programming language. AJAX just uses a
Post a Comment
Read more

Structured Query Language

Image
 What is SQL? A computer language used for managing and modifying databases is called SQL (Structured Query Language). For creating, managing, and querying relational databases, it is the industry standard. Database operations including creating tables, adding, updating, and deleting data, querying data to discover particular information, and controlling user access to databases are all carried out using SQL. Many businesses and organizations store and manage data, including financial transactions, customer data, and inventory, using SQL. Several well-known relational database management systems (RDBMS), such as MySQL, Oracle, and Microsoft SQL Server, are primarily written in SQL.
Post a Comment
Read more

Introduction to SQL: Module 3

Image
   INTRODUCTION TO SQL: Module 3 Data Definition Language: Database structure is defined and maintained using Data Definition Language (DDL), a subset of SQL (Structured Query Language). Using DDL, database objects such as tables, indexes, and constraints can be created, changed, and destroyed. You can create and modify tables, indexes, and other database objects using the DDL statements' CREATE, ALTER, and DROP commands. These statements outline the structure of a database, describing data types, relationships, and constraints to protect data integrity. Among the DDL statements are the following: The database's CREATE TABLE statement is used to create new tables. The table's columns are described together with their data types and any column limitations. Changes to a table's structure can be made using the ALTER TABLE statement. It can be used to change data types, add or remove columns from tables, and create limitations. Use the statement "DROP TABLE" to el
Post a Comment
Read more