of course,,what luck,,, I had to miss the early morning train today of all days…
but you know me I’m usually there,, I wouldn’t turn down an extra point!!

Data mining is a method by which data from many different sources can be compiled for the purpose of analyzing in the hopes that it can be interpreted into useful information.

The Data Mining process does not […]

the purpose of ETL is to reformat, normalize, and standardize data, to move it from a transactional database to an analytical one. Problems that arise generally include errors in original data, issues conforming […]

First the business process must be selected and described in a way that clearly defines the needs and goals and purpose, for example it could be a retail store you are defining.

Then you must decide on what […]

To remove data from a table only, it is safer to use DELETE, as it is possible to rollback and retrieve data. If an entire table is to be removed, DROP is prefered, as it will remove the table structure along […]

Data Manupulation Language is how you use and existing table, and deals with the data in a table. you can retrieve data, update data, delete data, and insert data.

data definition language is used to control […]

a relational database is a system in which entities, actions, and attributes are organized in such a way that connects the fields in an organized and optimal way. information arranged this way is by definition […]

If we don’t normalize, our data, we end up with inconsistencies, redundancy, wasted harddrive space, and when we make a change will possibly need to make the same change in many locations throughout our data base. […]

transactional data simply refers to the details or facts of a current situation, where as analytical data was once mere transactional, but has been translated, interpreted, and understood, for the purposes of […]