Information Management

Module 4_INFMNGT LECTURE A. What is SQL? SQL is a language that is used to communicate with databases. We can use it to access and manipulate databases. SQL stands for Structured Query Language , and it is the standard language for relational database management systems, according to ANSI (American National Standards Institute). SQL can be used to insert, search, update, and delete records in a database. It may perform a variety of different tasks, including database optimization and maintenance. Here’s a list of some of the most commonly used  SQL commands : CREATE  – defines the database structure schema INSERT  – inserts data into the row of a table UPDATE  – updates data in a database DELETE  – removes one or more rows from a table SELECT  – selects the attribute based on the condition described by the WHERE clause DROP  – removes tables and databases