Other

Mahapola Ports & Maritime Academy - Course On Advanced Database Management Systems

Course Overview


To provide advanced knowledge and develop competencies on RDBMS activities with Multi-user and Single-user DBMS applications.


CONTENTS

  • Introduction to the Data Base Management Systems
  • Discuss the drawbacks of File Base vs Data Base Management Systems
  • Introduction to Relational Data Base Management Systems
  • Design and Develop Data Bases with Entity Relationship Diagram (ER)
  • Design and Develop Data Bases with Normalization
  • Develop Databases with Single-user Application (Microsoft Office Access)
  • Discuss other Objects and features of Single-user DBMS
  • Develop Databases with Multi-user User Application (My SQL)
  • Discuss the features of SQL statements
  • Develop SQL statements for Create, Insert, Delete, Update events


METHODOLOGY

All the sessions will be lectured followed by the practicals, discussions, assignments, case studies and individual evaluation


Duration

14 Sessions in 14 Days

Category

Other

Course Level

Other

Related Courses

Physical
ETMA Campus

RHEL – Redhat Enterprise Linux

RHEL – Redhat Enterprise Linux

clock-img

Duration

2 Months

Medium

English

Physical
Horizon Campus

BSc (Hons) QS (Top-Up)

BSc (Hons) QS (Top-Up)

clock-img

Duration

1 year

Medium

English

Physical
SDTI Campus

Doctor of Information Technology

Doctor of Information Technology

clock-img

Duration

03 Year

Medium

English

Physical
Institute of Human Resource Advancement - University of Colombo

Institute of Human Resource Advancement - University of Colombo - Certificate Course in Sports Science Management (CCSM)

Institute of Human Resource Advancement - University of Colombo - Certificate Course in Sports Science Management (CCSM)

clock-img

Duration

Medium

English

Physical
Sri Lanka Institute of Development Administration

Diploma in Regional Development Administration

Diploma in Regional Development Administration

clock-img

Duration

Medium

English

Physical
CICRA Campus (Pvt) Ltd

Bachelor of Cyber Security Pathway Programme - Deakin University, Australia

Bachelor of Cyber Security Pathway Programme - Deakin University, Australia

clock-img

Duration

Medium

English

Ask from Mahapola Ports & Maritime Academy