4.92 average based on 13 ratings (more).
- 5 92%
- 4 8%
- 3 0%
- 2 0%
- 1 0%
Course content
Sections:
6
•
Activities:
25
•
Resources:
26
Section 1General
- Announcements
- SQL Editor
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
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.2: Installation of Required Software
- Lesson 2.3: Creating a Table and Inserting Data
- Creating a Table and Inserting Data (slides)
- Lesson 2.3: SQL Statements That Were Used in Practical Sessions
- Quiz - Lesson 2.3
- Unit 2 Practical Assignment
Section 4Unit 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
- Lesson 3.1: SQL Statements That Were Used in Practical Sessions
- 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
Section 5Unit 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
Section 6Course Summary and Final Evaluations
- Recap of Course Content
- Final Project Part 1
- Final Project Part 2
- Final Examination (batch 2)
Enrolment options
Database Management db_mgt_public_1
Course modified date: 31 Jul 2023
මෙම පාඨමාලාවේදී 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
සෑම ඒකකයකම ප්‍රායෝගික පැවරුම් (Assignments) සහ ප්‍රශ්නාවලි (quizzes) අඩංගු වේ.
අවසාන විභාගය සහ ව්‍යාපෘතිය සාර්ථකව අවසන් කිරීමෙන් පසු සහතිකයක් නිකුත් කෙරේ.
- Teacher: Uthpalani Kavisekara
- Enrolled students: 320