Course content
Sections:
8
•
Activities:
33
•
Resources:
29
Section 1General
- Announcements
- Student Details Form
Section 2Unit 1: Introduction to Database and DBMS
- Lesson 1.1: Introduction to Database
- Introduction to Database (slides)
- Quiz - Lesson 1.1
- Lesson 1.2: Introduction to DBMS and Relational Data Model
- DBMS and Relational Data Model (slides)
- Quiz - Lesson 1.2
- Unit 1 Final Assignment
- Unit 1 Final Assignment - Submission Confirmation
Section 3Unit 2: SQL Statements to Create Table and Insert Data
- Lesson 2.1: Introduction to SQL and MySQL
- Introduction to SQL and MySQL (slides)
- Quiz - Lesson 2.1
- Lesson 2.3: Creating a Table and Inserting Data
- Creating a Table and Inserting Data (slides)
- Quiz - Lesson 2.3
- Unit 2 Practical Assignment
- Unit 2 Practical Assignment - Submission Confirmation
Section 4Additional References (Database Design Concepts)
- Lesson 1: Introduction to Database Conceptual Modeling
- Lesson 2: Let's Draw an ER Diagram for a Mini Scenario!
- Lesson 3: Let's Design an ER Diagrams to a Practical Scenario
Section 5Unit 3: Basic Query Formulation with SQL SELECT Query
- Lesson 3.1: Retrieving Data from a Table
- Retrieving Data from a Table (slides)
- SQL Dump File for tbl_students Table
- Guideline on Importing SQL Dump File Using PHPMyAdmin
- Quiz - Lesson 3.1
- Practical Assignment 3.1
- Lesson 3.2: Retrieving Data Based on Conditions
- Retrieving Data Based on Conditions (slides)
- Quiz - Lesson 3.2
- Practical Assignment 3.2
- Lesson 3.3: Sorting the SELECT Query Result
- Sorting the SELECT Query Result (slides)
- Quiz - Lesson 3.3
- Practical Assignment 3.3
- Lesson 3.4: Select Query with Aggregate Functions
- Select Query with Aggregate Functions (slides)
- Quiz - Lesson 3.4
- Practical Assignment 3.4
- Unit 3 Final Assignment
- Unit 3 Final Assignment - Submission Confirmation
Section 6Unit 4: Update Data or Deleting a Record Using SQL Statements
- Lesson 4.1: Updating Data in a Table
- Updating Data in a Table (slides)
- Quiz - Lesson 4.1
- Practical Assignment 4.1
- Lesson 4.2: Deleting a Record from a Table
- Deleting a Record from a Table (slides)
- Quiz - Lesson 4.2
- Practical Assignment 4.2
- Unit 4 Final Assignment
- Unit 4 Final Assignment - Submission Confirmation
Section 7Additional References (Databse Normalization & SQL Joins)
- Introduction to Database Normalization
- Normalization explained with example
- SQL Joins (INNER, LEFT & RIGHT)
- SQL Dump File for db_emp Database
Section 8Course Summary and Final Evaluations
- Final Project - Part 1
- Final Project - Part 2
- Final Examination
- Final Evaluations - Submission Confirmation
- Post Course Evaluation Form
- Printed Certificate Request Form
- Certificate of Completion - Database Management
Enrolment options
Database Management - Self Paced Database self
Course modified date: 16 Feb 2026
- Teacher: Uthpalani Kavisekara
- Enrolled students: 52
This course includes
Assignments
Custom certificates
Feedback
Forums
Quizzes
Resources