DIU-BLC
Database Systems lab (Fall 2021)
0%
Previous
Course data
General
Announcements
Course Introduction
Reference Book
Course Outline
Forum Discussion
Lesson 01: DDL-Design database and table with proper data set [Session 01]
Connecting to SQL Server using SSMS
MIcrosoft sql server 2017 installation steps
LAb task 1
Class Recording Section B 22-09-20
Class Recording section A 24-09-20
Lesson 01: DDL-Design database and table with proper data set [Session 02]
Class recording section B 27-09-20
Class record date:30-09-20 section A
SQL ALTER TABLE Statement
Creating and working with tables
SEction A: 08-10-20
Section B 04-10-20
Lesson02: DML-Problem solving basic condition [Session 3]
SQL AND, OR and NOT Operators
SQL ORDER BY Keyword
Lab task 2
Lesson02: DML-Problem solving basic condition [Session 4]
Select statement in sql server
Class Response section A lab
Lesson03: Problem solving using Aggregate Function [Session 5 & 6]
SQL GROUP BY Statement
SQL HAVING Clause
Aggregate Function
Class record section A 22-10-20
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
Class Task on group by, having and view
Lab Class Content
Class Recording 03-12-20 section A 29
MID LAB
Database LAb Report
Database Lab Final
Next
DIU-BLC
Side panel
Guidelines
For Teachers
For Students
Search
Close
Search
Toggle search input
Log in
Username
Password
Remember username
Forgot Password?
Log in
Create new account
Site Navigation
SE 224 (BS-213)
Home
Skip to main content
Course info
Home
Courses
DIU
Faculty of Science and Information Technology
Software Engineering
SWE Fall 2021
SE 224 (BS-213)
Summary
Database Systems lab (Fall 2021)
Teacher:
Biraj Saha
Skill Level
:
Beginner