Section: Week 5 | Database Management System (Spring 21)

Section outline

- Select activity Join Operation in DBMS
  
  Join Operation in DBMS File
  
  Lecture Objectives:
  INNER Join, Outer Join
- Select activity Database Join Operation with Example
  
  Database Join Operation with Example URL
  
  (Class_Lecture_8)
- Select activity SQL Join 10 Minutes Practice
  
  SQL Join 10 Minutes Practice Quiz
- Select activity Discussion regarding SQL Join Operation
  
  Discussion regarding SQL Join Operation Forum

General

Announcements

Announcements

Welcome to DBMS Class

Experience with BLC

Join us on TELEGRAM

Course Summary and Objectives

OBE Course outline

Course Introduction

Week 1

Introduction to Database Management System

Purpose of Database System

What have I Learned

Relational Model in DBMS

Forum Discussion about pros and cons of Conventional File Processing System

Week 2

Level of Abstraction, Data Models, Database Languages

Database Architecture

Types of Keys in Relational Model

Entity Relationship (ER) Model

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

Assignment-1 (Draw ER Diagram of your favourite sport team)

Week 3

ER to Schema Mapping

ER to Schema Mapping (Video Lesson)

Assignment-2 (ER to Schema Mapping)

Relational Algebra

Five Minutes Practice

Homework (Relational Algebra)

Quiz-1

Week 4

Basic SQL Queries (P-1)

Assignment-3 (Create Database and Relation)

Week 5

Join Operation in DBMS

Database Join Operation with Example

SQL Join 10 Minutes Practice

Discussion regarding SQL Join Operation

Week 6

SQL queries in Database

Basic SQL Queries (P-2)

Discussion about SQL queries

Week 7

SQL Queries

Numeric Functions, Date &amp; Time Functions File

Quiz-2 (Time:1hour) : Please submit your answer script as ID_Section_Quiz2.pdf by 9.30PM

Week 8

MID TERM EXAM

Week 9

Subqueries in DBMS

Subqueries in DBMS

Week 10

Stored Procedurer and Views

Week 11

Database Normalization

Week 12

Database Transaction

Database Transaction

Quiz-3

Week 13

Trigger in Database

SQL Injection

Submit your assignment on SQL injection and its prevention

Submit your presentation drivelink

Week 14

FINAL EXAM (Please read the instructions first)

Section outline

Numeric Functions, Date & Time Functions File