Subqueries in DBMS

Lecture Objectives:

1. Learn to subqueries in DBMS

Click Subqueries in DBMS (p-2).pptx link to view the file.

Previous Activity

Jump to... Jump to... Announcements Welcome to DBMS Class OBE Course outline Lab Docs DBMS Project List Introduction to Database Management System Purpose of Database System Relational Model in DBMS What have I Learned Forum Discussion about pros and cons of Conventional File Processing System Class (03/10/2020) (PC-A) Class (03/10/2020) (PC-B) LAB-1 (06/10/2020) Feedback (Lab-1 (06-10-2020)) Discussion about Lab-1 Lab Class-1 (06-10-2020) 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) Feedback (05-10-2020) Class (05-10-2020) PC-A Lab-2 (12-10-2020) (PC-B) Feedback (Lab-2) (PC-A & PC-B) Lab-2 (PC-A) ER to Schema Mapping Er to schema mapping ERD ERD_exercise_1 ERD_exercise_2 ERD_exercise_3 ER to Schema Mapping (Video Lesson) Class: 12-10-2020 (PC-A) Class: 12-10-2020 (PC-B) Feedback (12-10-2020) (PC-A & PC-B) Class (17-10-2020) (PC-A) Feedback (17-10-2020) (PC-A & PC-B) Review Assignment (class: 17-10-2020) (PC-A & PC-B) Discussion about ERD to relational schema mapping Class (17-10-2020) PC-B Relational Algebra Five Minutes Practice Discussion (Relational Algebra) Feedback (19-10-2020) (PC-A & PC-B) Class (19-10-2020) (PC-A) Class (19-10-2020) (PC-B) Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B) Lab Class-3 (19-10-2020) (PC-B) Lab Class-3 (PC-A) (20-10-2020) Basic SQL Queries (P-1) Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1) Discussion Class (27-10-2020) (SQL-1) Class: 12-10-2020 (PC-A) Join Operation in DBMS Database Join Operation with Example SQL Join 10 Minutes Practice Discussion regarding SQL Join Operation Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation) Class (27-10-2020) (SQL-2) SQL queries in Database Basic SQL Queries (P-2) Discussion about SQL queries Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2) Class (27-10-2020) (SQL-3) SQL Queries Numeric Functions, Date & Time Functions File class (31-10-2020) (PC-A) Subqueries in DBMS class (31-10-2020) (PC-B) Previous Semester's Midterm Examination Question Stored Procedurer and Views Feedback (stored procedure) (pc-a & pc-b) Discussion Class (22-11-2020) (pc-a) Database Normalization Feedback (normalization) (pc-a & pc-b) Discussion class (23-11-2020) pc-a class (normalization) pc-b Feedback (LAB-23-11-2020) (pc-a & pc-b) LAB 23-11-2020 (PC-B) Lab-24/11/2020 (pc-a) Database Transaction Database Transaction Feedback (28-11-2020) (PC-A & PC-B) Discussion (pc-a and pc-b) transaction (28-11-2020) PC-A transaction (28-11-2020) (pc-b) Database transaction part-2 Trigger in Database SQL Injection class 30-11-2020 (pc-b) class 30-11-2020 PC-A ra review class (7-12-2020) (pc-b) ra review class 7-12-2020 pc-a 12-12-2020 (pc-b) 12-12-2020 pc-a lab 14-12-2020 Previous Semester's Final Examination Question

Next Activity