designing the data tier for microsoft sql server 2005 (Certificate)

New Horizons Malaysia
Kuala Lumpur, Kuantan, Penang, Petaling Jaya, Malaysia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' this clinic provides students with the knowledge and skill to design the data tier for microsoft® sql server 2005.

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 attending this clinic, 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 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(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

prerequisite comments:
have a microsoft certified technology specialist: microsoft sql server 2005 credential or equivalent experience


outline: top
lesson 1: choosing data access technologies and an object model
introduction to data access technologies
choosing technologies for accessing data
building a data access layer
designing data access from sql common language runtime (clr) objects
available data object models for administering sql server

top
lesson 2: designing an exception handling strategy
exception types and their purposes
detecting exceptions
managing exceptions


lesson 3: choosing a strategy
common scenarios for row-based vs. set-based operations
selecting appropriate server-side cursors
selecting appropriate client-side cursors


lesson 4: designing query strategies using multiple active result sets
introduction to mars
designing query strategies for multiple reads
designing query strategies for mixing reads and writes in the same connection
concurrency considerations when using mars


lesson 5: designing caching strategies for database applications
why caching is important
data and query caching in sql server 2005
using caching technologies outside of sql server
custom caching techniques

top
lesson 6: designing a scalable data tier for database applications
identifying the need to scale
scaling database applications to avoid concurrency contention
scaling sql server database systems
scaling database applications using a service-oriented architecture
improving availability and scalability by scaling out front-end systems
...''

Elements of this syllabus are subject to change.

Phone:+ 603-26946455

School Address:

3rd Floor, Wisma Thakurdas
Kuala Lumpur,16-1, Jalan Raja Laut 50350
Malaysia


Jobs & Resumes: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Houses & Roommates: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Travel Agencies: Kuala Lumpur,

Search other schools for designing the data tier for microsoft sql server 2005 training resources.

Programming with the Microsoft .NET Framework using Microsoft Visual Studio 2005
Complete .NET Security
C# 3.0 Programming in the .NET Framework
SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005
writing queries using microsoft sql server 2008 transact-sql
Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
tuning and optimizing queries using microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005
SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.