CSE 311 (SMP-202): How a SQL query can be complicated?

Database Management System (Summer 20)

0%

Previous
Discussion about SQL queries

General

Announcements

Welcome to DBMS Class

Social forum

Course Summary and Objectives

OBE Course outline

Course Introduction

Welcome to the course!

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

Dive Deep Into Relational Model

Week 3

DBMS, PC-B, New Class, (09-06-2020)

Entity Relationship (ER) Model

Use LucidChart to implement your 10 Minutes Work

10 Minutes Practice [Click Here]

ER to Schema Mapping

ER to Schema Mapping (Video Lesson)

Week 4

How to convert ER Diagram to Schema Diagram

DBMS, PC-A, New Class, (14-06-2020)

DBMS, PC-A, New Class, (15-06-2020)

DBMS, PC-B, New Class, (14-06-2020)

DBMS, PC-B, New Class, (16-06-2020)

Week 5

Basic SQL

Basic SQL Practice

DBMS, PC-A, New Class, (22-06-2020)

DBMS, PC-B, New Class, (23-06-2020)

Week 6

Like Operator

SQL queries in Database

50 SQl Query Practicer

Subquery Understanding

Discussion about SQL queries

DBMS, PC-A, New Class, (28-06-2020)

DBMS, PC-A, New Class, (29-06-2020)

DBMS, PC-B, New Class, (28-06-2020)

DBMS, PC-B, New Class, (30-06-2020)

Mid Term Week (Week 7)

Online Exam Response Submission Template

Online Exam Guideline

Week 8

More on Subqueries

Join Operation

Database Normalization

Database Normalization (Video Contents)

Queries on Week 8

Week 9

Week 10

Stored Procedurer and Views

Introduction to PL/SQL

PL/SQL Example and Stored Procedure

Trigger, Rollback, Savepoint etc

Week 11 (Final Examination)

Exam Guidelines

Answer Script Template

Final Exam Question

Week 12

Week 13

Week 14
Next

Guidelines
For Teachers For Students

Search Close

Toggle search input

Log in

Username

Password

Remember username
Forgot Password?
Create new account

Course Overview

Sections

Announcements Forum
Welcome to DBMS Class Forum
Social forum

Course Summary and Objectives 2

OBE Course outline File

Course Introduction 3

Welcome to the course! File

Introduction to Database Management System File
Purpose of Database System File
What have I Learned Quiz
Relational Model in DBMS File
Forum Discussion about pros and cons of Conventional File Processing System

Level of Abstraction, Data Models, Database Languages File
Dive Deep Into Relational Model File

DBMS, PC-B, New Class, (09-06-2020) Lesson
Entity Relationship (ER) Model File
Use LucidChart to implement your 10 Minutes Work URL
10 Minutes Practice [Click Here] URL
ER to Schema Mapping File
ER to Schema Mapping (Video Lesson) URL

How to convert ER Diagram to Schema Diagram Lesson
DBMS, PC-A, New Class, (14-06-2020) Lesson
DBMS, PC-A, New Class, (15-06-2020) Lesson
DBMS, PC-B, New Class, (14-06-2020) Lesson
DBMS, PC-B, New Class, (16-06-2020) Lesson

Basic SQL File
Basic SQL Practice URL
DBMS, PC-A, New Class, (22-06-2020) Lesson
DBMS, PC-B, New Class, (23-06-2020) Lesson

Like Operator URL
SQL queries in Database URL
50 SQl Query Practicer Lesson
Subquery Understanding Lesson
Discussion about SQL queries Forum
DBMS, PC-A, New Class, (28-06-2020) Lesson
DBMS, PC-A, New Class, (29-06-2020) Lesson
DBMS, PC-B, New Class, (28-06-2020) Lesson
DBMS, PC-B, New Class, (30-06-2020) Lesson

Mid Term Week (Week 7) 10

Online Exam Response Submission Template File
Online Exam Guideline File

More on Subqueries File
Join Operation File
Database Normalization File
Database Normalization (Video Contents) Lesson
Queries on Week 8 Forum

Stored Procedurer and Views File
Introduction to PL/SQL File
PL/SQL Example and Stored Procedure File
Trigger, Rollback, Savepoint etc File

Week 11 (Final Examination) 14

Exam Guidelines File
Answer Script Template File
Final Exam Question File

Skip to main content

Database Management System (Summer 20)

Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Summer 20
CSE 311 (SMP-202)
Week 6
Discussion about SQL queries
How a SQL query can be complicated?

Search forums

Discussion about SQL queries

How a SQL query can be complicated?

◄ What is the difference between ''Where'' and ''Having'' clause?
How a SQL query can be complicated? ►

Display mode

How a SQL query can be complicated?

by Arup Ratan Nag - Friday, 10 July 2020, 7:47 PM

Number of replies: 0

Name: Arup Ratan Nag

Id: 182-15-2138

Attachment 107523792_298026564723862_4879824777370240338_n.jpg

◄ What is the difference between ''Where'' and ''Having'' clause?
How a SQL query can be complicated? ►

Previous Activity

Jump to...

Next Activity

Follow Us

Follow Us

Follow Us

Follow Us

Guidelines
- For Teachers
- For Students

Copyright © 2022 Daffodil International University. All Rights Reserved.

DIU Blended Learning Center © 2024. All rights reserved.

Terms & Conditions Privacy Policy

You are currently using guest access (Log in)