Some of The Most Important SQL Commands 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
Posts
DBMS Database Management System is a system that enable easy creation ,access and modification of database. It is used for effective efficient database management. DATABASE SYSTEM Database system is an integrated system of hardware,software and data. It define ad regulate the collection storage management and use of data within a database environment . DATA All the fact,text,image,sounds,video,segment that have meaning in the user environment and that can be recorded is known as data.