SE 224 (NJ-211): Online Shopping System

Home Guidelines

Course Menu

Online Shopping System

◄ Library management system
Student management system ►

Online Shopping System

◄ Library management system
Student management system ►

Announcements

Class link

Class Recording Link

Reference Book

Course Outline

Online Editor

Connecting to SQL Server using SSMS

Class Recording 24-01-20 section A

MIcrosoft sql server 2017 installation steps

Lab Task 1

Class Recording 26-01-21 Section B

Class Recording 01-02-2021 section A

02-02-21 SEction B

SQL ALTER TABLE Statement

Creating and working with tables

09-02-21 Section B

09-02-21 Section A

Lab task 2

SQL GROUP BY Statement

SQL HAVING Clause

Aggregate Function

SQL INNER JOIN

SQL LEFT JOIN

SQL RIGHT JOIN

SQL FULL OUTER JOIN

Joins Operation in sql server

Lab Class Content

Mid Lab

Lab Report Topic

Lab Final

Subquery

Lab Report Topic

Online Shopping System

Online Shopping System

General

Announcements

Class link

Class Recording Link

Course Introduction

Reference Book

Course Outline

Online Editor

Lesson 01: DDL-Design database and table with proper data set [Session 01]

Connecting to SQL Server using SSMS

Class Recording 24-01-20 section A

MIcrosoft sql server 2017 installation steps

Lab Task 1

Class Recording 26-01-21 Section B

Class Recording 01-02-2021 section A

02-02-21 SEction B

Lesson 01: DDL-Design database and table with proper data set [Session 02]

SQL ALTER TABLE Statement

Creating and working with tables

09-02-21 Section B

09-02-21 Section A

Lesson02: DML-Problem solving basic condition [Session 3]

Lab task 2

Lesson03: Problem solving using Aggregate Function [Session 5 & 6]

SQL GROUP BY Statement

SQL HAVING Clause

Aggregate Function

Lesson05: Problem solving using Join Operation [Session 8]

SQL INNER JOIN

SQL LEFT JOIN

SQL RIGHT JOIN

SQL FULL OUTER JOIN

Joins Operation in sql server

Lab Class Content

MID LAB

Mid Lab

Database LAb Report

Lab Report Topic

Database Lab Final

Lab Final

Sub Query, Aggregate

Subquery

Online Shopping System