Course content
- Announcements
- Student Details Form ???
- 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
- 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
- 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
- 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
- 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
- Introduction to Database Normalization
- Normalization explained with example
- SQL Joins (INNER, LEFT & RIGHT)
- SQL Dump File for db_emp Database
- 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 Systems & SQL
Enrolment options
මෙම පාඨමාලාවේදී Database Management (දත්ත සමුදා කළමනාකරණය) පිළිබඳ මූලික කරුණු හඳුන්වා දෙනු ඇත.
සහභාගී විය හැකි අය : Database පිළිබඳ මූලික කරුණු දැනගැනීමට සහ SQL පිළිබඳ මූලික අවබෝධයක් (ප්රායෝගික ක්රියාකාරකම් හරහා) ලබාගැනීමට උනන්දුවක් දක්වන ඕනෑම අයෙක්ට.
භාෂාව : සිංහල
පාඨමාලා කාලය : online ඉගෙනුම් පැය 7 (සති හයක් ඇතුළත සම්පූර්ණ කිරීමට සැලසුම් කර ඇත)
පාඨමාලා අන්තර්ගතය :
Unit 1: Introduction to Database and DBMS
Unit 2: SQL Statements to Create Table and Insert Data
Unit 3: Basic query formulation with SQL SELECT Query
Unit 4: Update data or delete a record using SQL statements
Final project and Exam
සෑම ඒකකයකම ප්රායෝගික පැවරුම් (Assignments) සහ ප්රශ්නාවලි (quizzes) අඩංගු වන අතර අවසාන විභාගය සහ ව්යාපෘතිය සාර්ථකව අවසන් කිරීමෙන් පසු සහතිකයක් නිකුත් කෙරේ.