Section: Week 10 | Database Management System (Summer 20)

Week 10

Week 9

Week 11 (Final ...

Select activity Stored Procedurer and Views

Stored Procedurer and Views File
Select activity Introduction to PL/SQL

Introduction to PL/SQL File

Students must

Mark as done

Introduction to PL/SQL
Select activity PL/SQL Example and Stored Procedure

PL/SQL Example and Stored Procedure File

Students must

Mark as done

PL/SQL Example and Stored Procedure
Select activity Trigger, Rollback, Savepoint etc

Trigger, Rollback, Savepoint etc File

Students must

Mark as done

Trigger, Rollback, Savepoint etc
Select activity DBMS, 3rd Quiz, PC-A

DBMS, 3rd Quiz, PC-A Assignment

Not available unless: You belong to PC-A
Select activity DBMS, 3rd Quiz, PC-B

DBMS, 3rd Quiz, PC-B Assignment

Not available unless: You belong to PC-B
Select activity DBMS, PC-A, New Class, (09-08-2020)
DBMS, PC-A, New Class, (09-08-2020) Lesson
DBMS, PC-A, New Class, (09-08-2020)
https://drive.google.com/file/d/1YJ7ZlXu2elokvptJP5XVFjm1HXFjQkeI/view?usp=sharing
Not available unless: You belong to PC-A
Select activity DBMS, PC-B, New Class, (09-08-2020)
DBMS, PC-B, New Class, (09-08-2020) Lesson
DBMS, PC-B, New Class, (09-08-2020)
https://drive.google.com/file/d/1HaZWa3pgSPINJ2_EpVMGfJCowYtyo0xE/view?usp=sharing
Not available unless: You belong to PC-B
Select activity DBMS, PC-A, New Class, (16-08-2020)
DBMS, PC-A, New Class, (16-08-2020) Lesson
DBMS, PC-A, New Class, (16-08-2020)
https://drive.google.com/file/d/1mDnLgTv0D9Fwj4pYM-jKlEZKgFWVkjQM/view?usp=sharing
Not available unless: You belong to PC-A
Select activity DBMS, PC-B, New Class, (16-08-2020)
DBMS, PC-B, New Class, (16-08-2020) Lesson
DBMS, PC-B, New Class, (16-08-2020)
https://drive.google.com/file/d/1l6uxEw8f5xliSDAcVrsUQ-YmwoaAp8I4/view?usp=sharing
Not available unless: You belong to PC-B
Select activity DBMS, PC-A, New Class, 17-08-2020
DBMS, PC-A, New Class, 17-08-2020 Lesson
DBMS, PC-A, New Class, 17-08-2020
https://drive.google.com/file/d/1DkQwgPBLMfYxrUM7qdq73LAkrMJ_Tios/view?usp=sharing
Not available unless: You belong to PC-A

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

Week 10

Introduction to PL/SQL

PL/SQL Example and Stored Procedure

Trigger, Rollback, Savepoint etc

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

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

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

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

DBMS, PC-A, New Class, 17-08-2020

Introduction

Course Summary and Objectives

Course Introduction

Week 1