أساسيات قواعد البيانات - الجزء الأول 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.
- 5
- 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
- NEW Lecture 4: The Relational Model
- Relational Model Terminologies
- Informal Design Guidelines
- Representing Relational Database Scheme
- Step 1 and 2 (Mapping Entity, multi-value)
- Step 3. Mapping Weak Entity
- Step 4. Mapping Binary Relationships
- Step 5. Mapping Unary Relationships
- Step 6. Mapping N-ary Relationships
- Company Example Mapping
- Step 7. Mapping Super/sub Classes Relationship
- Extra Examples
- 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 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 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 Rating0%0%0%0%0%
200 SAR
Lectures
82 Videos
Duration
22:21:44
Material
35 Files
Assignments
Yes, Completely
Labs
Yes, Completely
Project
Explanation, No implementation
Certificate
Not Applicable
Related Courses
No related courses to this course, Browse more courses
Reviews (0)
Real reviews from real students.
No reviews yet.