TRA211_CSE311: Class Discussion Slide-20

To operate the Blended Learning Center(BLC) at optimal level, maintenance will be performed every day at 8:30 AM and at 5:00 PM regularly which can take up to 30 minutes. Please consider scheduling your activity in the BLC platform accordingly.

Class Discussion Slide-20

Click https://drive.google.com/open?id=1kA_mdVYPihlzrWk2si2h1Z1tzdF3yHvg link to open resource.

General

.

Welcome to DBMS Class

Course Introduction

Course Summary and Objectives

OBE Course outline

Week 1 (Introduction to DBMS)

Class Discussion Slide-1

Class Discussion Slide-2

Class Discussion Slide-3

What have I Learned from this week [MCQ]

Week 2 (Data Model and Languages)

Class Discussion Slide-4

Class Discussion Slide-5

Class Discussion Slide-6

Self Assessment

Class Discussion Slide-7

Forum Discussion

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

Week 3 (ER to Schema Mapping)

Class Discussion Slide-8

Class Discussion Slide-9

ER to Schema Mapping (Video Lesson)

Five Minutes Practice

Forum Discussion

Week 4 (SQL Queries)

Class Discussion Slide-10

Self Assessment

Forum Discussion

Week 5 (Join Operation)

Class Discussion Slide-12

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Week 6 (Basic SQL Queries)

SQL queries in Database

Class Discussion Slide-13

Discussion about SQL queries

Week 7 (Operation and Functions)

Class Discussion Slide-14

Numeric Functions, Date &amp; Time Functions File

Review Lectures [Forum]

Midterm Week (Week 8)

Week 8 (Nested Queries)

Class Discussion Slide-15

Class Discussion Slide-16

Week 9 (Stored Procedure and Normalization)

Class Discussion Slide-17

Class Discussion Slide-18

Class Discussion [Forum]

Week 10 (Database Transaction)

Class Discussion Slide-19

Class Discussion Slide-20

Week 11 (Trigger in DBMS)

Class Discussion Slide

Week 12 (Final Exam Week)

Documents and Slides (Resource Pack)

Class Discussion Slide-20

Numeric Functions, Date & Time Functions File