Data Base Design in Practice

Course Objectives: This course helps students understand the fundamentals of Microsoft SQL Server 7.0. It also provides the students with the ability to design relational data bases.

Course Outlines:
N-tier Architecture and Client/Server Environment
SQL Server and Relational Data Bases
SQL Server Components
Devices
Databases
Tables
Views
Stored Procedures
Triggers
Data Base Objects
SQL Basics
Components - Rows, Columns
The SQL Sub-Languages
DDL - Data Definition Language
DML - Data Manipulation Language
DCL - Data Control Language