أساسيات قواعد البيانات - الجزء الثاني 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 29:49
- Views 20:11
-
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
-
Lab Sheets
- Lab Sheet 6 25:38
- Lab Sheet 7 27:19
- Lab Sheet 8 19:58
- Lab Sheet 9 28:59
- Lab 10 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 44:40
- Final Lab 2022-2023 01:06:14
-
Previous Exams
- Final Online 2020-2021 39:44
- Mid 2 - 2021/2022 SQL 14:58
- Mid 2 SQL + Normalization 43:33
- For Final: SQL 28:20
- Mid 2 - - 2021/2022 37:55
- Teacher's Revision Final 2022-2023 41:22
- Mid 2 2023-2024 33:53
- Tutorials
- Project
-
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 SAR
Lectures
78 Videos
Duration
28:57:45
Material
9 Files
Assignments
Yes, Completely
Labs
Yes, Completely
Project
Explanation, No implementation
Certificate
Not Applicable
Reviews (1)
Real reviews from real students.
فوق التقييم والله شرح مبسط وجميل وسلس يدخل الدماغ بسرعه هذا غير تيتشر أثير العسل واشرافها علينا ومساعدتنا في كل وقت وفي مشاريعنا اغلبنا فل مارك من غير الدعم المعنوي والكلام اللطيف منها الله يسعدها 💕💕💕💕💕