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.
B.Eng DegreeFaculty of Faculty of Engineering & TechnologySoftware Engineering
SWE 205: Database Systems & Relational Data Engineering
Theory and practice of relational database management systems (RDBMS). Relational algebra, SQL (DDL, DML, DQL), entity-relationship (ER) modeling, functional dependencies, schema normalization (1NF through BCNF), storage engines, B-tree indexing, que...
Course Overview
Theory and practice of relational database management systems (RDBMS). Relational algebra, SQL (DDL, DML, DQL), entity-relationship (ER) modeling, functional dependencies, schema normalization (1NF through BCNF), storage engines, B-tree indexing, que... Curriculum Structure &...
What You'll Learn
- Design normalized relational database schemas from complex enterprise domain models.
- Normalize relational tables up to Boyce-Codd Normal Form (BCNF) eliminating insertion, update, and deletion anomalies.
- Write complex SQL queries involving multi-table joins, subqueries, aggregations, and window functions.
- Analyze query execution plans (EXPLAIN) to identify index scans, sequential scans, and join bottlenecks.
- Implement concurrent database transactions adhering to ACID guarantees and appropriate isolation levels.
Requirements
- SWE 103
- SWE 107
Degree Programme Curriculum Context
This course is a curriculum unit of the Bachelor of Engineering (B.Eng.) in Software Engineering 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 Curriculum
Open-access academic curriculum. All foundational lectures available to read free.
8 Chapters
•0 Lecture
•0s
No curriculum found.
Academic Ecosystem & Connected Pathways
Deepen your studies across connected learning pathways in the PAMCET academic network:
Digital Research Library16,000+ open-access monographs & textbooks
Structured Learning PathsCurated multi-course career specializations
WAEC / SSCE Examination HubComplete secondary school syllabus & mock tests
JAMB / UTME PreparationComputer-based tests & scoring analytics
Tertiary & University Hub100L - 400L degree benchmark modules
Credential Verification PortalInstant cryptographic certificate authentication
Instructor
PAMCET Learning Team
Institutional Course Curation · PAMCET
Qualifications:
PAMCET Learning Team — Institutional Course Curation, Digitpen Hub LtdMy Skills:
- Curriculum Curation
- Course Content Review
- Learning Outcome Design
- Course Publishing & Quality Assurance
- Platform Content Operations
Reviews
No reviews available
Free
Course Includes
8 Chapters
0 Lectures
1 week
Skill Level beginner
Taught in English
Lifetime Access
Certification of Completion
Category: University - Software Engineering
Share On
Download Syllabus & Study Guide
Receive the full lecture syllabus, reading list, and milestone schedule for SWE 205: Database Systems & Relational Data Engineering.
By submitting, you agree to receive educational updates. You can unsubscribe anytime. Read our Privacy Policy.