Sub-languages of SQL
Discover the different sub-languages of SQL such as DML, DDL, TCL, and DCL, and learn how each serves a specific purpose in PostgreSQL. Understand their commands and how SQL’s declarative nature supports efficient problem-solving and database operations.
We'll cover the following...
SQL vs. other languages
SQL is designed in a way that supports nonprogrammers for their reporting needs. This explains why the language doesn’t look like our normal programming language.
Apart from the aim to look like English sentences, the main aspect of SQL is that it’s a declarative programming language. This means that we get to declare or state the result we want to obtain; therefore, we need to think in terms of the problem we want to solve.
This differs from most programming languages, where the developer’s job is to transform their understanding of the solution into a step-by-step recipe for how to exactly obtain it, which means thinking in ...