Course: Database Management System (Summer 20), Section: Week 9

11. Week 9
- Quiz-2, PC-A
  
  Restricted Not available unless: You belong to PC-A
- Quiz-2, PC-B
  
  Restricted Not available unless: You belong to PC-B
- DBMS, PC-B, New Class, (09-08-2020) Lesson
  
  Restricted Not available unless: You belong to PC-B
  DBMS, PC-B, New Class, (09-08-2020)
  https://drive.google.com/file/d/1HaZWa3pgSPINJ2_EpVMGfJCowYtyo0xE/view?usp=sharing
- DBMS, PC-A, New Class, (09-08-2020) Lesson
  
  Restricted Not available unless: You belong to PC-A
  DBMS, PC-A, New Class, (09-08-2020)
  https://drive.google.com/file/d/1YJ7ZlXu2elokvptJP5XVFjm1HXFjQkeI/view?usp=sharing
- DBMS, PC-A, New Class, (20-07-2020) Lesson
  
  Restricted Not available unless: You belong to PC-A
  DBMS, PC-A, New Class, (20-07-2020)
  https://drive.google.com/file/d/12Q45gqhqMAybhWzTtLcMHFUhR-OlGPjr/view?usp=sharing
- DBMS, PC-B, New Class, (21-07-2020) Lesson
  
  Restricted Not available unless: You belong to PC-B
  DBMS, PC-B, New Class, (21-07-2020)
  https://drive.google.com/file/d/1GjuOVwPGYQ9ZX5atiKqxZbWzaEa_xZOO/view?usp=sharing
General
Course Summary and Objectives
Course Introduction
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Mid Term Week (Week 7)
Week 8
Week 10
Week 11 (Final Examination)
Week 12
Week 13
Week 14

◄Week 8

Week 10►

General

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

11. Week 9

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

DBMS, PC-A, New Class, (09-08-2020)

DBMS, PC-A, New Class, (20-07-2020)

DBMS, PC-B, New Class, (21-07-2020)

General

Course Summary and Objectives

Course Introduction

Week 1

Week 2

Week 3

Week 4

Week 5