Data warehouse concepts

A data warehouse maintains its functions in three layers: staging, integration, and access. Staging is used to store raw data for use by developers. The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users.
Data warehouses can be subdivided into data marts. Data marts store subsets of data from a warehouse.

See data warehouse concepts

Definition of data mining

A world famous life sciences company wants to do a prestigious new drug promotion. The requirement is that it wants to find out who are their top notch sales representatives to do the job. The selection should be scientifically done and based on years and years of performance data in their data warehouse.

See full data mining definition.

SQL commands

SQL is an ANSI (American National Standards Institute) standard. SQL stands for Structured Query Language. This language is used to access / communicate with a database. A database is an organised collection of data usually in digital form. Though SQL was originally developed by IBM, and first made commercial by Relational Systems (now part of Oracle), almost all database software vendors support SQL while adding their own SQL extensions.

See SQL examples.