Database Fundamentals IS220
Databases needed to store all the information and data of any system such as patients' info, products of an eCommerce system, and much more. This course will teach you how to design and build database
- جامعة الأميرة نورة بنت عبدالرحمن
- Created by Eng.Naif AlShehri
- Last update 2025-01-10
- العربية English
-
-
Lecture 1 : Principles of Databases
- File-Based System 26:10
- DataBase Approach 17:33
- Example of DataBase 12:43
- DataBase Management System 14:10
- Main Characteristics of Database 16:39
- Components of DBMS Environment 04:41
- Roles in DataBase Environment 11:33
- Advantages and Disadvantages of Database Approach 06:05
-
Lecture 2: Database Environment
- Three Level Architecture 22:21
- Data Independence 05:18
- Database Language 03:18
- Data Model 17:35
- Classification of DBMSs 06:45
- Tutorial Chapter 1 and 2 :Theory 01:13:24
-
Lecture 3:Entity-Relationship Modeling
- ER Modeling 16:44
- ERD : Entity 05:53
- ERD : Attributes 23:40
- Key Attributes 15:57
- ERD: Relationship 08:30
- Unary Relationship 09:59
- Binary Relationship 10:36
- Ternary Relationship 02:58
- Attributes on Relationships 03:27
- Constraints on Relationship: Cardinality 34:12
- Constraints on Relationship: Multiplicity 14:14
- Constraints on Relationship: Participation 22:19
- Strong and Weak Entity Types 16:29
- ER: Full Example 34:47
- ER Alternative Notations 11:02
- Example: Online Bank Transaction 14:14
-
Lecture 4: Enhanced Entity-Relationship Modeling
- Intro to EER 09:26
- Specialization and Generalization 21:48
- Constraints on Specialization and Generalization 16:22
- Summary of ER Notation 02:30
- EERD Simple Example 06:26
-
Chapter#5
- The Relational Model 35:22
- Relational Keys 25:54
- Integrity Constraints 17:23
- Views 15:48
- Chapter#6
-
Chapter#7
- Informal Design Guidelines 36:09
- Functional Dependencies 20:57
- Characteristics of Functional Dependency 23:13
- Transitive Dependency 07:10
- Identifying Functional Dependencies and Primary Key 21:16
- Normalization 01:19:44
-
Lecture#8
- SQL and DDL 01:48:03
-
Lecture#9
- Chapter#9 Part-1 01:55:45
- Lecture#9 Part#2 02:22:31
- Lecture#10
-
Lecture#11
- Lecture#11 : TCL and DCL 40:38
-
SQL - Oracle Lab
- Installing Oracle DataBase 10g 01:51
- Connecting To DB and Preparing Environment 07:43
- Create Simple Table without Constraints 12:38
- Create Table : NOT NULL Constraint 22:33
- Create Table : UNIQUE Constraint 15:26
- Create Table : Primary Key Constraint 11:08
- Create Table : Check Constraint 07:32
- Create Table : Default Constraint 12:08
- Create Table : Foreign Keys Constraint 35:12
- ALTER TABLE : Add Column 07:05
- ALTER TABLE : Drop Column 15:31
- ALTER TABLE : Modify Column 07:46
- ALTER TABLE : ADD Constraint 14:22
- ALTER TABLE : Drop Constraint 18:21
- ALTER TABLE : Enable and Disable Constraint 10:56
- DROP TABLE 07:44
- DESC TABLE 01:33
- INSERT INTO 01:03:03
- INSERT INTO : Date and Timestamp 29:48
- SELECT Statement 01:08:16
- UPDATE Statement 22:29
- DELETE FROM 14:30
- Sub Query 24:21
- Aggregate Functions 27:58
- GROUP BY and HAVING 39:08
- Views 57:27
- Alisas and Prefix 08:55
- Joining Tables 40:20
- Transaction Control Language 17:44
- Data Control Language 11:29
- Full Example ERD to Relational Model TO SQL Part#1 10:05
- Full Example ERD to Relational Model TO SQL Part#2 13:49
-
Homework & Assignment
- Homework#1 01:10:20
- Assignment 1 - Q1 13:33
- Assignment 1 - Q2 08:50
-
Revision
- Revision : Midterm#2 01:01:06
- Review Final Exam 01:36:01
- Review Final 38:16
- Previous Final Exam - New 24:58
- Previous Exams - Mid 2 (New) 16:23
-
Projects
- About Project Phase#1 19:41
- More Examples For Phase#1 01:06:41
-
Mid#1 Revision
- Mid #1 Review 01:28:03
- Previous Exams 20:16
- Summary : Review 21:07
-
Labs
- Lab#4 Part#1
- Lab#3 05:10
- Lab#4 Part#1 09:29
- Lab#4 Part#2 14:15
- Lab#4 Part#3 12:31
- Lab#5
- Lab#8 Part#2
- Lab#5 25:30
- Lab#7 Part#1 06:41
- Lab#7 Part#2 08:48
- Lab#8 31:49
- Lab#9 12:06
- Lab#10 39:28
- Lab#11 36:53
- Lab#12 14:42
- Lab#13 39:03
- Revision Final Lab 01:19:21
-
Lecture 1 : Principles of Databases
-
دراسة ذاتية
Databases needed to store all the information and data of any system such as patients' info, products of an eCommerce system, and much more. This course will teach you how to design and build databases from scratch, starting by planning and gathering the system info, determining the target objects in the system until designing the whole schema.
Learn SQL as a database programming language where it enables you to create databases, users, and tables, SQL enables you to insert, retrieve, update, and remove data. This course contains a full section to cover SQL in detail. In case you want to understand database design and SQL, then this course is for you. -
Naif works as a software engineer. He likes designing, building, and developing highly scalable and secured systems along with testing.
He's a professional certified Java programmer by Oracle. He has rich knowledge in programming languages {such as Java, Python, C, Swift, etc} advanced algorithms & data structures. Naif has the passion to work as an instructor, he has more than 9 years of experience in the field.
He likes to teach people how to program, how to build robust systems, and how should they think logically during the systems development and the right usage of data structures.
Most of his interests now are iOS Development, Backend Engineering, Backend Technologies, Cloud-Native Apps and Tools -
Student feedback
5.00Course Rating
1000 SAR
Lectures
118 Videos
Duration
50:54:23
Material
40 Files
Assignments
Yes, Completely
Labs
Yes, Completely
Project
Yes, Completely
Certificate
Not Applicable
Reviews (7)
Real reviews from real students.
I, hope teacher naif teach more subject pls✨
اخذت الداتابيس قبل كم ترم، ما اقدر اوصف دقة وتنظيم الكورس مع تيتشر نايف.. المقاطع جودها رائعة والشرح يجننننننن، والمشروع كان لكل مجموعة فكرة وشرح كل الافكااااار، ساعدنا بكل شيء باقي بس يختبر بدالنا
شرح رهيب ومفصل وواضح ويعطي كل جزئيه حقها شكراً مهندس ومرام وغيدا ماقصرو معنا متعاونين جداً❤️
استفدت جدا من الكورس شكرا لتيتشر نايف و غيداء 🤍
تيتشر نايف الافضل بالشرح اتمنى يشرح مواد اكثر لان شرحه 👍🏻 واشكررر تيتشر غيدا لوجودها الدائم لاستفسارات البنات ❤️❤️
رائع
رائع جدا جدا