The Database Management Systems (DBMS) course provides an in-depth understanding of how data is stored, organized, managed, and retrieved efficiently. It introduces students to the fundamental principles and technologies used to design and implement modern database systems. The course emphasizes the importance of databases in real-world applications and equips students with practical skills in data modeling, relational database design, SQL querying, and database system architectures.
Learning Outcomes:
By the end of this course, students will be able to:
-
Explain the concepts, architecture, and functions of DBMS.
-
Design ER diagrams and convert them into relational schemas.
-
Formulate complex SQL queries and apply normalization techniques.
-
Understand transaction processing, concurrency control, and database recovery.
-
Discuss emerging trends in database technologies, including NoSQL and distributed databases.
Build an understanding of the fundamental concepts of computer networking.
Understand the concepts of IPV4 and IPV6.
Distinguish the different methods of error detection and correction.
Understand the audio and video compression, streaming stored audio and video
Understand the concepts of cryptography and its different methods.
This course covers fundamental concepts in computer
programming, including algorithms, flowcharts,
programming languages, control flow structures, arrays,
and functions, emphasizing practical implementation
through a series of hands-on exercises. Students will gain
proficiency in solving problems using the C programming
language..
This course introduces the core principles and techniques for Data structures.