DIU-BLC
Database Management System (Summer 20)
0%
Previous
Discussion about SQL queries
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 6
Discussion about SQL queries
Search forums
Search forums
Discussion about SQL queries
View
List of discussions. Showing 32 of 32 discussions
Status
Discussion
Started by
Last post
Replies
Actions
How a SQL query can be complicated?
Locked
Saif Mahmud Parvez
30 Jun 2020
Omar Faruk (181-15-2026)
8 Jul 2020
2
Complicated SQL Query
Locked
Sazedur Rahman
18 Aug 2020
Sazedur Rahman
18 Aug 2020
0
What is the difference between ''Where'' and ''Having'' clause?
Locked
Arup Ratan Nag
10 Jul 2020
Arup Ratan Nag
10 Jul 2020
0
How a SQL query can be complicated?
Locked
Arup Ratan Nag
10 Jul 2020
Arup Ratan Nag
10 Jul 2020
0
How a SQL query can be complicated?
Locked
Sohag Raha
12 Aug 2020
Sohag Raha
12 Aug 2020
0
Discussion about SQL queries
Locked
Abdulla all shaykat
13 Aug 2020
Abdulla all shaykat
13 Aug 2020
0
discuss on the Insert statement syntax
Locked
Mohammad Abdullah 181-15-2051
16 Aug 2020
Mohammad Abdullah 181-15-2051
16 Aug 2020
0
Discussion about SQL queries
Locked
Adnan Pranto
17 Aug 2020
Adnan Pranto
17 Aug 2020
0
How a SQL query can be complicate.
Locked
Ashraf Mahmud 181-15-2033
17 Aug 2020
Ashraf Mahmud 181-15-2033
17 Aug 2020
0
SQL query
Locked
Arifur Rahaman
18 Aug 2020
Arifur Rahaman
18 Aug 2020
0
How a SQL query can be complicated?
Locked
Jannatul Moua
10 Jul 2020
Jannatul Moua
10 Jul 2020
0
Discussion on Complicated SQL Query
Locked
Najua Ferdush Mim
18 Aug 2020
Najua Ferdush Mim
18 Aug 2020
0
How a SQL query can be complicate.
Locked
Mehedi hasan Munna
18 Aug 2020
Mehedi hasan Munna
18 Aug 2020
0
How a SQL query can be complicated?
Locked
S.M. Safat Manzur Durjay(181 - 15 - 1758)
21 Aug 2020
S.M. Safat Manzur Durjay(181 - 15 - 1758)
21 Aug 2020
0
How a SQL query can be complicate
Locked
rishadun noor
22 Aug 2020
rishadun noor
22 Aug 2020
0
Difference between Where and Having clause
Locked
Md. Ashraful Alam Akif
22 Aug 2020
Md. Ashraful Alam Akif
22 Aug 2020
0
Difference
Locked
Mizanur Rahman
27 Aug 2020
Mizanur Rahman
27 Aug 2020
0
Q. What is the difference between 'Where' and 'Having 'clause?
Locked
Abu Rashed Khan
28 Jun 2020
Abu Rashed Khan
28 Jun 2020
0
How a sql query can be complicated ?
Locked
Nasrin Borsha
7 Jul 2020
Nasrin Borsha
7 Jul 2020
0
How a SQL query can be complicated?
Locked
Tahmina Akter Urme
1 Jul 2020
Tahmina Akter Urme
1 Jul 2020
0
How a SQL query can be complicated?
Locked
Shamiha Smriti
1 Jul 2020
Shamiha Smriti
1 Jul 2020
0
How a SQL query can be complicated?
Locked
Md. Billal Hossen
1 Jul 2020
Md. Billal Hossen
1 Jul 2020
0
Difference between WHERE and HAVING
Locked
Sazid Karim
1 Jul 2020
Sazid Karim
1 Jul 2020
0
How a SQL query can be complicated?
Locked
Sazid Karim
1 Jul 2020
Sazid Karim
1 Jul 2020
0
How a SQL query can be complicated?
Locked
Fahmida Akter
30 Jun 2020
Fahmida Akter
30 Jun 2020
0
How a sql query can be complicated?
Locked
Md. Nahid
30 Jun 2020
Md. Nahid
30 Jun 2020
0
How a sql query can be complicated?
Locked
Meherab Hossain
30 Jun 2020
Meherab Hossain
30 Jun 2020
0
How a sql query can be complicated?
Locked
Ashrak Shohas
30 Jun 2020
Ashrak Shohas
30 Jun 2020
0
Difference between Where and Having clause .
Locked
Ashrak Shohas
30 Jun 2020
Ashrak Shohas
30 Jun 2020
0
What is the difference between 'Where' and 'Having 'clause?
Locked
Palash Mandal
29 Jun 2020
Palash Mandal
29 Jun 2020
0
Differencebetween where and having clause
Locked
Md.Tahsan Hossain
28 Jun 2020
Md.Tahsan Hossain
28 Jun 2020
0
Difference between WHERE and HAVING :
Locked
Adnan Pranto
28 Jun 2020
Adnan Pranto
28 Jun 2020
0
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
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
PL/SQL Example and Stored Procedure
Trigger, Rollback, Savepoint etc
Exam Guidelines
Answer Script Template
Final Exam Question
Next Activity