قواعد البيانات والتخزين السحابي FTEC 352
'Fintech’ refers to the use of technology to facilitate financial services. To streamline and improve traditional financial services using technology.
-
- Lecture 1: Introduction to FinTech and Data Management
-
Lecture 2: Introduction to Databases
- Introduction to Databases 27:38
- Database Approach 18:43
- DBMS 10:11
- Main Characteristics of DB 17:28
- Components of DBMS 10:11
- Lecture 3: Database Environment
-
Lecture 4 pt.1 : Entity-Relationship Modeling (ER)
- ER model 08:56
- Entity 07:39
- Attributes 07:54
- Types of Attributes 18:50
- Entity Type and Key Attribute 13:44
- Relationships 32:35
- Strong & Weak Entity and Notations 16:08
- COMPANY Example 15:20
- Dream Home Database Example 15:41
-
Lecture 4 pt.2: Enhanced Entity-Relationship Modeling (EER)
- EER 39:01
-
Lecture 5: The Relational Model
- Relational Model Concepts 32:22
- Relational Model Constraints and Relational DB Schemas 41:30
- Update Operations 12:23
- Exercise 08:14
- Step 1 and 2 (Mapping Entity, multi-value) 27:19
- Step 3. Mapping Weak Entity 07:36
- Step 4. Mapping Binary Relationships 31:44
- Step 5. Mapping Unary Relationships 21:05
- Step 6. Mapping N-ary Relationships 06:49
- Company Example Mapping 13:41
- Step 7. Mapping Super/sub Classes Relationship 31:02
- Extra Examples 18:26
-
Lecture 6: Normalization
- Introduction 17:17
- Functional Dependencies (FDs) 34:07
- UNF to 1NF 20:23
- 1NF to 2NF 13:32
- 2NF to 3NF 12:18
- Extra Examples 23:35
-
Lecture 7 pt.1: 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 pt.2: Data Manipulation in SQL
- INSERT INTO and SELECT Statements 26:39
- WHERE Clause 24:57
- UPDATE and DELETE Statements 13:18
- Extra Example 06:23
-
Lecture 7 pt.3: Advanced SQL Queries and View
- Aggregate Functions 38:46
- GROUP BY and HAVING 34:55
- Teacher’s Tutorial
-
Lab Previous Exams
- Evaluation 1 2021-2022
- Evaluation 1 2022-2023 36:04
- Eval 1 2023-2024 57:17
- Evaluation 1 - 2024 29:43
- Tutorials
-
Assignments
- Assignment 1 - 2026 20:58
- Assignment 2 - 2026 12:02
-
Previous Exams
- Mid 1 - 2024_2025 27:27
- Quiz 2021-2022 (1) 12:37
- Quiz 2021-2022 (2) 08:42
- Mid 1 - 2019/2020 30:51
- Mid 1 2021-2022 17:02
- Mid 2022-2023 27:08
- Quiz 2022 39:58
- Mid 1 2020-2021 23:31
- Mid 1 2023-2024 32:46
- Mid 2 2023-2024 33:53
- Quiz 2022-2023 28:45
- Quiz 2023-2024 06:10
- Teacher's Revision Mid 1 2023-2024 13:02
- Mid 1 Previous Exams 39:54
- Mid 2 | 2021-2022 {Normlization, SQL} (2) 37:55
- Mid 2 - 2021/2022 SQL 14:58
- Mid 2 SQL + Normalization 43:33
- Mid and Quiz SQL 28:20
- Summaries
- 'Fintech’ refers to the use of technology to facilitate financial services. To streamline and improve traditional financial services using technology.
-
-
Student feedback
5Course Rating
400 SAR
Lectures
86 Videos
Duration
26:39:13
Material
42 Files
Assignments
Yes, Completely
Labs
Yes, Completely
Project
Explanation, No implementation
Certificate
Not Applicable
Reviews (0)
Real reviews from real students.
No reviews yet.