Designing Microsoft SQL Server 2005 Databases-CE Limited

當前位置：課程搜索

科技資訊

更新時間：7/10/2012　　瀏覽次數：1058

課程名稱：Designing Microsoft SQL Server 2005 Databases

課程編號：CET00152

性質與目標：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.

對象：

人數：(每班)

授課語言：

授課方式：

學時：

授課導師：

開課日期：

授課地點：

學費：

內容：

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