Training Course:designing the data tier for microsoft sql server 2005 (Certificate)School/Trainer:New Horizons Singapore
Singapore, Singapore
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.
Please go to the school's official website for training price and schedule:
http://www.newhorizons.com/
Phone:+65 6822 8282
School Address:
298 Tiong Bahru Road
Level 18 Central Plaza
Singapore 168730
Jobs & Resumes: Singapore
Houses & Roommates: Singapore
Travel Agencies: Singapore
Search other schools for designing the data tier for microsoft sql server 2005 training resources.
Other training courses offered by New Horizons Singapore:
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:
If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later. |
|
| 
