Database Technology (2)

Learning Outcomes :

1. Explain the fundamental concepts of database technology, including relational models, database design, and architecture.
2. Apply SQL and query languages to design, manipulate, and manage databases, including distributed and web-integrated databases
3. Analyze business data needs and propose database solutions using concepts such as data warehousing, business intelligence, and lightweight RDBMS

Topics:

1. The Relational Model, Relational Algebra, and Relational Calculus
2. SQL Fundamentals: Data Definition and Manipulation
3. Database Analysis and Conceptual Design (ER Modelling)
4. Logical and Physical Database Design, Normalization
5. Methodology of Database Design: Conceptual, Logical, Physical
6. Web and DBMS Integration Concepts (including XML and Semi-structured Data)
7. Distributed Database Systems and Replication
8. Database Security, Backup, and Recovery
9. Introduction to Data Warehousing and OLAP
10. Databases for Business Intelligence and Data Mining