COMP 2312

Course: 

Database Systems Lab
 

1. Topics to be Covered
 
List of Topics No. of
Weeks
Contact hours
  • Overview of Database and ER-Diagram.
1 5
  • Introduction to SQL_SERVER, Types of Commands, and Data Types.
1 5
  • Data Manipulation Language as (Create, alter, drop).
1 5
  • Using Constraints as (primary key, foreign key, not null, check, and unique)
1 5
  • Data Manipulation Language as (select, select into, insert, update, and delete).
2 10
  • Data Control Language as (grant, revoke, and deny)
1 5
  • Advanced statements using DML.
1 5
  • SQL-Server Functions and using group by key word, and having key word.
1 5
  • Retrieve data from more than one tables using different types of join statement in SQL-SERVER as (INNER Join, Outer Join, Cross Join, and Self Join). Stored procedures in SQL-Server.
1 5
  • Accessing SQL-SERVER database from VB.NET application.
1 5
  • Using SQL commands in VB.NET to access SQL-Server Database.
1 5
  • Displaying dynamic contents in VB.NET
2 10
  • Developing complete project using SQL-Server, VB.NET and Crystal report.
1 5