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 |