Course

Unit 1

SQL, Creating databases and tables, Database administration, Function, Procedure, Trigger

Unit 2

Classification algorithms: decision tree classification, naive Bayesian classification, Data processing in WEKA, a brief introduction to other classifiers, Clustering algorithms: methods to cluster continuous data,

Unit 3

Methods to cluster categorical data, file processing in database environment, E-R models,

Learning objective:

To introduce a hands-on session on database management systems and make use of this in storing and retrieving biological data.

Course outcome:

Students should be able to

CO1. Implementing skills to generate databases using Oracle database management system

CO2. Preparing platforms for storing and retrieving biological data

Textbooks1. ?Database Management Systems? by Raghu Ramakrishnan and Johannes Gehrke, (3rd edition), McGraw Hill Education2. ?ORACLE PL/SQL Programming? by Scott Urman (5th edition), McGraw Hill Education.3. ?Database Systems Concepts? by Henry F Korth, Abraham Silberschatz, and S. Sudarshan (7th edition), McGraw Hill Education.4. ?Database Management Systems? by Alexis Leon, Mathews Leon and Vikas Shukla, (3rd edition) Vikas Publications5. ?Oracle 9i The Complete Reference? by Kevin Loney, George Koch, (1st edition) Oracle Press6. ?Data Mining: Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems) — by Jiawei Han, Micheline Kamber (2011);