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

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