Question

SQL is our language for relational databases - do you think it's an adequate "language" for database creation and manipulation?

Answer 1

Solution:

Yes, SQL is an adequate "language" for database creation and manipulation. This can be well explained with the following points.

It is a special-purpose language designed for the creation and maintenance of data in relational databases. Most relational databases support SQL, which is an added benefit for database administrators (DBAs), as they are often required to support databases across several different platforms.

One of the most fundamental DBA rites of passage is learning SQL, which begins with writing the first SELECT statement or SQL script without a graphical user interfaces (GUI). Increasingly, relational databases use GUIs for easier database management, and queries can now be simplified with graphical tools, e.g., drag-and-drop wizards. However, learning SQL is imperative because such tools are never as powerful as SQL.

Although SQL isn't a general-purpose programming language, it contains some impressive tools. Three languages within a language offer everything you need to create, modify, maintain, and provide security for a relational database:

• The Data Definition Language (DDL): The part of SQL that you use to create (completely define) a database, modify its structure, and destroy it when you no longer need it.

• The Data Manipulation Language (DML): The part of SQL that performs database maintenance. Using this powerful tool, you can specify what you want to do with the data in your database — enter it, change it, or extract it.

• The Data Control Language (DCL): The part of SQL that protects your database from becoming corrupted. Used correctly, the DCL provides security for your database; the amount of protection depends on the implementation. If your implementation doesn't provide sufficient protection, you must add that protection to your application program.

Thus, we can say that it's an adequate "language" for database creation and manipulation.

Please give thumbsup, if you like it. Thanks.