Designing Microsoft SQL Server 2005 Databases-CE Limited

Position:Course Searching

Information Technology

Update Time：7/10/2012　　1059 views

Course name：Designing Microsoft SQL Server 2005 Databases

Course Code：CET00152

Nature and target：This course provides students with the knowledge and skills to design databases for Microsoft SQL Server 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design.

Object：

Number：Max 15 persons(class)

The language of instruction：Chinese / English

Teaching methods：

Hours：12 hrs

Teaching supervisor：

Class Date：

Venue：

Tuition：

Content：

Module 1: Approaching Database Design Systematically

-	Overview of Database Design
-	Gathering Database Requirements
-	Creating a Conceptual Database Design

Module 2: Modeling a Database at the Logical Level

-	Building a Logical Database Model
-	Designing for OLTP Activity
-	Designing for Data Warehousing
-	Evaluating Logical Models

Module 3: Modeling a Database at the Physical Level

-	Designing Physical Database Objects
-	Designing Constraints
-	Designing for Database Security
-	Designing Server and Database Options
-	Evaluating the Physical Model

Module 4: Designing for Database Performance

-	Designing Indexes
-	Planning for Table Optimization
-	Planning for Database Optimization

Module 5: Designing a Database Access Strategy

-	Designing for Secure Data Access
-	Designing User-Defined Functions
-	Designing Stored Procedures

Module 6: Modeling Database Dependencies

-	Modeling Local Database Dependencies
-	Modeling Remote Database Dependencies

TOP