Section: Week 6 (Basic SQL Queries) | Database Management System (Fall 20)

Section outline

- Select activity Lecture Objectives: Between and In Quer...
  
  Lecture Objectives:
  
  Between and In Queries, Exist and not exists Queries
  Like Operator, Group by with having clause
  
  Rename Operation, Order By, Set Operations
  Nested Query Using Set Operation
- Select activity Lecture Slide-13
  
  Lecture Slide-13 URL
- Select activity Class Lecture-13
  
  Class Lecture-13 URL
  
  Students must
  
  Mark as done
- Select activity SQL queries in Database
  
  SQL queries in Database URL
- Select activity Discussion Forum Week-6
  
  Discussion Forum Week-6

General

OBE Course outline

Lecture Slide-16

Students Interest Feedback

Attendance

Week 1

Lecture Slide-1

Lecture Slide-2

Lecture Slide-3

Class Discussion Slide-1

Class Discussion Slide-2

Class Discussion Slide-3

What have I Learned from this week [MCQ]

Forum Discussion about pros and cons of Conventional File Processing System

Week 2

Lecture Slide- 4

Lecture Slide- 5

Lecture Slide- 6

Lecture Slide- 7

Class Discussion Lecture-4

Class Discussion Lecture-5

Class Discussion Lecture-6

Class Discussion Lecture-7 (part-1)

Class Discussion Lecture-7 (part-2)

Assignment-1 ( ER Diagram Drawing)

ER Diagram Example

Discussion Forum

Week 3

Lecture Slide-8

Lecture Slide-9

Scenario to ER Diagram

Class Lecture-8 ( ERD to Schema)

ER to Schema Mapping (Video Lesson)

Lecture Slide-10

Class lecture-10

Class lecture-10- (Part-1)

Class lecture-10- (Part-2)

Assignment-2 (ER to Schema Mapping)

Homework (Relational Algebra)

Week3 Discussion Forum

Quiz-1

Quiz-1 for Section-O2

Week 4

Lecture Slide-11

Class Lecture-11

Week-4-Assignment (Create Database and Relation)

Discussion Forum

Week 5

Lecture Slide-12

Class Lecture-12

Extra Resource- Join Operation Example

Discussion Forum

Week 6 (Basic SQL Queries)

Lecture Slide-13

Class Lecture-13

SQL queries in Database

Discussion Forum Week-6

Week 7

Lecture Slide-14

Class Lecture- 14

Numeric Functions, Date &amp; Time Functions File

Week-7 Discussion Forum

Quiz-02

Quiz-2 Eve Section O2

Midterm Week (Week 8)

Mid Term Examination Fall-2020 (O-2) Assignment

Online Exam Response Submission Template Fall-2020 (Answer Script)

[Google Form] Mid Exam Answer Script Submission for O-2 Section

Week 8 (Nested Queries)

Lecture Slide-15

Lecture Slide-16

Class Lecture 15 &amp; 16

Week-8 Feedback Assignment

Week-8 Discussion Forum

Week 9 (Stored Procedure and Normalization)

Lecture Slide-17

Class Lecture-17

Lecture Slide-18

Extra Resource: Normalization

Class Lecture- 18

Numeric Functions, Date & Time Functions File

Class Lecture 15 & 16