Designing the Data
Tier for Microsoft SQL Server 2005
|
|
|
|
Course 2783: 1 Day; Instructor-led Clinic
|
Introduction
This one-day instructor-led
clinic provides students with the knowledge and skills to design the data tier
for Microsoft SQL Server 2005. The clinic focuses on teaching database
developers working in enterprise environments to understand and decide how application
developers are going to access and consume their data. This is a major failure
point of database solutions today.
Audience
·
This
clinic 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 attending
this course, students will be able to:
• Choose
data access technologies and an object model to support an organization's
business needs.
•
Design an exception handling strategy.
•
Choose a cursor strategy.
•
Design query strategies using Multiple Active Result Sets (MARS).
•
Design caching strategies for database applications.
•
Design a scalable data tier for database applications.
Prerequisite
Before attending this clinic, students must:
• Have experience reading
user requirements and business-need documents. For example, development project
vision/mission statements or business analysis reports.
• Have basic knowledge of
the Microsoft .NET Framework, .NET concepts, ADO.NET, and service oriented
architecture (SOA).
• Be familiar with the tasks
that application developers typically perform.
• Understand Transact-SQL
syntax and programming logic.
• Have some experience with
professional-level database design and know the tradeoffs when backing out of
the fully normalized design (denormalization) and designing for performance and
business requirements, in addition to being familiar with design models such as
Star and Snowflake schemas.
• Have basic monitoring and
troubleshooting skills. Specifically, how to use SQL Profiler and dynamic
management views.
• Have basic knowledge of
the operating system and platform. That is, how the operating system integrates
with the database, what the platform or operating system can do, and how
interaction between the operating system and the database works.
• Have basic knowledge of
application architecture. That is, how applications can be designed in three
layers, what applications can do, how interaction between the application and
the database works, and how the interaction between the database and the
platform or operating system works.
• Know how to use a data
modeling tool.
• Be familiar with SQL
Server 2005 features, tools, and technologies.
• Have a Microsoft Certified
Technology Specialist: Microsoft SQL Server 2005 credential, or equivalent
experience.
In addition, it is recommended, but not required, that
students have completed:
• Course 2778: Writing
Queries Using Microsoft SQL Server 2005 Transact-SQL.
• Course 2779: Implementing
a Microsoft SQL Server 2005 Database.
• Course 2780: Maintaining a
Microsoft SQL Server 2005 Database.