Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


Microsoft SQL Server 2005 Course - Designing the Data Tier

3 sessions available starting from $680.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

Course Code: 2783
Course Duration: 1 days

This one-day instructor-led (Level 300) clinic provides students with the knowledge and skills to design the data tier for SQL Server 2005. The clinic focuses on teaching database developers 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.

Skills Gained

After completing this clinic students will be able to:

• Choose data access technologies and an object model to support an organisation'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...

see more

Course Code: 2783
Course Duration: 1 days

This one-day instructor-led (Level 300) clinic provides students with the knowledge and skills to design the data tier for SQL Server 2005. The clinic focuses on teaching database developers 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.

Skills Gained

After completing this clinic students will be able to:

• Choose data access technologies and an object model to support an organisation'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

Course Modules

Session 1: Choosing Data Access Technologies and an Object Model
This session explains how to choose data access technologies and an object model to support an organisation's business needs.

Session 2: Designing an Exception Handling Strategy
This session describes the various types of exceptions that can occur in a database system, how to capture them, and how to manage them appropriately.

Session 3: Choosing a Cursor Strategy
This session describes when cursors are appropriate and how to use them to optimise the use of system resources.

Session 4: Designing Query Strategies Using Multiple Active Result Sets
This session describes when Multiple Active Result Sets (MARS) can improve application response time and user satisfaction.

Session 5: Designing Caching Strategies for Database Applications
This session describes how to optimise system resources by caching data and objects in the appropriate layers.

Session 6: Designing a Scalable Data Tier for Database Applications
This session describes how to assess scalability needs and design the best architecture to scale the system to meet those needs.

Who Should Attend

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.

Prerequisites

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 Transact-SQL
• Course 2779: Implementing a Microsoft SQL Server 2005 Database
• Course 2780: Maintaining a Microsoft SQL Server 2005 Database

see less

Choose from 3 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

CompTIA A+ Practical Application exam code 220-702 (Part 2)
CompTIA A+ Practical Application exam code 220-702 (Part 2)
6 sessions available starting from $3,000.00
Developing Web Applications Using Microsoft Silverlight 2.0
Developing Web Applications Using Microsoft Silverlight 2.0
3 sessions available starting from $2,490.00
Microsoft Project 2003 Course | Level 2
Microsoft Project 2003 Course | Level 2
1 session available for $800.00

see all listings »


Found In