أساسيات قواعد البيانات - الجزء الثاني 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 6: SQL Overview
- SQL Overview 14:20
- CREATE TABLE 22:23
- NOT NULL, UNIQUE and PRIMARY KEY Constraints 21:26
- Default and FOREIGN KEY Constraints 17:52
- CHECK Constraint 08:00
- ALTER TABLE and DROP TABLE 23:39
-
Lecture 7: Data Manipulation in SQL
- INSERT INTO and SELECT Statements 26:39
- Alias 02:00
- WHERE Clause 24:57
- UPDATE and DELETE Statements 13:18
- Extra Example 06:23
-
Lecture 8: Advanced SQL Queries and View
- Aggregate Functions 38:46
- GROUP BY and HAVING 34:55
-
Lecture 9: Advanced SQL Queries
- Tables names and Column names 06:36
- Alias 07:11
- JOIN 38:53
- Nested Queries 13:30
- EXISTS and NOT EXISTS 10:02
- UNION - MINUS - INTERSECT 13:02
- Lecture Examples 10:08
- Update and Delete with a value from a Subquery 06:25
-
Lecture 10: Transaction Control Language - Data Control Language
- Transaction Control Language 13:03
- Data Control Language 08:23
- Lecture 10 Extra Examples 13:32
-
Lab Sheets
- Lab Sheet 6 25:38
- Lab Sheet 7 27:19
- Lab Sheet 8 19:58
- Lab Sheet 9 28:59
- Lab Sheet 10 (Revision) 30:18
-
Lab Previous Exams
- Evaluation 1 - 2024 29:43
- Eval 1 2023-2024 57:17
- Evaluation 1 2022-2023 36:04
- Evaluation 1 2021-2022 37:42
- Evaluation 2 21:47
- Final Lab 2021-2022 44:40
- Final Lab 2022-2023 01:06:14
- Final Lab 2024 44:28
-
Previous Exams
- Final Online 2020-2021 39:44
- Mid 2 - 2021/2022 SQL 14:58
- Mid 2 SQL + Normalization 43:33
- Mid and Quiz SQL 28:20
- Mid 2 | 2021-2022 {Normlization, SQL} (2) 37:55
- Teacher's Revision Final 2022-2023 41:22
- Mid 2 2023-2024 33:53
- IMPORTANT All Finals 2021-2024 01:14:19
-
Tutorials
- Lecture 10 Tutorial 15:19
- Project
- Oracle Certificate (Free, Mandatory)
-
SQL - Oracle Lab| By Eng.Naif AlShehri
- 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
- Full Example ERD to Relational Model TO SQL Part#1 10:05
- Full Example ERD to Relational Model TO SQL Part#2 13:49
- 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
-
Lecture 6: SQL Overview
-
دراسة ذاتية
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
5.00Course Rating
200 ريال
المحاضرات
81 فيديو
المدة الزمنية
31:10:18
الملفات
36 ملف
الواجبات
Yes, Completely
الجزء العملي
Yes, Completely
المشروع
Explanation, No implementation
الشهادة
Not Applicable
التقييمات (2)
مشاركة التجارب وقصص النجاح ستظل أجمل الأشياء دومًا.
فوق التقييم والله شرح مبسط وجميل وسلس يدخل الدماغ بسرعه هذا غير تيتشر أثير العسل واشرافها علينا ومساعدتنا في كل وقت وفي مشاريعنا اغلبنا فل مارك من غير الدعم المعنوي والكلام اللطيف منها الله يسعدها 💕💕💕💕💕
ما قصرت والله معنا ساعدتنا في كل شي فيه التحديد والشرح والمشورع مسكت مجموعه مجموعه لحال وفي كل خطوه و ايضا ملخصات تتوريال شكرا من اعماق قلبي دكتوره اثير