Course Description
Database Concepts and Design: Database System Application, Purpose of Database System, Data Models, DBMS, View of data, Database languages, Database Design, DDL, DML, SQL, Relational Database, Data Storage, Querying, Application Design and development, Server, Server Side Scripting languages, Client Side Scripting Languages, Database Architecture, Database Users, Database administrator. Data Mining, Information Retrieve.
Course learning Outcomes
On successful completion of this module, the student will be able to:
· Demonstrate and understanding of the differences between file base system and DBMS
· Demonstrate purpose of Database System
· Demonstrate an understanding of the importance of Database Management System;
· Demonstrate an understanding of the data view;
· Demonstrate an understanding the query languages;
· Demonstrate and understand the SQL command;
· Demonstrate and understand Data model techniques
Course Materials
· Overview of database systems
· Database System Application
· Structure of Relational Databases,
· Fundamental Relation Algebra Operations
· Database Design and Entity Relational Model
· SQL
· Basic Structure of SQL Queries
· Application Design and Development
· Data Analysis and Mining
· Data Storage and Querying
Course reading materials
· Database System Concepts by Abraham Silberschatz, Henry F, F.Korth, S. Sudarshan Publisher: McGraw-Hill, Hardcover, 5th edition, Published 2005, ISBN 0072958863
· Database Management Systems, 3rd Edition, by Raghu Ramakrishnan, Johannes Gehrke, Publisher: McGraw-Hill, Hardcover, 3rd edition, Published 2002, ISBN 0072465638