Section: Week 5 (Join Operation) | Database Management System (Fall 20)

Section outline

Topics of Discussion:
Inner Join
Outer Join
Join Operation using SQL
Expected Learning Outcome:
Able to learn the basic Join operation with SQL query.
Resources of Learning:
Lesson 12: Join Operation
Class Discussion Slide-12
Database Join Operation with Example [Video Lesson]
- Select activity SQL Join 10 Minutes Practice
  
  SQL Join 10 Minutes Practice Quiz
- 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 Open Discussion Forum
  
  Open Discussion Forum
  
  Students must
  
  View

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:Inner JoinOuter JoinJoin Operation using SQLExpected Learning Outcome:Able to learn the basic Join operation with SQL query.Resources of Learning:Lesson 12: Join OperationClass Discussion Slide-12Database Join Operation with Example [Video Lesson]bLL5NbBEg2I

Topics of Discussion:Inner JoinOuter JoinJoin Operation using SQLExpected Learning Outcome:Able to learn the basic Join operation with SQL query.Resources of Learning:Lesson 12: Join OperationClass Discussion Slide-12Database Join Operation with Example [Video Lesson]bLL5NbBEg2I

Topics of Discussion:

Topics of Discussion:

Inner JoinOuter JoinJoin Operation using SQL

Inner JoinOuter JoinJoin Operation using SQL

Expected Learning Outcome:Able to learn the basic Join operation with SQL query.Resources of Learning:Lesson 12: Join OperationClass Discussion Slide-12Database Join Operation with Example [Video Lesson]bLL5NbBEg2I

Expected Learning Outcome:

Expected Learning Outcome:

Expected Learning Outcome:

Able to learn the basic Join operation with SQL query.Resources of Learning:Lesson 12: Join OperationClass Discussion Slide-12Database Join Operation with Example [Video Lesson]bLL5NbBEg2I

Able to learn the basic Join operation with SQL query.

Able to learn the basic Join operation with SQL query.

Resources of Learning:Lesson 12: Join Operation

Resources of Learning:Lesson 12: Join Operation

Numeric Functions, Date & Time Functions File

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

Topics of Discussion:
Inner Join
Outer Join
Join Operation using SQL
Expected Learning Outcome:
Able to learn the basic Join operation with SQL query.
Resources of Learning:
Lesson 12: Join Operation
Class Discussion Slide-12
Database Join Operation with Example [Video Lesson]

Topics of Discussion:
Inner Join
Outer Join
Join Operation using SQL
Expected Learning Outcome:
Able to learn the basic Join operation with SQL query.
Resources of Learning:
Lesson 12: Join Operation
Class Discussion Slide-12
Database Join Operation with Example [Video Lesson]

Inner Join
Outer Join
Join Operation using SQL

Inner Join
Outer Join
Join Operation using SQL

Expected Learning Outcome:
Able to learn the basic Join operation with SQL query.
Resources of Learning:
Lesson 12: Join Operation
Class Discussion Slide-12
Database Join Operation with Example [Video Lesson]

Able to learn the basic Join operation with SQL query.
Resources of Learning:
Lesson 12: Join Operation
Class Discussion Slide-12
Database Join Operation with Example [Video Lesson]

Resources of Learning:
Lesson 12: Join Operation

Resources of Learning:
Lesson 12: Join Operation

Resources of Learning:
Lesson 12: Join Operation