WHAT SQL?

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 Language also know as EDML, The embedded form of the DML is used to incorporate SQL statements into programs created using other programming languages.


View Definition, contains a command used for defining relational views.


Authorization, contains commands for specifying access to the relational and views.


Integrity, used to specify complex integrity constraints.


Transaction Control, commands that used to specify the start and end of transactions. It is also used in data locking and concurrency controls.


IMPORTANT COMMANDS IN SQL


SELECT - extracts data from a database

UPDATE - updates data in a database

DELETE - deletes data from a database

INSERT INTO - inserts new data into a database

CREATE DATABASE - creates a new database

ALTER DATABASE - modifies a database

CREATE TABLE - creates a new table

ALTER TABLE - modifies a table

DROP TABLE - deletes a table

CREATE INDEX - creates an index (search key)

DROP INDEX - deletes an index


CONCLUSION

SQL remains a fundamental aspect of database management and data manipulation. Its versatility, efficiency, and standardization make it an essential tool for developers. Whether you're developing web applications, performing data analysis, or managing enterprise systems, mastering SQL is crucial and will simplify your tasks. So, what are you waiting for? Let's embark on this journey together and explore the world of SQL!


THAT'S ALL FOLKS! I HOPE THAT YOU HAVE LEARNED ABOUT SQL. 


SEE YAH!

DIOLOLA, LEANDRO J.



 














Comments

Post a Comment

Popular posts from this blog

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...
Read more