What is SQL?

Welcome again to my Blog! 

I will be sharing some information about SQL !

SQL stands for "Structured Query Language"


It is a standard language for accessing and manipulating databases


RDBMS

What is RDBMS?


It stands for "Relational Database Management System"

RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. 


SQL COMMANDS


These are some important SQL commands that you should know!

 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

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 




That is all for this Blog

Thank you for Reading !


Jordan I. Magbanua

BSIT 1-A

Comments