Home » Online Computer Education » Learn online DBMS “Structured Query Language (SQL )” Complete Lesson 7

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.

 

Structured Query Language 1

 

Structured Query Language 2

Structured Query Language 3

Structured Query Language 4

Structured Query Language 5

Structured Query Language 6

Structured Query Language 7

Structured Query Language 8

Structured Query Language 9

Structured Query Language 10

About

The main objective of this website is to provide quality study material to all students (from 1st to 12th class of any board) irrespective of their background as our motto is “Education for Everyone”. It is also a very good platform for teachers who want to share their valuable knowledge.

Leave a Reply

Your email address will not be published.