• Microsoft Gold Certified Partner
  • Cisco Partner Learning Associate
  • Better Business Bureau

Questions? Call us at (919) 336-1000


2782 Designing Microsoft SQL Server 2005 Databases - Details

Return to All courses

Description:

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).

More Information  

Duration

2 days

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.

Prerequisites

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. Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience.

On 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.

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

Please call Jon Kudlick, Director of Sales at (919) 336-1000, ext. 1025 or email sales@nhrtp.com for class information.

Contact us to learn more about our courses and certifications.

Return to Top


News and Events

View all news

Top Certifications

"75 percent of managers believe that certified individuals are more productive and that certifications are important to team performance." - MCP Customer Satisfaction Study

Top Certifications in Information Technology Today

Why get certified? The importance of certifications. Read more...

 

What sets us apart

New Horizons Integrated Learning

For training to have a lasting and measurable impact, New Horizons understands that course content has to be designed and delivered in the context of our client’s specific environment and business need.  To achieve this, we blend custom content with leading edge and time honored training approaches, including Traditional Instructor-Led, Mentored Learning, Online Live, and Online Anytime, to meet the specific learning style of the individual and the complex learning objectives of the organization.

New Horizons Integrated Learning guides learners through all stages of the learning lifecycle. It consists of five components - AssessLearnReinforceSupport and Validate - to create the most effective learning experience available in the industry. 

Our Commitment, Guarantee and Promise