Posts

Terminologies and Definition

Image
Hello again, fellow tech enthusiast! I'm back to introduce you to some more terminology! What Is XML? XML, which stands for Extensible Markup Language, structures your data similarly to a recipe. It uses tags (think tables) to define various pieces of information and their relationships. This makes XML readable by both humans and computers. key words that can be found on XML Tags - These instructions are in an angle brackets which is ( < and > ) that defines the part of data. Elements - The data you want to store. Attributes - This are additional details you can add, like size or color. What Is JSON? JSON, also known as JavaScript Object Notation, is a lightweight and human-readable format for storing and exchanging data. It is a popular choice among web developers who enjoy building websites due to its simplicity and flexibility. JSON key terms Data Format -  Let's see JSON as a language for structuring information. As it defines how data is organized, not how it's d...

WHAT SQL?

Image
HELLO! AGAIN EVERYONE, I'M BACK ONCE AGAIN TO DISCUSS TO YOU A NEW TOPIC THAT I WANT TO SHARE. IT'S ABOUT SQL. WHAT IS SQL? So, what does SQL stand for? SQL stands for Structured Query Language. SQL is the standardized language used to interact with databases, allowing for the storage, manipulation, and retrieval of data. Whether you're a professional, a coding enthusiast, or just a casual user, understanding SQL is one of the most important factors to master. Now let's dive in to some SQL components DATA DEFINITION LANGUAGE INTERACTIVE DATA MANIPULATION LANGUAGE EMBEDDED DATA MANIPULATION LANGUAGE VIEW DEFINITION AUTHORIZATION INTEGRITY TRANSACTION CONTROL Data Definition Language also known as DDL, It is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others. Interactive Data Manipulation Language also known as IDML, It can be used to insert, delete, and update tuples in a relation. Embedded Data Manipulation Lan...

Terminologies that I want to share

Image
HELLO, EVERYONE! I AM HERE TO INTRODUCE TO YOU ALL A NEW TOPIC THAT I STUMBLED MYSELF UPON WHICH ARE THE TERMINILOGIES OF DATA LANGUAGES. DATA DEFINITION LANGUAGE (DDL) Data Definition Language (DDL) is a part of SQL (Structured Query Language) that focuses on defining and managing the structures and objects within a database. DDL commands are utilized to create, alter, and delete database objects such as tables, indexes, and schemas. These commands affect the database's structure and can define how various data elements relate to each other. INTERACTIVE DATA MANIPULATION LANGUAGE  (DDL) The term "Interactive Data Manipulation Language" (IDML) denotes a collection of SQL commands designed for interacting with and manipulating database data interactively. This typically involves querying the database and updating records. A key characteristic of IDML is its common use in interactive sessions where users input commands directly to alter data. EMBEDDED DATA MANIPULATION LANG...