DIU-BLC
Database Management System (Spring 21)
0%
Previous
SQL queries in Database
General
.
Welcome to DBMS Class
Course Introduction
Course Summary and Objectives
OBE Course outline
Week 1 (Introduction to DBMS)
Class Discussion Slide-1
Class Discussion Slide-2
Class Discussion Slide-3
What have I Learned from this week [MCQ]
Week 2 (Data Model and Languages)
Class Discussion Slide-4
Class Discussion Slide-5
Class Discussion Slide-6
Self Assessment
Class Discussion Slide-7
Forum Discussion
10 Minutes Practice [Click Here]
Use LucidChart to implement your 10 Minutes Work
Week 3 (ER to Schema Mapping)
Class Discussion Slide-8
Class Discussion Slide-9
ER to Schema Mapping (Video Lesson)
Five Minutes Practice
Forum Discussion
Week 4 (SQL Queries)
Class Discussion Slide-10
Self Assessment
Forum Discussion
Week 5 (Join Operation)
Class Discussion Slide-12
Database Join Operation with Example
SQL Join 10 Minutes Practice
Discussion regarding SQL Join Operation
Week 6 (Basic SQL Queries)
SQL queries in Database
Class Discussion Slide-13
Discussion about SQL queries
Week 7 (Operation and Functions)
Class Discussion Slide-14
Numeric Functions, Date & Time Functions File
Review Lectures [Forum]
Midterm Week (Week 8)
Week 8 (Nested Queries)
Class Discussion Slide-15
Class Discussion Slide-16
Week 9 (Stored Procedure and Normalization)
Class Discussion Slide-17
Class Discussion Slide-18
Class Discussion [Forum]
Week 10 (Database Transaction)
Class Discussion Slide-19
Class Discussion Slide-20
Week 11 (Trigger in DBMS)
Class Discussion Slide
Week 12 (Final Exam Week)
Documents and Slides (Resource Pack)
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
.
Forum
Welcome to DBMS Class
Forum
Course Introduction
2
Course Summary and Objectives
3
OBE Course outline
File
Week 1 (Introduction to DBMS)
4
Class Discussion Slide-1
URL
Class Discussion Slide-2
URL
Class Discussion Slide-3
URL
What have I Learned from this week [MCQ]
Quiz
Week 2 (Data Model and Languages)
5
Class Discussion Slide-4
URL
Class Discussion Slide-5
URL
Class Discussion Slide-6
URL
Self Assessment
URL
Class Discussion Slide-7
URL
Forum Discussion
10 Minutes Practice [Click Here]
URL
Use LucidChart to implement your 10 Minutes Work
URL
Week 3 (ER to Schema Mapping)
6
Class Discussion Slide-8
URL
Class Discussion Slide-9
URL
ER to Schema Mapping (Video Lesson)
URL
Five Minutes Practice
File
Forum Discussion
Week 4 (SQL Queries)
7
Class Discussion Slide-10
URL
Self Assessment
URL
Forum Discussion
Week 5 (Join Operation)
8
Class Discussion Slide-12
URL
Database Join Operation with Example
URL
SQL Join 10 Minutes Practice
Quiz
Discussion regarding SQL Join Operation
Forum
Week 6 (Basic SQL Queries)
9
SQL queries in Database
URL
Class Discussion Slide-13
URL
Discussion about SQL queries
Forum
Week 7 (Operation and Functions)
10
Class Discussion Slide-14
URL
Numeric Functions, Date & Time Functions File
URL
Review Lectures [Forum]
Midterm Week (Week 8)
11
Week 8 (Nested Queries)
12
Class Discussion Slide-15
URL
Class Discussion Slide-16
URL
Week 9 (Stored Procedure and Normalization)
13
Class Discussion Slide-17
URL
Class Discussion Slide-18
URL
Class Discussion [Forum]
Week 10 (Database Transaction)
14
Class Discussion Slide-19
URL
Class Discussion Slide-20
URL
Week 11 (Trigger in DBMS)
15
Class Discussion Slide
URL
Week 12 (Final Exam Week)
16
Skip to main content
To operate the Blended Learning Center(BLC) at optimal level, maintenance will be performed every day at 8:30 AM and at 5:00 PM regularly which can take up to 30 minutes. Please consider scheduling your activity in the BLC platform accordingly.
Database Management System (Spring 21)
Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Spring 21
TRA211_CSE311
Week 6 (Basic SQL Queries)
SQL queries in Database
SQL queries in Database
Click
https://www.youtube.com/watch?v=rHiu-7jTMOg
link to open resource.
Previous Activity
Jump to...
Jump to...
.
Welcome to DBMS Class
OBE Course outline
Class Discussion Slide-1
Class Discussion Slide-2
Class Discussion Slide-3
What have I Learned from this week [MCQ]
Class Discussion Slide-4
Class Discussion Slide-5
Class Discussion Slide-6
Self Assessment
Class Discussion Slide-7
Forum Discussion
10 Minutes Practice [Click Here]
Use LucidChart to implement your 10 Minutes Work
Class Discussion Slide-8
Class Discussion Slide-9
ER to Schema Mapping (Video Lesson)
Five Minutes Practice
Forum Discussion
Class Discussion Slide-10
Self Assessment
Forum Discussion
Class Discussion Slide-12
Database Join Operation with Example
SQL Join 10 Minutes Practice
Discussion regarding SQL Join Operation
Class Discussion Slide-13
Discussion about SQL queries
Class Discussion Slide-14
Numeric Functions, Date & Time Functions File
Review Lectures [Forum]
Class Discussion Slide-15
Class Discussion Slide-16
Class Discussion Slide-17
Class Discussion Slide-18
Class Discussion [Forum]
Class Discussion Slide-19
Class Discussion Slide-20
Class Discussion Slide
Next Activity