Data Mining and Databases

Title: Data Mining and Databases
Year: 2010
Duration: 1 week

Course Aim

The aim of this training is to provide students with the basis for a solid education in the fundamentals of Database technology, and Data Mining process. It reflects the latest developments in the field. This course gives, also, an overview of legal issues related to the data and databases they may use for data mining purposes.

Prerequisites

Knowledge of Windows environment (or others environment or software) and data management is required. This course is for people working in an environment for analysing data stored in databases.

It is essential that students have a good working knowledge of the English language, as the lessons will be delivered in English.

Small list of agenda / topics / main points

By the end of this course the students will be able to understand:

  • What is a database?
  • Limitations of data management with the traditional file system
  • What is the database design (data model)
  • What is database management system (DBMS) and how to use it
  • Backing up and secure of database
  • What is SQL (Structured Query Language) and how to use SQL for creating and querying relational database
  • Know the legal protections attached to databases and most of the data that will be used on data mining purposes, and understand rights and duties attached to their investigative data mining work as LEA to avoid legal proceedings failures.
  • What is and what is not data mining ?
  • Data mining process and data pre-processing various tasks
  • Data summarization, missing values, normalization
  • How to deal with noisy data?
  • The use of association rules
  • Data classification

If you are interested in applying for this course please read following page