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.
SQL
What is SQL? Hello friends, Today we will learn about SQL, SQL stand for--- Structured Query Language . SQL is used to communicate with a database. According to ANSI (American National Standards Institute) , SQL is a database computer language designed for the retrieval and management of data in a relational database . What is the Database? A database is an organised collection of data, stored and accessed electronically SQL is widely popular because it offers the following advantages − We can easily create and drop databases and tables . Allows users to define the data in a database and manipulate that data. Describe the data. High Speed: SQL Queries can be used to retrieve large amounts of records from a database quickly and efficiently .