Course content
Sections:
6
•
Activities:
23
•
Resources:
27
Section 1General
- General news and announcements
- Course Video Lessons
- Any difficulty in completing the course? Post here
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 Examination
Enrolment options
Database Management ToT Session DB Management ToT_1
Course modified date: 23 May 2023
- Teacher: Uthpalani Kavisekara
- Enrolled students: 40
Guests cannot access this course. Please log in.