What Will I Learn?
Database concepts
Relational model
Relational query languages
– Relational Algebra and Calculus
– Datalog
– SQL
– QBE
Triggers
Embedded SQL
Recursion
Web database programming
Conceptual data modeling
E/R data model
OO data model
Relational database design
– Normal Forms (NF)
– 1-4NF
– Lossless join decomposition
XML, XPath and XQuery
E/R data model
OO data model
Relational database design
– Normal Forms (NF)
– 1-4NF
– Lossless join decomposition
XML, XPath and XQuery
Semantic Web
RDF, RDF Schema, and OWL• Storage and indexing
Query processing and optimization
Parallel and distributed databases
NoSQL databases
Transaction processing and database recovery
Database security
Current developments in knowledgebase
Learning Skills
The course content is balanced on theory and practice, the course aims at
achieving the following learning outcomes:
• An appreciation of pervasive use of Knowledgebase and DBMS in different
application domains
• Skill for developing database applications
• Skills for devising data models and query languages
• Skills for developing web database applications
• Learning storage and indexing of data
• Learning transaction processing and database recovery
• Learning knowledge representation and semantic web technologies
• Skills to integrate knowledge to databases