DIU-BLC
Database Management System (Summer 20)
0%
Previous
PL/SQL Example and Stored Procedure
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
Next
DIU-BLC
Side panel
Guidelines
For Teachers
For Students
Search
Close
Search
Toggle search input
Log in
Username
Password
Remember username
Forgot Password?
Log in
Create new account
Course Overview
Sections
General
1
Announcements
Forum
Welcome to DBMS Class
Forum
Social forum
Course Summary and Objectives
2
OBE Course outline
File
Course Introduction
3
Welcome to the course!
File
Week 1
4
Introduction to Database Management System
File
Purpose of Database System
File
What have I Learned
Quiz
Relational Model in DBMS
File
Forum Discussion about pros and cons of Conventional File Processing System
Week 2
5
Level of Abstraction, Data Models, Database Languages
File
Dive Deep Into Relational Model
File
Week 3
6
DBMS, PC-B, New Class, (09-06-2020)
Lesson
Entity Relationship (ER) Model
File
Use LucidChart to implement your 10 Minutes Work
URL
10 Minutes Practice [Click Here]
URL
ER to Schema Mapping
File
ER to Schema Mapping (Video Lesson)
URL
Week 4
7
How to convert ER Diagram to Schema Diagram
Lesson
DBMS, PC-A, New Class, (14-06-2020)
Lesson
DBMS, PC-A, New Class, (15-06-2020)
Lesson
DBMS, PC-B, New Class, (14-06-2020)
Lesson
DBMS, PC-B, New Class, (16-06-2020)
Lesson
Week 5
8
Basic SQL
File
Basic SQL Practice
URL
DBMS, PC-A, New Class, (22-06-2020)
Lesson
DBMS, PC-B, New Class, (23-06-2020)
Lesson
Week 6
9
Like Operator
URL
SQL queries in Database
URL
50 SQl Query Practicer
Lesson
Subquery Understanding
Lesson
Discussion about SQL queries
Forum
DBMS, PC-A, New Class, (28-06-2020)
Lesson
DBMS, PC-A, New Class, (29-06-2020)
Lesson
DBMS, PC-B, New Class, (28-06-2020)
Lesson
DBMS, PC-B, New Class, (30-06-2020)
Lesson
Mid Term Week (Week 7)
10
Online Exam Response Submission Template
File
Online Exam Guideline
File
Week 8
11
More on Subqueries
File
Join Operation
File
Database Normalization
File
Database Normalization (Video Contents)
Lesson
Queries on Week 8
Forum
Week 9
12
Week 10
13
Stored Procedurer and Views
File
Introduction to PL/SQL
File
PL/SQL Example and Stored Procedure
File
Trigger, Rollback, Savepoint etc
File
Week 11 (Final Examination)
14
Exam Guidelines
File
Answer Script Template
File
Final Exam Question
File
Skip to main content
Database Management System (Summer 20)
Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Summer 20
CSE 311 (SMP-202)
Week 10
PL/SQL Example and Stored Procedure
PL/SQL Example and Stored Procedure
Mark as done
PL/SQL Example and Stored Procedure
Click
Lab 8 PL-SQL and Stored Procedure.zip
link to download the file.
Previous Activity
Jump to...
Jump to...
Announcements
Welcome to DBMS Class
Social forum
OBE Course outline
Welcome to the course!
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
Level of Abstraction, Data Models, Database Languages
Dive Deep Into Relational Model
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)
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)
Basic SQL
Basic SQL Practice
DBMS, PC-A, New Class, (22-06-2020)
DBMS, PC-B, New Class, (23-06-2020)
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)
Online Exam Response Submission Template
Online Exam Guideline
More on Subqueries
Join Operation
Database Normalization
Database Normalization (Video Contents)
Queries on Week 8
Stored Procedurer and Views
Introduction to PL/SQL
Trigger, Rollback, Savepoint etc
Exam Guidelines
Answer Script Template
Final Exam Question
Next Activity