CSE311ZHFall20: Discussion regarding SQL Join Operation

Re: Discussion regarding SQL Join Operation

by Mustahid Hasan - Saturday, 31 October 2020, 8:44 PM

An SQL join clause corresponding to a join operation in relational algebra that combines columns from one or more tables in a relational database.

General

Announcements

Welcome to DBMS Class

Telegram Group Link

Course Summary and Objectives

OBE Course outline

Students Interest Feedback

Announcement

Attendance

Course Introduction

Week 1 (Introduction to DBMS)

Class Discussion Slide-1

Class Discussion Slide-2

Class Discussion Slide-3

Self-Test Week-1 [MCQ]

DBMS-Introduction Week-1 (Self Assessment)

Open Discussion about pros and cons of Conventional File Processing System

Google Meet Class Video Week-1

Week 2 (Data Model and Languages)

Class Discussion Slide-4

Class Discussion Slide-5

Class Discussion Slide-6

Class Discussion Slide-7

Self Assessment Week-2

DBMS-Relational_Model Week-2 (Self Assessment)

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

Assignment-1 (Draw ER Diagram)

Discussion Thread (W-2): Feel free to put your queries here

Google Meet Class video-1 Week-2

Google Meet Class video-2 Week-2

Google Meet Class video-3 Week-2

Software Installation Help

Week 3 (ER and Schema Mapping)

Class Discussion Slide-8

Class Discussion Slide-9

ER to Schema Mapping (Video Lesson)

Five Minutes Practice

Homework (Relational Algebra)

DBMS-ER_and_Schema_Mapping Week-3(Self Assessment)

Discussion Thread: Feel free to put your queries here

Google Classroom Video-1 W-3

Google Classroom Video-2 W-3

Class Test-1 (Based On ER model)

Week 4 (Relational Algebra and Basic SQL Queries)

Class Discussion Slide-11

Class Discussion Slide-10

Self Assessment

DBMS-Relational_Algebra And SQL-Week-4(Self Assesment)

Open Discussion

Google Classroom Video-1 W-4

Google Classroom Video-2 W-4

Week 5 (SQL Queries-Aggregate Function)

Discussion about SQL queries in Aggregation Function

DBMS-SQL_Queries-Aggregate_function Week-5(Self Assessment)

Google Classroom Video-1 W-5

Google Classroom Video-2 W-5

Week 6 (Basic SQL Queries)

Class Discussion Slide-13

SQL queries in Database

DBMS-Basic_SQL_Queries- Week 6(Self Assesment)

Discussion about SQL queries

Google Classroom Video-1 W-6

Google Classroom Video-2 W-6

Midterm Survey of the Course [Just before Midterm]

Class Test-2

Midterm Week (Week 7)

Midterm Exam Question and Answer Script [Fall 20]

Week 8 (Join Operation)

Class Discussion Slide-12

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Class Video-1 W-8

Class Video-2 W-8

Week 9 (Nested Queries)

Class Discussion Slide-15

Class Discussion Slide-16

Review Midterm Exam [Forum]

Presentation