Section: Week 8 (Nested Queries) | Database Management System (Fall 20)

Section outline

Topics of Discussion:
Nested Queries
Expected Learning Outcomes:
Able to learn the nested SQL query among more than one relation.

Resources of Learning:

Lesson 15: Subqueries in DBMS (Part-1)
Class Discussion Slide-15

Lesson 16: Subqueries in DBMS (Part-2)

Class Discussion Slide-16
- Select activity Week-8:Feedback on Weekly Learning [Start: Wed 18 Nov@10:00 PM Close: 25 Nov@11:59 PM]
  
  Week-8:Feedback on Weekly Learning [Start: Wed 18 Nov@10:00 PM Close: 25 Nov@11:59 PM] Assignment
  
  Students must
  
  View
  
  Make a submission
- Select activity Online Class Recordings Section-O-5 [Google Drive Link]
  
  Online Class Recordings Section-O-5 [Google Drive Link] URL
  
  Students must
  
  Mark as done
- Select activity Start Practice (Write Program in Oracle Live SQL) (copy) (copy)
  
  Start Practice (Write Program in Oracle Live SQL)
- Select activity Open Discussion Forum
  
  Open Discussion Forum
  
  Students must
  
  Mark as done

Welcome to CSE 311 Database Management System Course

OBE Course outline

Telegram Group Link Section O-5

Class Attendance Submission

Week 1 (Introduction to DBMS)

What have I Learned from this week [MCQ]

Forum Discussion about pros and cons of Conventional File Processing System

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Week 2 (Data Model and Languages)

Self Assessment

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Quiz - 1

QUIZ-1 : Section-O5

Week 3 (ER to Schema Mapping)

Assignment-2 (ER to Schema Mapping)

Five Minutes Practice

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Quiz - 2

QUIZ-2 : Section-O5

Week 4 (SQL Queries)

Self Assessment

Online Class Recordings Section-O-5 [Google Drive Link]

Assignment- (Create Database and Relation)

Open Discussion Forum

Week 5 (Join Operation)

SQL Join 10 Minutes Practice

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Week 6 (Basic SQL Queries)

Numeric Functions, Date &amp; Time Functions File

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Midterm Week (Week 7)

Midterm Examination 2020 (O-5 Section) Assignment

[Google Form] Mid Exam Answer Script Submission for O-5 Section

Previous Semester's Midterm Examination Question

Week 8 (Nested Queries)

Week-8:Feedback on Weekly Learning [Start: Wed 18 Nov@10:00 PM Close: 25 Nov@11:59 PM]

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Week 9 (Stored Procedure and Normalization)

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Quiz-3

QUIZ-3 : Section-O5

Week 10 (Database Transaction)

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Week 11 (Trigger and Injection in DBMS)

SQL Injection

Online Class Recordings Section-O-5 [Google Drive Link]

Open Discussion Forum

Presentation

Presentation submission link (Section O-5)

Week 12 (Final Exam Week)

[Google Form] Final Exam Answer Script Submission for O-5 Section

Final Examination 2020 (O-5 Section) Question &amp; Answer Script Submission

Previous Semester's Final Examination Question

Documents and Slides (Resource Pack)

Section outline

Topics of Discussion:Nested QueriesExpected Learning Outcomes:Able to learn the nested SQL query among more than one relation.Resources of Learning:Lesson 15: Subqueries in DBMS (Part-1)Class Discussion Slide-15Lesson 16: Subqueries in DBMS (Part-2)Class Discussion Slide-16

Topics of Discussion:

Topics of Discussion:

Nested Queries

Expected Learning Outcomes:

Expected Learning Outcomes:

Expected Learning Outcomes:

Resources of Learning:

Resources of Learning:

Class Discussion Slide-16

Class Discussion Slide-16

Start Practice (Write Program in Oracle Live SQL)

Numeric Functions, Date & Time Functions File

Final Examination 2020 (O-5 Section) Question & Answer Script Submission

Topics of Discussion:
Nested Queries
Expected Learning Outcomes:
Able to learn the nested SQL query among more than one relation.

Resources of Learning:

Lesson 15: Subqueries in DBMS (Part-1)
Class Discussion Slide-15

Lesson 16: Subqueries in DBMS (Part-2)

Class Discussion Slide-16