Structured Query Language

Objectives

---

• Th e processing skills of SQL. • Th e components of SQL. • To create a table by specifying the fi elds and records. • To apply various manipulations like inserting, updating and deleting records in a table. • To learn about various constraints and to apply it on tables. • To generate queries in the table by applying various clauses. • To modify the structure of an existing table. • Th e commands to delete records, table and revoke the commands.

Summary

---

• SQL is a language that helps to create and operate relational databases. • MySQL is a database management system. • The various components of SQL are Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Transactional Control Language (TCL), Data Control Language (DCL). • The DDL provides statements for creation and deletion of tables. • The DML provides statements to insert, update and delete data of a table. • The DCL provides authorization commands to access data. • The TCL commands are used to manage transactions in a database. • The DQL commands help to generate queries in a database. • The CREATE TABLE command creates a new table. "• SQL is a language that helps to create and operate relational databases. • MySQL is a database management system. • The various components of SQL are Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Transactional Control Language (TCL), Data Control Language (DCL). • The DDL provides statements for creation and deletion of tables. • The DML provides statements to insert, update and delete data of a table. • The DCL provides authorization commands to access data. • The TCL commands are used to manage transactions in a database. • The DQL commands help to generate queries in a database. • The CREATE TABLE command creates a new table."