Course Overview:

This course offers foundational knowledge in database systems, emphasizing data nature, storage, and management techniques. It systematically introduces database architecture, procedural language use, and the intricacies of relational data models. The focus extends to constructing and executing various query formats, including DML, DDL, and TCS. Additionally, the course delves into advanced topics like creating database structures through normalization, applying SQL/PL, and understanding SQL concepts. It addresses query processing, transaction management, deadlock strategies, and database security. On completion, the students will be to demonstrate comprehension of the material covered in the course.

Prerequisite:

  • The students must have completed grade 12 or equivalent education.
  • Students from non-English speaking countries must pass the English Language Proficiency Test.
  • English Language Proficiency Test scores (IELTS – 6.0, TOEFL – 70, PTE – 45, CAEL – 70, CAE – 176, Duolingo – 110, Password – 6.5, and PTE – 61) are acceptable. 

Learning Outcomes:

  • Comprehend relational data models in terms of data structure, data integrity, and data manipulation.
  • Demonstrate the capability to create conceptual database models using entity-relationship diagrams.
  • Design data structures that minimize redundancy enforce data integrity and meet organizational requirements through the application of normalization methodology.
  • Utilize data models to effectively query databases and convert data into valuation information using SQL (Structured Query Language).
  • Implement the data model within a contemporary Relational Database Management System (RDBMS).
  • Generate reports based on transactional data, including data groupings and summary values, to facilitate data analysis and decision-making processes.

Course Content & Topics:

Class 1: Introduction to Data Bases
Class 2: Database System Architecture
Class 3: Data Models
Class 4: Database Design & ER-Diagram
Class 5: Enhance ER Modeling
Class 6: Normalization
Class 7: Introduction to SQL
Class 8: Relational Database Design
Class 9: Relational Algebra and Calculus
Class 10: Intermediate SQL
Class 11: Advanced SQL
Class 12: Transaction Management
Class 13: Advance Topic in Database Management System

Final Exam: MCQs and a case study project

Credit Information:

  • Credits: 3

Duration:

  • 14 Weeks: 3 hrs/week

Course & Related Fees:

  • Domestic Students : $650 (Six hundred and fifty dollars)
  • International Students: $750 (Seven hundred and fifty dollars)

For a detailed breakdown, please refer to Policy #S-005A Cyber Security Diploma and Course Fee Schedule

Non-Refundable Fees:

  • Application Fee: $50.00/course (payable online and non-refundable)