SQL (Structured Query Language) is a language designed specifically for communicating with databases and is a powerful tool for manipulating data. It is the standard query language for relational database management systems (RDBMS).
It is a database-independent language that allows you to query data and to perform CRUD (Create, Update, and Delete) operations. SQL is easy to learn. The statements are all made up of descriptive English words.
SQL consists of three sublanguages as follows:
DDL: Data Definition Language
DML: Data Manipulation Language
DCL: Data Control Language
DDL (Data Definition Language) creates and maintains physical data structures using the following statements:
DML (Data Manipulation Language) perform the following operations:
DCL (Data Control Language) perform the following operations:
Database Security is managed through the SQL GRANT and REVOKE statements.
If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!