Diplomas
Certificates
Courses

MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Call our Sales
   Clients Testimonials
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   Advanced Data Access with Microsoft Visual Studio 2005

Admission

This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.


Advanced Data Access with Microsoft Visual Studio 2005
Exam # Duration Language Level Type Classroom Code Fees
-- 18 English Professional Course Classroom Cs357 0 LE
Description :

This course provides students with the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005. The workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).



Objectives :
  • Minimize and handle database operation conflicts
  • Handle large objects
  • Enhance database performance
  • Create managed code objects for SQL Server 2005
  • Query XML by using XPath
  • Transform XML by using XSLT style sheets


Topics :

Minimizing and Handling Database Operation Conflicts

  • Why Do Data Conflicts Arise?
  • Isolation Levels Available in SQL Server 2005
  • Guidelines for Using SQL Server 2005 Isolation Levels

Handling Large Objects

  • What Are Binary Large Objects and Character Large Objects?
  • The Process for Reading Large Objects from a Database
  • The Process for Writing Large Objects to a Database

Enhancing Database Performance

  • ADO.NET Enhancements in the .NET Framework 2.0
  • SQL Server Provider Statistics

Creating Managed Code Objects for SQL Server 2005

  • The Benefits of Creating Managed Code Objects
  • Demonstration: The Process for Importing an Existing Assembly into SQL Server 2005
  • Demonstration: The Process for Implementing Managed Code Objects in SQL Server 2005

Querying XML by Using XPath

  • The XPath Data Model
  • The Process for Selecting and Editing XML Data by Using XPathNavigator
  • The Process for Evaluating XPath Expressions by Using XPathNavigator

Transforming XML by Using XSLT Style Sheets

  • What Is XSLT?
  • The Process for Executing an XSLT Style Sheet
  • What Are Extension Objects?




Recommended Knowledge :

Before attending this workshop, students must: Have attended or studied Workshop 2541, Core Data Access with Microsoft Visual Studio 2005, or possess equivalent knowledge and skills; Know how to use delegates; Be able to use database stored procedures, triggers, and aggregates; Be able to explain XPath concepts and basic syntax; Be able to explain XSLT style sheet concepts.

Recommended Course(s) :

 Core Data Access with Microsoft Visual Studio 2005


Training Materials :

Microsoft Official Courseware (MOC)


Labs :

This course includes several labs to ensure you will gain the targeted skills and experience


Credential :

•Microsoft Certified Technology Specialist (MCTS): .NET Framework 2.0 Windows Applications

•Microsoft Certified Technology Specialist (MCTS): .NET Framework 2.0 Web Applications

•MCPD: Designing and Developing Windows Applications by Using the Microsoft .NET Framework

•MCPD: Designing and Developing Web-Based Applications by Using the Microsoft .NET Framework

Category :
Programming


The Instructor:
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.