Skip to main content
Certificate DegreeFaculty of Faculty of Computing & Information TechnologyComputer Science

Database Fundamentals (Certificate CS)

Master Database Fundamentals (Certificate CS) in University - Computer Science with this structured course, covering 8 modules and practice assessments.

Instructor
Created by PAMCET Learning Team
beginner1 weekEnglish

Course Overview

Master Database Fundamentals (Certificate CS) in University - Computer Science with this structured course, covering 8 modules and practice assessments. Curriculum Structure & Core Modules: • 1. Foundational Database Concepts, File Systems vs. DBMS & Architecture • 2....

What You'll Learn

  • Understand and apply the principles of What Is a Database
  • Work confidently through Tables, Rows and Columns and its practical applications
  • Analyse real-world scenarios involving Introduction to Spreadsheet-Style Databases
  • Develop applied skills in Basic Data Entry and Retrieval
  • Critically evaluate approaches to Introduction to SQL Queries

Requirements

  • No prior University - Computer Science knowledge required — this course starts from the fundamentals
  • A computer, tablet or smartphone with a stable internet connection
  • Willingness to commit regular study time to complete lessons, quizzes and assignments

Degree Programme Curriculum Context

This course is a curriculum unit of the Certificate in Computer Science degree framework in Nigeria.

Earn Your Certificate

Showcase your skills with a certificate! Complete the course, submit your project, and earn your certificate. Here's a sample of what you'll receive to show off your accomplishments.

course-certificate
Lecture Board & Syllabus

Course Curriculum

Browse complete theoretical foundations, worked calculations, laboratory protocols, and board assessment questions under each topic.

Launch Course Reader →
8 Chapters
•
24 Lecture
•
0s
Subtopic 1Document Lecture

Data vs Information, Limitations of Flat-File Systems & DBMS Architecture

Sign in or enroll to access the full lecture notes and interactive reader.

Module 1 • Subtopic 1
Subtopic 2Document Lecture

Physical vs Logical Data Independence & Enterprise DBMS Taxonomy

Sign in or enroll to access the full lecture notes and interactive reader.

Module 1 • Subtopic 2
Subtopic 3Document Lecture

Database Roles: End-Users, Application Developers & Database Administrators

Sign in or enroll to access the full lecture notes and interactive reader.

Module 1 • Subtopic 3
Subtopic 1Document Lecture

Relational Theory: Relations, Tuples, Attributes & Domains

Sign in or enroll to access the full lecture notes and interactive reader.

Module 2 • Subtopic 1
Subtopic 2Document Lecture

Key Constraints: Superkeys, Candidate Keys, Primary Keys & Foreign Keys

Sign in or enroll to access the full lecture notes and interactive reader.

Module 2 • Subtopic 2
Subtopic 3Document Lecture

Integrity Rules: Entity Integrity, Referential Integrity & Domain Integrity

Sign in or enroll to access the full lecture notes and interactive reader.

Module 2 • Subtopic 3
Subtopic 1Document Lecture

ER Modeling Fundamentals: Entities, Attributes & Relationships

Sign in or enroll to access the full lecture notes and interactive reader.

Module 3 • Subtopic 1
Subtopic 2Document Lecture

Cardinality Ratios, Participation Constraints & Enhanced ER (EER)

Sign in or enroll to access the full lecture notes and interactive reader.

Module 3 • Subtopic 2
Subtopic 3Document Lecture

Logical Schema Mapping: Transforming ER Diagrams into Relational Tables

Sign in or enroll to access the full lecture notes and interactive reader.

Module 3 • Subtopic 3
Subtopic 1Document Lecture

Functional Dependencies, Anomalies & Decomposition Principles

Sign in or enroll to access the full lecture notes and interactive reader.

Module 4 • Subtopic 1
Formative Assessment10 Points • 15 Mins

Mid-Course Progress Assessment

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Test your knowledge of Basic Data Entry and Retrieval

Module 4 • Formative Assessment
Subtopic 3Document Lecture

First Normal Form (1NF), Second Normal Form (2NF) & Third Normal Form (3NF)

Sign in or enroll to access the full lecture notes and interactive reader.

Module 4 • Subtopic 3
Subtopic 4Document Lecture

Boyce-Codd Normal Form (BCNF) & Practical Trade-offs: Denormalization

Sign in or enroll to access the full lecture notes and interactive reader.

Module 4 • Subtopic 4
Subtopic 1Document Lecture

SQL Data Definition Language (DDL): Statements & Constraint Syntax

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 1
Subtopic 2Document Lecture

SQL Data Types: Character, Numeric, Temporal, Boolean & BLOBs

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 2
Subtopic 3Document Lecture

Schema Constraints in SQL: PRIMARY, FOREIGN KEY, UNIQUE, CHECK & DEFAULT

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 3
Subtopic 4Open Access~3 min read

Mid-Semester Case Study & Research Paper

Sign in or enroll to access the full lecture notes and interactive reader.

Module 5 • Subtopic 4•126 characters of authentic academic content
Subtopic 1Document Lecture

SQL Data Manipulation Language (DML): Statements & Transactional Integrity

Sign in or enroll to access the full lecture notes and interactive reader.

Module 6 • Subtopic 1
Subtopic 2Document Lecture

Basic & Advanced Querying: SELECT, FROM, WHERE, ORDER BY & Patterns

Sign in or enroll to access the full lecture notes and interactive reader.

Module 6 • Subtopic 2
Subtopic 3Document Lecture

Aggregate Functions, Grouping & Filtering: COUNT, SUM, GROUP BY & HAVING

Sign in or enroll to access the full lecture notes and interactive reader.

Module 6 • Subtopic 3
Subtopic 1Document Lecture

Relational Joins: INNER, LEFT, RIGHT, FULL OUTER & CROSS Joins

Sign in or enroll to access the full lecture notes and interactive reader.

Module 7 • Subtopic 1
Subtopic 2Document Lecture

Subqueries & Nested Queries: Scalar, Correlated & IN/EXISTS Operators

Sign in or enroll to access the full lecture notes and interactive reader.

Module 7 • Subtopic 2
Subtopic 3Document Lecture

Relational Views: Creating, Querying & Managing Virtual Tables

Sign in or enroll to access the full lecture notes and interactive reader.

Module 7 • Subtopic 3
Subtopic 1Document Lecture

Transaction Processing & ACID Properties: Atomicity, Isolation & Durability

Sign in or enroll to access the full lecture notes and interactive reader.

Module 8 • Subtopic 1
Formative Assessment10 Points • 15 Mins

Comprehensive End-of-Course Examination

Assessment Protocol:10 Total Points•70% Passing Threshold•15 Mins Time Limit•Bloom's Taxonomy: Analyze & Evaluate

Test your knowledge of Database Security Awareness

Module 8 • Formative Assessment
Subtopic 3Document Lecture

Database Storage & Indexing Fundamentals: B-Trees, Clustered vs Non-Clustered

Sign in or enroll to access the full lecture notes and interactive reader.

Module 8 • Subtopic 3
Subtopic 4Document Lecture

Database Security, Access Control (GRANT/REVOKE), Backup & Recovery

Sign in or enroll to access the full lecture notes and interactive reader.

Module 8 • Subtopic 4

Instructor

PAMCET Learning Team

PAMCET Learning Team

Institutional Course Curation · PAMCET

The PAMCET Learning Team is the institutional curriculum and content group behind course publishing on this platform. PAMCET (Professional and Academic Management Centre for Education and Training) is operated by Digitpen Hub Ltd, a company registered in Lagos, Nigeria. Courses credited to the PAMCET Learning Team are structured, organized, and published centrally by the platform rather than authored by a single named individual instructor — each course's syllabus, learning outcomes, and content are reviewed before publication under this institutional account. For questions about a specific course or to report a content issue, please use the platform's Help & Support or Contact Us pages.

Qualifications:

PAMCET Learning Team — Institutional Course Curation, Digitpen Hub Ltd

My Skills:

  • Curriculum Curation
  • Course Content Review
  • Learning Outcome Design
  • Course Publishing & Quality Assurance
  • Platform Content Operations

Reviews

No reviews available
Database Fundamentals (Certificate CS)
Free$12.99100% Off
Certificate available separately for $7 after completion

Course Includes

8 Chapters
24 Lectures
1 week
Skill Level beginner
Taught in English
Lifetime Access
Certification of Completion
Category: University - Computer Science
Share On

Download Syllabus & Study Guide

Receive the full lecture syllabus, reading list, and milestone schedule for Database Fundamentals (Certificate CS).

By submitting, you agree to receive educational updates. You can unsubscribe anytime. Read our Privacy Policy.