Question

Why would you need to summarize data or filter criteria in your career? When would you see a query used to automate data for tasks? Give an example of how a smaller amount of specific information would help you instead of a list of all data.

Answer 1

The main purpose is to save time and effort. By summarizing data we can analyze quickly and obtain insights from it.

Using a query makes it easier to view, add, delete, or change data.

Also queries help to

• Automate data management tasks, such as reviewing the most current data on a recurring basis.
• Find specific data quickly by filtering or providing some conditions.
• Calculate or summarize data.

Examples of SQL Automation include

• Database Index Maintenance Tasks
• Creating backups in database
• Database Development and Deployment

An example of how a smaller amount of specific information help instead of a list of all data include Data Analysis or Data Mining.(Data Cleaning)

Here we have chunks of data. From which we remove the unwanted(redundant) data inorder find some pattern (insights) in it.

Moreover in DBMS, excess data (redundancy) is a problem.