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
2 days
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.
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.
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.
| 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