Section: Topic 8 | Database Management System Theory & Lab (Fall 2024)

Section outline

- Select activity Lesson 9Learning Objectives: Join and join clas...
  
  Lesson 9
  Learning Objectives:
  
  Join and join classification?
  Natural and self join with example
  
  Click here to get resource
- Select activity Write your Feedback after every live class &n...
  
  Write your Feedback after every live class
  Click Here for Feedback
- Select activity Lesson 10Learning Objectives: Natual Join...
  
  Lesson 10
  Learning Objectives:
  
  Natual Join and Subqueries
  
  Subqueries lecture content
- Select activity Database SQL: Sub Queries Question
  
  Database SQL: Sub Queries Question Interactive Content
  
  Students must
  
  View
- Select activity Write your Feedback after every live class &n... (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback

Welcome Database Management System

Announcements

Course Summary and Objectives

OBE Course outline

Course Slides (MID)

Course Slides(Final)

Database Security

NoSQL(Extra)

Topic 2

Topic 3

Topic 4

L1:Assessment your Leaning: What have I Learned?

Relational_Model

L2:Assessment your Leaning: What have I Learned about Relational Model?

Forum Discussion : Career on Database Management System

Topic 5

Quiz: Assessment of learning On level of Abstraction and Architecture of Database

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

ER Diagram week 2 (Slide 2)

Topic 6

Lecture Content: ER to Schema Mapping (Video Lesson)

Lecture Content: ER to Schema Mapping (Video Lesson) (copy)

Five Minutes Practice

Topic 7

Lecture Content: Basic SQL Queries (P-1)

Assessment of Leaning : What have I learned

Ask any question about sql operation

natural join vs inner join

Natural Join

Topic 8

Database SQL: Sub Queries Question

Mid term Week

Week 8

Database Transaction

Database Transaction part 1

Database Transaction part 2

Week Nine(9)

Topic 12

Week 8

Subqueries in DBMS

Week 10

Week 13

Trigger in Database

Week 14

Demo quiz

Topic 17

Assignment (61-K)

Assignment (61_L)

Assignment file dbms

Lab Week 1

Tool Installation

SQL Data Type

Lab Week 2

DDL(TFS)

Lab 2

Lab Week 3

DML 1

DML 2

Lab 3

Topic 23

Aggregate Function

Topic 24

Join Doc 1

Join DOC 2

Join Lab Task

Topic 25

Data of Slide 6

Topic 27

Stored Procedure File

Trigger File

Practice Stored Procedure

Topic 28

View Practice Doc

Trigger-2

Trigger-1

Topic 29

Lab Report Format

Project Report Format

Topic 30