Posts
First, SQL is the premier tool for viewing information from a relational database. It doesn’t just
give you a data dump. SQL gives you sophisticated tools to summarize, consolidate, and calculate
from the data. Using table relationships, data can be combined from multiple tables in a number
of ways. With a properly designed database, SQL can answer practically any question about the
data.
Second, SQL provides commands to manipulate the data in a relational database. Records
can be updated and added to or deleted from a table. Here is where SQL as a database language
really shines. Procedural programming languages, such as BASIC, might require several lines of
code to update a record in a database table. In addition, procedural programming languages
would have to use some sort of looping structure to repeat this process on every record. SQL
operates on an entire set of records all at the same time. SQL is like haiku for programmers;
often a dozen words or fewer can delete or change thousands of records.
Finally, SQL is a complete data definition language (DDL). The database itself can be
created along with all tables, fields, primary keys, and relationships. Add to that the record insert
commands, and you can have a complete database and all its data expressed in programming
code. This greatly enhances a database programmer’s ability to work remotely or to port data
enhancements among various installations.
give you a data dump. SQL gives you sophisticated tools to summarize, consolidate, and calculate
from the data. Using table relationships, data can be combined from multiple tables in a number
of ways. With a properly designed database, SQL can answer practically any question about the
data.
Second, SQL provides commands to manipulate the data in a relational database. Records
can be updated and added to or deleted from a table. Here is where SQL as a database language
really shines. Procedural programming languages, such as BASIC, might require several lines of
code to update a record in a database table. In addition, procedural programming languages
would have to use some sort of looping structure to repeat this process on every record. SQL
operates on an entire set of records all at the same time. SQL is like haiku for programmers;
often a dozen words or fewer can delete or change thousands of records.
Finally, SQL is a complete data definition language (DDL). The database itself can be
created along with all tables, fields, primary keys, and relationships. Add to that the record insert
commands, and you can have a complete database and all its data expressed in programming
code. This greatly enhances a database programmer’s ability to work remotely or to port data
enhancements among various installations.
0 comments:
Post a Comment