أساسيات قواعد البيانات - الجزء الأول IS220
Databases are needed to store all the information and data of any system. This course will teach you how to design and build a database.
-
-
Lecture 1: Introduction to Databases
- File-Based Systems 21:20
- Database Approach 16:20
- Example of a Database 09:42
- Database management system 10:10
- Main Characteristics of Database 13:55
- Components of DBMS Environment & Roles in DataBase Environment 10:10
- Advantages and Disadvantages of Database Approach 04:55
- Slide 17 Solution - Examples Of Database Requests 03:10
- Lecture 2: Database Environment
-
Lecture 3 pt.1: Entity-Relationship Modeling (ER)
- ER Model 08:56
- Entity 07:39
- Attributes 07:54
- Types of Attributes 18:50
- Entity Type And Key Attribute 13:44
- Relationships 32:35
- Strong & Weak Entity and Notations 16:08
- COMPANY Example 15:20
- Dream Home Database Example 15:41
-
Lecture 3 pt.2: Enhanced Entity-Relationship Modeling (EER)
- EER 33:00
-
Lecture 4: The Relational Model
- Relational Model Concepts
- Relational Model Constraints and Relational DB Schemas 41:30
- Update Operations 12:23
- Exercise 08:14
- Step 1 and 2 (Mapping Entity, multi-value) 27:19
- Step 3. Mapping Weak Entity 07:36
- Step 4. Mapping Binary Relationships 31:44
- Step 5. Mapping Unary Relationships 21:05
- Step 6. Mapping N-ary Relationships 06:49
- Company Example Mapping 13:41
- Step 7. Mapping Super/sub Classes Relationship 31:02
- Extra Examples 18:26
- Lecture 5: Normalization
-
Lab Sheets
- How to Install Oracle and Notepad++ 15:50
- Lab 1 Sheet 08:56
- Lab 2 Sheet - Part 1 13:20
- Lab 2 Sheet - Part 2 13:34
- Lab 2 Sheet - Part 3 13:08
- Lab Sheet 3 12:34
- Lab Sheet 4 15:50
- Lab Sheet 5 29:55
- Tutorials
-
Previous Exams
- Quiz 2021-2022 (1) 12:37
- Quiz 2021-2022 (2) 08:42
- Mid 2 - 2021/2022 (Normalization) 10:33
- Mid 1 - 2019/2020 30:51
- Mid 1 2021-2022 17:02
- Mid 2022-2023 27:08
- Quiz 2022 39:58
- Mid 1 2020-2021 23:31
- Mid 2 | 2021-2022 {Normlization} (2) 37:55
- Mid 1 2023-2024 32:46
- Mid 2 2023-2024 33:53
- Quiz 2022-2023 (Lecture 1,2) 28:45
- Quiz 2023-2024 (Lecture 1,2) 06:10
- Teacher's Revision Mid 1 2023-2024 13:02
- Mid 1 Previous Exams 39:54
- Mid 2 NA Normalization 43:33
- Project
-
Lecture 1: Introduction to Databases
- Databases are needed to store all the information and data of any system. This course will teach you how to design and build a database.
-
-
Student feedback
5Course Rating
200 SAR
Lectures
71 Videos
Duration
22:21:44
Material
35 Files
Assignments
Yes, Completely
Labs
Yes, Completely
Project
Explanation, No implementation
Certificate
Not Applicable
Reviews (0)
Real reviews from real students.
No reviews yet.