Learn online DBMS “Structured Query Language (SQL )” Complete Lesson 7
Structured Query Language (SQL )
SQL is a language that is used to manage data stored in a RDBMS. It is a Data definition language (DDL) and a Data manipulation language (DML) where DDL is a language which is used to define structure and constraints of data and DML is used to insert, modify and delete data in a database.
SQL commands are used to perform all the operations. In order to study SQL commands, a server needs to be installed on the Computer. There are various software available. We will study the MySQL server.
SQL uses the terminology of table, row and column for the relational model terms relation, tuple and attribute.
For studying SQL queries we will use MySQL Community Server 5.6.14. Following are the steps to install and configure MySQL Community Server 5.6.14 for studying SQL commands discussed later.