What you’ll learn:
Describe the fundamental elements of relational database management systems.
Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL.
Design ER-models to represent simple database application scenarios
Improve the database design by normalization.
Requirements:
No Prerequisites.
Description:
******* –> All topics in course are going to upload very soon.
Course Objectives:
The objective of the course is to present an introduction to database management systems, with an emphasis on how to organize, maintain and retrieve – efficiently, and effectively – information from a DBMS.
Learning Outcomes:
Upon successful completion of this course, students should be able to:
• Describe the fundamental elements of relational database management systems
• Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL.
• Design ER-models to represent simple database application scenarios
• Convert the ER-model to relational tables, populate relational database and formulate SQL queries on data.
• Improve the database design by normalization.
• Familiar with basic database storage structures and access techniques: file and page organizations, indexing methods including B tree, and hashing.
