Course: Database Management System (Summer 20)

CSE Summer 20

Database Management System (Summer 20)

Mohammad Jahangir Alam

Mubtasim Fuad

SP Saif Mahmud Parvez

0% complete

0% complete
Resume

Introduction

Show More Show Less
- Announcements Forum
- Welcome to DBMS Class Forum
  
  Dear Students,
- Social forum
Show More

Course Summary and Objectives

Go to section Course Summary and Objectives
Course Introduction

Go to section Course Introduction
Week 1

Go to section Week 1
Week 2
Highlighted

Go to section Week 2
Week 3

Go to section Week 3
Week 4

Go to section Week 4
Week 5

Go to section Week 5
Week 6

Go to section Week 6
Mid Term Week (Week 7)

Go to section Mid Term Week (Week 7)
Week 8

Go to section Week 8
Week 9

Go to section Week 9
Week 10

Go to section Week 10
Week 11 (Final Examination)

Go to section Week 11 (Final Examination)
Week 12
Not available

Go to section Week 12
Week 13
Not available

Go to section Week 13
Week 14
Not available

Go to section Week 14

Introduction

Announcements

Welcome to DBMS Class

Social forum

Course Summary and Objectives

OBE Course outline

Course Introduction

Welcome to the course!

Week 1

Introduction to Database Management System

Purpose of Database System

What have I Learned

Relational Model in DBMS

Forum Discussion about pros and cons of Conventional File Processing System

Week 2

Level of Abstraction, Data Models, Database Languages

Dive Deep Into Relational Model

Week 3

DBMS, PC-B, New Class, (09-06-2020)

Entity Relationship (ER) Model

Use LucidChart to implement your 10 Minutes Work

10 Minutes Practice [Click Here]

ER to Schema Mapping

ER to Schema Mapping (Video Lesson)

Week 4

How to convert ER Diagram to Schema Diagram

DBMS, PC-A, New Class, (14-06-2020)

DBMS, PC-A, New Class, (15-06-2020)

DBMS, PC-B, New Class, (14-06-2020)

DBMS, PC-B, New Class, (16-06-2020)

Week 5

Basic SQL

Basic SQL Practice

DBMS, PC-A, New Class, (22-06-2020)

DBMS, PC-B, New Class, (23-06-2020)

Week 6

Like Operator

SQL queries in Database

50 SQl Query Practicer

Subquery Understanding

Discussion about SQL queries

DBMS, PC-A, New Class, (28-06-2020)

DBMS, PC-A, New Class, (29-06-2020)

DBMS, PC-B, New Class, (28-06-2020)

DBMS, PC-B, New Class, (30-06-2020)

Mid Term Week (Week 7)

Online Exam Response Submission Template

Online Exam Guideline

Week 8

More on Subqueries

Join Operation

Database Normalization

Database Normalization (Video Contents)

Queries on Week 8

Week 9

Week 10

Stored Procedurer and Views

Introduction to PL/SQL

PL/SQL Example and Stored Procedure

Trigger, Rollback, Savepoint etc

Week 11 (Final Examination)

Exam Guidelines

Answer Script Template

Final Exam Question

Week 12

Week 13

Week 14

Introduction

Week 2 Highlighted

Week 12 Not available

Week 13 Not available

Week 14 Not available

Week 2
Highlighted

Week 12
Not available

Week 13
Not available

Week 14
Not available