إدارة قواعد البيانات الجزء الاول
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 00:00
- Placing File records on Disk 00:00
- Files of Ordered Vs Unordered records 00:00
- Examples 08:50
- RAID Technology 22:55
- RAID Summary
- Quiz CH1
-
Lecture 2: Indexing Structures for Files and Physical Database Design
- Introduction 22:13
- Example 11:39
- Clustering indexes 00:00
- Multilevel Indexes 16:26
- B+ Tree Example 21:31
- Quiz 1 - CH 1,2
- Lecture 3: Introduction to Transaction Processing concepts and Theory
- Lecture #4: Concurrency Control Techniques
-
Mid 1
- 2PL Example 04:28
- Conflict Serializability 17:39
- سوال مهم في الاختبار 01:47
- Strict and Rigorous 2PL 08:21
- Serializability
- اسئلة اختبارات سابقة
- حل اسئلة اختبارات سابقه 12:24
- حل التجميعات 22:36
-
Lecture #5: PL/SQL and Triggers IS 2024
- PL/SQL Architecture and Data types
- PL/SQL BLOCK 00:00
- PL/SQL Conditional Statements 00:00
- Procedures and Functions 00:00
- Triggers 00:00
-
Lab
- Oracle Database Download 00:00
- Lab 1: SQL Queries in Oracle 12:34
- Lab 2: Oracle Indexes 2024 00:00
- Lab 2: Oracle Indexes 2024 13:31
- Lab Evaluation 1
- Lab2 Evaluation 11:12
- Lab 3: Transaction processing part 1 2024 00:00
- Lab 3: Transaction processing part 2 2024 00:00
- Lab 3 Evaluation
- Evaluation 3 - Lab 2,3 00:00
- Lab 3 Evaluation - Part 2 00:00
- 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
175 SAR
Lectures
59 Videos
Duration
05:47:29
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.