Official government website of the Government of Kingdom of Saudi Arabia
Link to official Saudi websites end with edu.sa

All links to official educational websites in the Kingdom of Saudi Arabia end with sch.sa or edu.sa

Government websites use the HTTPS protocol for encryption and security.

Secure websites in the Kingdom of Saudi Arabia use the HTTPS protocol for encryption.

Registered with the Digital Government Authority under number:

20250417892
Main
UQU Programs
Computer Engineering and Networks

Data Engineering

CEN2901
3 hours English

Data Engineering

Data Engineering
CS2014 Data structures and Algorithms with C++
3 hours Two requisites
1 Introduction to Data Engineering and modern database systems: / The role of data engineering in the data lifecycle / Overview of data pipelines and workflows / Understanding the modern data ecosystem
2 Data Modeling and Database Design / Principles of data modeling / Relational database design and normalization / Entity-Relationship (ER) diagrams
3 SQL / Simple SQL DDL (Create/Modify tables, constraints), DML (Select, INSERT, UPDATE, DELTE, with and without predicates and aggregation) / Complex SQL queries (Joins and Groupby) and subqueries, / Data Indexing
4 Transactions, concurrency control, and ACID properties
5 Exploratory Data Analysis and Visualization: / Data analysis using Dataframes (Filtering, Join, Statistics, Groupby, Pivot). / Scatter plots, line plots, Histograms, bar charts, Categorical Distribution, Numerical Distributions
6 Introduction to NoSQL databases: / Key-Value stores, Document databases, Column-family stores, Graph databases, GIS
7 Introduction to Data Ingestion and ETL Processes / ETL vs. ELT methodologies / Tools for data ingestion (e.g., Apache Kafka, Apache Flume) / Data transformation, cleaning, and validation techniques
8 Data Storage Systems / Distributed file systems (e.g., HDFS) / Cloud storage solutions and object storage / Overview of Data partitioning, replication, and sharding techniques
9 Big Data Processing with Hadoop / Hadoop ecosystem components / MapReduce programming model
10 Big Data Processing with Spark / Apache Spark architecture / Resilient Distributed Datasets (RDDs) and DataFrames / Spark SQL and Spark Streaming basics / Hands-on exercises with Spark and Hadoop clusters
11 Performance Optimization and Scalability / Techniques for optimizing data storage and retrieval / Horizontal vs. vertical scaling of data systems / Monitoring, logging, and performance tuning
12 Data Security and Governance / Data privacy laws (GDPR, CCPA) and compliance / Encryption, authentication, and authorization mechanisms / Data governance frameworks and best practices
13 Lab work
1.1 Mapped to: K1

An ability to identify and explain the fundamental knowledge and comprehension of concepts in the domain of Data Engineering

Teaching Strategy One or more of the following strategies may be used: • Classroom lectures • PowerPoint slides • Reading assignments
Assessment Methods One or more of the following strategies may be used: • Written exams • Home assignments • Oral questions
1.2 Mapped to: K1

An ability to identify and explain the broad in-depth knowledge and comprehension of concepts, principles, theories, processes and methodologies in the domain of Data Engineering

Teaching Strategy One or more of the following strategies may be used: • Classroom lectures • PowerPoint slides • Reading assignments
Assessment Methods One or more of the following strategies may be used: • Written exams • Home assignments • Oral questions
2.1 Mapped to: S1 (S1 in ABET)

Cognitive Skills: An ability to identify, formulate, and solve problems in the domain Data Engineering

Teaching Strategy One or more of the following strategies may be used: Classroom lectures • PowerPoint slides • Reading assignments • Problem solving practice • Tutorials
Assessment Methods One or more of the following strategies may be used: • Written exams • Home assignments • Oral questions
2.2 Mapped to: S2 (S2 in ABET)

Cognitive Skills: an ability to apply engineering design to produce solutions in the domain of Data Engineering

Teaching Strategy One or more of the following strategies may be used: • Design activities through problem-based learning to meet one or both of the following factors: (1) public health, safety, welfare, (2) global, cultural, social, environmental, and economic factors • Design examples • Open-ended design tasks • Classroom lectures • PowerPoint slides • Reading assignments • Problem solving • Tutorials
Assessment Methods One or more of the following strategies may be used: • Design projects (design approaches and design outcomes) • Written exams • Home assignments
2.3 Mapped to: K1

An ability to identify and explain the broad in-depth knowledge and comprehension of concepts, principles, theories, processes and methodologies in the domain of Data Engineering

Teaching Strategy One or more of the following strategies may be used: • Classroom lectures • PowerPoint slides • Reading assignments
Assessment Methods One or more of the following strategies may be used: • Written exams • Home assignments • Oral questions
3.1 Mapped to: V3 (S5 in ABET)

Responsibility: an ability to function effectively in a team whose members together provide leadership, create a collaborative and inclusive environment, establish goals, plan tasks, and meet objective

Teaching Strategy One or more of the following strategies may be used: • Discussion on various aspects of teamwork such as: (1) how to establish goals, plan tasks, and meet objective (2) how the group shares responsibilities and makes decisions together to foster collaboration • Classroom lectures • PowerPoint slides
Assessment Methods One or more of the following strategies may be used: • Project breakdown structure • Minutes of meeting
Assessment
Weight
Lab work
25%
Quizzes
10%
Midterm exam
15%
Course Project (Group)
20%
Final Exam
30%
Total
100%