The objective of this course is to provide a basic introduction …….
The course introduces the field of data design and manipulation as well as the used technologies. At the end of the course, the student will be able to:
- design a database starting from a given reality with the entity relation diagram (ERD).
- Transform an ERD into a relational schema, normalize it and manipulate it;
- create the database corresponding to the relational schema, manipulate the structure of the database with DDL and query data with DML.
Course outline
1. Basic Modeling Concepts.
2. Integrity Constraints Modeling.
3. The Relational Model
4. Normalization Theory
5. Relational Algebra Language
6. Database Manipulation using SQL : DDL, DML, DQL, DCL
7. Basic Database Administration
8. Indexes, views, cursors, manipulation
The course introduces the field of data design and manipulation as well as the used technologies. At the end of the course, the student will be able to:
- design a database starting from a given reality with the entity relation diagram (ERD).
- Transform an ERD into a relational schema, normalize it and manipulate it;
- create the database corresponding to the relational schema, manipulate the structure of the database with DDL and query data with DML.
Course outline
1. Basic Modeling Concepts.
2. Integrity Constraints Modeling.
3. The Relational Model
4. Normalization Theory
5. Relational Algebra Language
6. Database Manipulation using SQL : DDL, DML, DQL, DCL
7. Basic Database Administration
8. Indexes, views, cursors, manipulation
