إدارة قواعد البيانات الجزء الاول
This course is designed to give the students the knowledge and skills needed to maintain successful and efficient day-to-day operations of a DBMS. The course will also include the key concepts of dat
-
- Overview
-
Lecture 1: Disk Storage, Basic File Structures and Modern Storage Architectures
- Secondary storage devices 09:02
- Secondary storage devices Part 2 11:06
- Placing File Records on Disk 10:16
- Examples 08:50
- Allocating File Blocks on Disk 13:04
- RAID Technology 15:58
- SAN 04:59
- RAID Summary
- Quiz CH1
-
Lecture 2: Indexing Structures for Files and Physical Database Design
- Introduction 07:49
- Types of Single-Level Ordered Indexes Part 1 10:21
- Example 11:39
- Types of Single-Level Ordered Indexes Part 1 08:52
- Multilevel Indexes Part 1 23:22
- Multilevel Indexes Part2 16:26
- Exercise سؤال مهم 12:19
- Quiz 1 - CH 1,2
-
Lecture 3: Introduction to Transaction Processing concepts and Theory
- Introduction to transaction processing 11:46
- Concurrency Control 14:34
- Properties of Transactions 13:15
- Schedules in DBMS 16:30
- Conflict and View Serializable 23:28
- سلايدات تم اضافتها وهي جدا مهمه 22:22
- Transaction Support in SQL 12:34
- Lecturer 4: Database Performance Tuning and Query Optimization
-
Lecture 4: Concurrency Control Techniques
- Concurrency Control Techniques 13:12
- Two- Phase Locking Technique 16:39
- Two- Phase Locking Technique Part 2 19:47
- Deadlocks 13:00
- Timestamp Ordering Technique 09:16
- Timestamp ordering techniques Part 2 التطبيق مهم 26:48
- Locking techniques in Oracle 06:45
- Homework 08:01
- Thomas write rule Homework 11:26
-
Lecture 5: PL/SQL and Triggers
- PL/SQL Architecture and Data types 00:00
- PL/SQL BLOCK 00:00
- PL/SQL Conditional Statements 00:00
- Procedures and Functions 00:00
- Triggers 00:00
-
Mid 1
- Conflict Serializability 17:39
- Growing and Shrinking Example 01:47
- Strict and Rigorous 2PL 08:21
- Wait-die vs Wound-wait
- 2PL Example
- shrinking and the growing 01:47
- ملف التجميعات 1
- فيديو التجميعات 1
- فيديو التجميعات 2 12:24
- ملف التجميعات 2
- فيديو التجميعات 3 22:36
- ملف التجميعات 3
- ملف التجميعات 4
- فيديو التجميعات 4
-
Lab
- Oracle Database Download
- Lab sheet 1: Oracle Database Indexes 2025 23:23
- Lab Evaluation 1
- Lab sheet- 2 Tablespace & Datafile 2025 14:51
- Exercise Lab sheet- 2 10:50
- Lab 2 Evaluation
- Lab sheet-3 Part 1 Transaction processing 25:48
- Lab 3: Transaction processing part 2 14:18
- Lab 3: Transaction processing part 2 Exercise 10:50
- Lab 3 Evaluation
- Evaluation 3 - Lab 2,3
- Lab 3 Evaluation - Part 2
- This course is designed to give the students the knowledge and skills needed to maintain successful and efficient day-to-day operations of a DBMS. The course will also include the key concepts of data security
-
- Master in Data Science.
- Bachelor in Information Technology.
- Certified Data Management Professionals -CDMP
- Data Governance Certified - DAMA
- Metadata Certified - DAMA
- Data Quality Certified - DAMA
- ISO 8000 Master Data Quality Manager
- Artificial Intelligence Certified
- Business Intelligence Certification
- Work as a Data management consultant.
- Work as Projects Manager.
-
Student feedback
5Course Rating
150 SAR
Lectures
78 Videos
Duration
09:56:35
Material
25 Files
Assignments
Yes, Completely
Labs
Yes, Completely
Project
Yes, Completely
Certificate
Not Applicable
Reviews (0)
Real reviews from real students.
No reviews yet.