Course Description

This course will discuss databases and their processing starting with a review of basic database material such as the ERD concept which will be continued with EERD (Enhanced Entity Relationship Diagram) which includes the topics of Specialization, Generalization and Categorization. Next, we will continue with a review of SQL and advanced SQL in the form of creating Subqueries, Transact SQL through functions, store procedures and triggers. The query discussion also discusses query optimization. To deepen knowledge about advanced theme databases, client server databases, distributed databases, internet databases, mobile databases, cloud databases, spatial databases and a little about datawarehousing and data mining are also discussed.