New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

2782 Designing Microsoft SQL Server 2005 Databases On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions

Course Description/Agenda


This course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques).

Who Should Attend:
This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment.

At Course Completion:
After completing this course, students will be able to:

- Approach database design from a systematic perspective, gather database requirements, and formulate a conceptual design.

- Analyze and evaluate a logical database design.

- Apply best practices for creating a physical database design.

- Apply best practices when designing for database scalability.

- Design a database access strategy.

- Use best practices to model database dependencies.


Prerequisite(s) or equivalent knowledge:
2780 Maintaining a Microsoft SQL Server 2005 Database
2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
 
Outline:
Lesson 1: Approaching Database Design Systematically
Overview of Database Design
Gathering Database Requirements
Creating a Conceptual Database Design
Lesson 2: Modeling a Database at the Logical Level
Building a Logical Database Model
Designing for OLTP Activity
Designing for Data Warehousing
Evaluating Logical Models
Lesson 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
Lesson 4: Designing for Database Performance
Designing Indexes
Planning for Table Optimization
Planning for Database Optimization
Lesson 5: Designing a Database Access Strategy
Designing for Secure Data Access
Designing User-Defined Functions
Designing Stored Procedures
Lesson 6: Modeling Database Dependencies
Modeling Local Database Dependencies
Modeling Remote Database Dependencies

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

On-Site Training On-Site Training

Also Available As

Seminar Seminar

 
Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!