Discussion about SQL queries

List of discussions. Showing 44 of 44 discussions
Discussion	Started by	Last post	Replies
week 6	Mijanur Rahman Polin 19 Mar 2021	Mijanur Rahman Polin 19 Mar 2021	0
Week-6	Momenunnessa Meem 19 Mar 2021	Momenunnessa Meem 19 Mar 2021	0
Week 6	Md Raihan Uddin 21 Mar 2021	Md Raihan Uddin 21 Mar 2021	0
Week-6	Ritika Ahmmed Trisa 21 Mar 2021	Ritika Ahmmed Trisa 21 Mar 2021	0
week 6	Tajul Islam Ayon 21 Mar 2021	Tajul Islam Ayon 21 Mar 2021	0
week 6	Tanjina Akter Choity 24 Mar 2021	Tanjina Akter Choity 24 Mar 2021	0
Week 6	Anika Tafannum 24 Mar 2021	Anika Tafannum 24 Mar 2021	0
week 6	Faruq Hossain 24 Mar 2021	Faruq Hossain 24 Mar 2021	0
week 6	Md. Muzahidul Islam Khandakar 24 Mar 2021	Md. Muzahidul Islam Khandakar 24 Mar 2021	0
week 6	golam kibria khan 24 Mar 2021	golam kibria khan 24 Mar 2021	0
Sql queries	Mamunur Rahaman Antik 29 Mar 2021	Mamunur Rahaman Antik 29 Mar 2021	0
Week 6	Khadija Tut Tahera 29 Mar 2021	Khadija Tut Tahera 29 Mar 2021	0
week 6	Tanvir Rezwan 30 Mar 2021	Tanvir Rezwan 30 Mar 2021	0
Week-6	Rana Ahmed 31 Mar 2021	Rana Ahmed 31 Mar 2021	0
Week 6	golam kibria khan 31 Mar 2021	golam kibria khan 31 Mar 2021	0
Week 6	Swarna Roy191-15-2509 31 Mar 2021	Swarna Roy191-15-2509 31 Mar 2021	0
week 6	Abdus Salam 1 Apr 2021	Abdus Salam 1 Apr 2021	0
Week 6	Al- mamun 1 Apr 2021	Al- mamun 1 Apr 2021	0
Week 6	Tanzila Akhter Mim 4 Apr 2021	Tanzila Akhter Mim 4 Apr 2021	0
Week 6	Akib Ahmed 7 Apr 2021	Akib Ahmed 7 Apr 2021	0
Week-6	Md.Moshiur Rahman 8 Apr 2021	Md.Moshiur Rahman 8 Apr 2021	0
week 6	Farzana Akter 8 Apr 2021	Farzana Akter 8 Apr 2021	0
week 6	Nasir Khan 12 Apr 2021	Nasir Khan 12 Apr 2021	0
Week 6	Rina Sultana 15 Apr 2021	Rina Sultana 15 Apr 2021	0
week-6	Md.Mahmud Hassan 15 Apr 2021	Md.Mahmud Hassan 15 Apr 2021	0
week6	Abu Raihan 16 Apr 2021	Abu Raihan 16 Apr 2021	0
week 6	Mehedi Hasan 16 Apr 2021	Mehedi Hasan 16 Apr 2021	0
Week 6	Imam mehedi Hasan 17 Apr 2021	Imam mehedi Hasan 17 Apr 2021	0
week 6	Md. Rifat Mahmud Rakib 18 Apr 2021	Md. Rifat Mahmud Rakib 18 Apr 2021	0
Week-6	Rasel Hider Nobin 18 Apr 2021	Rasel Hider Nobin 18 Apr 2021	0
Week 6	Momin Emon 18 Apr 2021	Momin Emon 18 Apr 2021	0
CSE311	Anika Tahsin 19 Apr 2021	Anika Tahsin 19 Apr 2021	0
week 6	Tonima Islam 19 Apr 2021	Tonima Islam 19 Apr 2021	0
week06	Fazlay Atif Maruf 20 Apr 2021	Fazlay Atif Maruf 20 Apr 2021	0
DBMS	Sabbir Ahmad 20 Apr 2021	Sabbir Ahmad 20 Apr 2021	0
week 6	MD.Mashrafi Hassan 21 Apr 2021	MD.Mashrafi Hassan 21 Apr 2021	0
Week 6	Shahida Akter 21 Apr 2021	Shahida Akter 21 Apr 2021	0
Week 6	Rashiduzzaman Shakil 20 Apr 2021	Nahid Sharif 21 Apr 2021	1
Week 06	Md Sadiqur Rahman 24 Apr 2021	Md Sadiqur Rahman 24 Apr 2021	0
week 6	M.H. Mobin Bhuyan 25 Apr 2021	M.H. Mobin Bhuyan 25 Apr 2021	0
Week 6	Ismatara Nodi 26 Apr 2021	Ismatara Nodi 26 Apr 2021	0
week 6	Md Ali Al Alvy 26 Apr 2021	Md Ali Al Alvy 26 Apr 2021	0
week 6	Md. Imtius Ahammed 27 Apr 2021	Md. Imtius Ahammed 27 Apr 2021	0
Week 6	Fardeen Mahmud 29 Apr 2021	Fardeen Mahmud 29 Apr 2021	0

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)

Numeric Functions, Date & Time Functions File