السلام عليكم ورحمة الله وبركاته
اخواني انا اتفقت مع واحد طبعا راح يدرسني على هذه البرمجة لمدة 3 شهور
طبعا ابي استفسر عن هذه البرمجة
وعن المبلغ وعن الشهادة
طبعا قال راح يدرسني كل يوم 3 ساعات تقريبا
ومعي مجموعة من الزملاء
قال تقدر تاخذ شهادة من مايكروسوفت طبعا يقول تروح لاي معهد ويختبرك ويعطيك الشهادة بعد ثلاث شهور من الدراسة !
ويرسلون لمايكروسوفت عشان الشهادة
طبعا المبلغ قال 2300 ريال شهرياً
وهذه نبذة من الي ارسله علينا
وهل تنصحونني بهذا او اترك هذه البرمجة
وهل البرمجة جيدة او غير جيدة
Exam 70-431: Microsoft SQL Server 2005 - Implementation and Maintenance ;MCTS, MCAD (total 175 hours - 9 cources series (8MS+1CIW) );
1*course 2779: Implementing a Microsoft SQL Server 2005 Database ;Cource Details
Module 1: Creating Databases and Database Files
Lesson 1: Creating Databases
Lesson 2: Creating Filegroups
Lesson 3: Creating Schemas
Lesson 4: Creating Database Snapshots
Lab: Creating a Database
Module 2: Creating Data Types and Tables
Lesson 1: Creating Data Types
Lesson 2: Creating Tables
Lesson 3: Creating Partitioned Tables
Lab: Creating Data Types and Tables
Module 3: Using XML
Lesson 1: Retrieving XML by Using FOR XML
Lesson 2: Shredding XML by Using OPENXML
Lesson 3: Using the xml Data Type
Lab: Working with XML
Module 4: Creating and Tuning Indexes
Lesson 1: Planning Indexes
Lesson 2: Creating Indexes
Lesson 3: Optimizing Indexes
Lesson 4: Creating XML Indexes
Lab: Creating Indexes
x Course 2779A: Implementing a Microsoft SQL Server 2005 Database
Module 5: Implementing Data Integrity
Lesson 1: Data Integrity Overview
Lesson 2: Implementing Constraints
Lesson 3: Implementing Triggers
Lesson 4: Implementing XML Schemas
Lab: Implementing Data Integrity
Module 6: Implementing Views
Lesson 1: Introduction to Views
Lesson 2: Creating and Managing Views
Lesson 3: Optimizing Performance by Using Views
Lab: Implementing Views
Module 7: Implementing Stored Procedures and Functions
Lesson 1: Implementing Stored Procedures
Lesson 2: Creating Parameterized Stored Procedures
Lesson 3: Creating Functions
Lesson 4: Handling Errors
Lesson 5: Controlling Execution Context
Lab: Implementing Stored Procedures and Functions
Module 8: Implementing Managed Code in the Database
Lesson 1: Introduction to the SQL Server Common Language Runtime
Lesson 2: Importing and Configuring Assemblies
Lesson 3: Creating Managed Database Objects
Lab: Implementing Managed Code in the Database
Module 9: Using Service Broker
Lesson 1: Service Broker Overview
Lesson 2: Creating Service Broker Objects
Lesson 3: Sending and Receiving Messages
Lab: Implementing a Service Broker Solution
2*course 2780: Maintaining a Microsoft SQL Server 2005 Database;
Module 1: Installing and Configuring SQL Server 2005Cource Details
Lesson: Preparing to Install SQL Server
Lesson: Installing SQL Server
Lesson: Managing a SQL Server 2005 Installation
Lab: Installing SQL Server 2005
Module 2: Managing Databases and Files
Lesson: Planning Databases
Lesson: Creating Databases
Lesson: Managing Databases
Lab: Creating a Database
Module 3: Managing Security
Lesson: Overview of SQL Server Security
Lesson: Securing the Server Scope
Lesson: Securing the Database Scope
Lesson: Managing Keys and Certificates in SQL Server
Lab: Securing SQL Server
Exercise 1: Creating Logins
Exercise 2: Creating and Managing Users
If Time Permits: Using a Certificate to Encrypt Data
Module 4: Disaster Recovery
Lesson: Backing Up User Databases
Lesson: Restoring User Databases
Lesson: Recovering Data From Database Snapshots
Lesson: System Databases and Disaster Recovery
Lesson: System Databases and Disaster Recovery
Lab: Implementing a Disaster Recovery Strategy
Lab: Implementing a Disaster Recovery Strategy
Exercise 1: Implementing a Backup Strategy
Exercise 2: Restoring Databases
If Time Permits: Restore the master Database
Module 5: Monitoring SQL Server
Lesson: Viewing Current Activity
Lesson: Using SQL Server Profiler
Lesson: Using SQL Server Profiler
Lesson: Using DDL Triggers
Lesson: Using Event Notifications
Demonstration: Implementing Event Notifications
Exercise 1: Monitoring SQL Server Performance
Exercise 2: Tracing SQL Server Activity
Exercise 3: Implementing DDL Triggers
Module 6:Transferring Data
Lesson: Overview of Data Transfer
Lesson: Introduction to SQL Server Integration Services
Lesson: Using SQL Server Integration Services
Lab: Transferring Data By Using SQL Server Integration Services
Module 7: Automating Administrative Tasks
Lesson: Automating Administrative Tasks in SQL Server 2005
Lesson: Configuring SQL Server Agent
Lesson: Configuring SQL Server Agent
Lesson: Creating Jobs and Operators
Lesson: Creating Alerts
Lesson: Managing Multiple Servers
Lesson: Managing SQL Server Agent Security
Lab: Automating Database Administration
Lab: Automating Database Administration
Module 8: Maintaining High Availability
Lesson: Introduction to High Availability
Lesson: Implementing Server Clustering
Lesson: Implementing Database Mirroring
Lesson: Implementing Log Shipping
Lab: Configuring Database Mirroring
Module 9: Introduction to Replication
Lesson 1: Overview of Replication
Lesson 2: Replication Scenarios
These 2 course has the following prerequisites cources:
a-- Database Design course;
■ A working knowledge of relational databases. For example, relational theory, Set
theory, and the difference between a database and a spreadsheet.
■ Experience with database design. Specifically, you must fully understand Third
Normal Form (3NF), be able to design a database to 3NF (fully normalized), and
know the tradeoffs when backing out of the fully normalized design
(denormalization—that is, designing for performance and or business
requirements).
Exam 70–305*: Developing and Implementing Web Applications with Microsoft Visual VB .NET and Microsoft Visual Studio .NET;
1*course 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET;
Module 1: Overview of the Microsoft .NET FrameworkCource Details
This module introduces the conceptual framework of the.NET Framework and ASP.NET.
Lessons
1 Introduction to the .NET Framework
2 Overview of ASP.NET
3 Overview of the Lab Application
4 Resources
There is no lab for this module
Module 2: Using Microsoft Visual Studio .NET
This module explains how to create new projects, and how to use the primary features that are available in Visual Studio .NET.
Lessons
1 Overview of Visual Studio .NET
2 Creating an ASP.NET Web Application Project
Lab 2: Using Microsoft Visual Studio .NET
3 Creating an ASP.NET Web Application Project Using Visual Studio .NET
Module 3: Using Microsoft .NET-Based Languages
This module will introduce the various languages that support .NET. This module will focus on Visual Basic .NET and C#. Students will use Visual Studio .NET to create a class project and write code in either Visual Basic .NET or C#.
Lessons
1 Overview of the .NET-Based Languages
2 Comparison of the .NET-Based Languages
3 Creating a Component Using Visual Studio .NET
Lab 3: Building a Microsoft Visual Studio .NET Component
4 Create a new project in Visual Studio .NET for a Visual Basic class
Module 4: Creating a Microsoft ASP.NET Web Form
This module explains how to create and display an ASP.NET Web Form.
Lessons
1 Creating Web Forms
2 Using Server Controls
Lab 4: Creating a Microsoft ASP.NET Web Form
3 Creating the default.aspx Web Form
4 Creating the life.aspx Web Form
Module 5: Adding Code to a Microsoft ASP.NET Web Form
This module explains how to add event procedures to an ASP.NET Web application and add server controls on an ASP.NET Web Form. Examples will be show in Visual Studio .NET.
Lessons
1 Using Code-Behind Pages
2 Adding Event Procedures to Web Server Controls
3 Using Page Events
Lab 5: Adding Functionality to a Web Application
4 Creating a Page_Load Event Procedure
5 Creating a Click Event Procedure
Module 6: Tracing in Microsoft ASP.NET Web Applications
This module explains how to use the Trace feature and the Debug object in Visual Studio .NET. Students will learn about the two tracing techniques in ASP.NET: page-level tracing and application-level tracing. Students will also learn how use the debugger to create breakpoints, set watch variables, and step between pages and components in a Web application.
Lessons
1 Understanding Tracing
2 Remote Debugging
Lab 6: Tracing in Microsoft ASP.NET Web Applications
3 Using Trace Statements
4 Tracing into a Component
Module 7: Validating User Input
This module explains how to use the client-side and server-side validation controls to screen data.
Lessons
1 Overview of User Input Validation
2 Using Validation Controls
3 Page Validation
Lab 7: Validating User Input
4 Using RequiredFieldValidator Controls
5 Using the ValidationSummary Control
6 Using the CompareValidator Control
7 Using the RegularExpressionValidator Control
Module 8: Creating User Controls
This module explains user controls and how to create them.
Lessons
1 Adding User Controls to an ASP.NET Web Form
2 Creating User Controls
Lab 8: Creating User Controls
3 Creating a User Control
4 Using the User Control
Module 9: Accessing Relational Data Using Microsoft Visual Studio .NET
This module explains a conceptual overview of the objects in ADO.NET.
Lessons
1 Overview of ADO.NET
2 Creating a Connection to the Database
3 Displaying a DataSet in a List-Bound Control
Lab 9: Accessing Data Using Microsoft Visual Studio .NET
4 Connecting to a Database
5 Paging and Selection in a DataGrid Control
Module 10: Accessing Data with Microsoft ADO.NET
This module explains how to manually add data access tools to a Web application.
Lessons
1 Introduction to Using ADO.NET
2 Connecting to a Database
3 Accessing Data with DataSets
4 Using Multiple Tables
5 Accessing Data with DataReaders
Lab 10: Accessing Data with Microsoft ADO.NET
6 Using a SqlDataReader
7 Viewing Data from the Database
Module 11: Calling Stored Procedures with Microsoft ADO.NET
This module covers the more advanced and complicated features of ADO.NET.
Lessons
1 Overview of Stored Procedures
2 Calling Stored Procedures
Lab 11: Calling Stored Procedures with Microsoft ADO.NET
3 Calling Stored Procedures with Microsoft ADO.NET
Module 12: Reading and Writing XML Data
This module explains the methods that can be used for reading data from XML files.
Lessons
1 Overview of XML Architecture in ASP.NET
2 XML and the DataSet Object
3 Working with XML Data
4 Using the XML Web Server Control
Lab 12: Reading XML Data
5 Reading a List from an XML File
6 Reading, Transforming, and Displaying XML
7 Nested Data
Module 13: Consuming and Creating XML Web Services
This module explains the steps that are necessary to access a Web service from an ASP.NET page and then incorporate that data into the Web application.
Lessons
1 Overview of Using XML Web Services
2 Calling an XML Web Service by HTTP
3 Using a Proxy to Call an XML Web Service
4 Creating an XML Web Service
Lab 13: Creating a XML Web Service
5 Create an XML Web service
6 Create an XML Web service method
7 Consume an XML Web service method
Module 14: Managing State
This module explains the several methods that are available for storing application and session data, for both short- and long-term storage.
Lessons
1 State management
2 Application and Session Variables
3 Cookies and Cookieless Sessions
Lab 14: Storing Application and Session Data
4 Using Session Variables
5 Using Cookies
6 Using Application Variables
7 Storing Session Variables in a Database
Module 15: Configuring, Optimizing, and Deploying a Microsoft ASP.NET Web Application
This module explains how to configure and deploy an ASP.NET Web application.
Lessons
1 Using the Cache Object
2 Using ASP.NET Output Caching
3 Configuring an ASP.NET Web Application
4 Deploying an ASP.NET Web Application
Lab 15: Configuring, Optimizing, and Deploying a Microsoft ASP.NET Application
5 Using the Cache object
6 Using the Page Output Cache
7 Partial Page Caching
8 Using Dynamic Properties
9 Deploying Your Site
Module 16: Securing a Microsoft ASP.NET Web Application
This module explains how to secure a Web application by using a variety of technologies.
Lessons
1 Web Application Security Overview
2 Working with Windows-Based Authentication
3 Working with Forms-Based Authentication
4 Overview of Microsoft Passport Authentication
Lab 16: Securing a Microsoft ASP.NET Web Application
5 Securing Your Web Site Using Windows-Based Authentication
6 Securing Your Web Site Using Forms-Based Authentication
7 Registering New Users
8 Permitting Users to Sign Out
2*course 2389: Programming with Microsoft ADO.NET;
Module 1: Data-Centric Applications and ADO.NETCource Details
The following topics are covered in this module:
1 Design of Data-Centric Applications
2 ADO.NET Architecture
3 ADO.NET and XML
4 Lab 1.1: Data-Centric Applications and ADO.NET
Module 2: Connecting to Data Sources
The following topics are covered in this module:
1 Choosing a .NET Data Provider
2 Defining a Connection
3 Managing a Connection
4 Handling Coonection Exceptions
5 Connection Pooling
Lab 2.1: Connecting to Data Sources
Module 3: Performing Connected Database Operations
The following topics are covered in this module:
1 Working in a Connected Environment
2 Building Command Objects
3 Executing Commands That Return a Single Value
4 Executing Commands That Return Rows
5 Executing Commands That Do Not Return Rows
6 Using Transactions
Lab 3.1: Performing Connected Database Operations
Module 4: Building DataSets
The following topics are covered in this module:
1 Working in a Disconnected Environment
2 Building DataSets and DataTables
3 Binding and Saving a DataSet
4 Defining Data Relationships
5 Modifying Data in a DataTable
6 Sorting and Filtering
Lab 4.1: Building, Binding, Opening, and Saving DataSets
Lab 4.2: Manipulating DataSets
Module 5: Reading and Writing XML with ADO.NET
The following topics are covered in this module:
1 Creating XSD Schemas
2 Loading Schemas and Data into DataSets
3 Writing XML from a DataSet
Lab 5.1: Working with XML Data in ADO.NET
Module 6: Building DataSets from Existing Data Sources
The following topics are covered in this module:
1 Configuring a DataAdapter to Retrieve Information
2 Populating a DataSet Using a DataAdapter
3 Configuring a DataAdapter to Update the Underlying Data Source
4 Persisting Changes to a Data Source
5 How to Handle Conflicts
Lab 6.1: Retrieving Data into a Disconnected Application
Lab 6.2: Retrieving and Updating Customers and Orders Data
Module 7: Building and Consuming a Web Service That Uses ADO.NET
The following topic is covered in this module:
1 Building and Consuming a Web Service That Returns Data
Lab 7.1: Troubleshooting an ADO.NET Application
These 2 course has the following prerequisites cources:
-- Knowledge of Hypertext Markup Language (HTML) or dynamic HTML
(DHTML), including:
• Tables
• Images
• Forms
a-- course : Introduction to Visual Basic® .NET Programming with Microsoft® .NET;
Module 1: Getting StartedCource Details
Overview .................................................................................................... .............1
Multimedia: Tour of Visual Studio .NET................................................................2
Lesson: Basic .NET Concepts .................................................................................3
Lesson: Exploring the Development Environment................................................17
Lesson: Creating a Visual Basic .NET Project......................................................30
Review.............................................................................................. .....................37
Lab 1.1: Creating Your First Application..............................................................39
Module 2: Working with Forms and Controls
Overview .................................................................................................... .............1
Multimedia: What Are Objects, Properties, Methods, and Events? ........................2
Lesson: Understanding Programming Concepts......................................................3
Lesson: Working with Windows Forms ..................................................................9
Lesson: Working with Controls.............................................................................24
Lesson: Styling Your Code....................................................................................39
Review.............................................................................................. .....................45
Lab 2.1: Creating the User Interface......................................................................47
Module 3: Using Variables and Arrays
Overview .................................................................................................... .............1
Multimedia: What Are Variables?...........................................................................2
Lesson: Introduction to Data Types.........................................................................4
Lesson: Using Variables........................................................................................10
Lesson: Variable Scope .........................................................................................20
Lesson: Converting Data Types ............................................................................31
Lab 3.1: Creating and Using Variables..................................................................37
Lesson: Creating and Using Structures..................................................................43
Lesson: Storing Data in Arrays .............................................................................52
Review.............................................................................................. .....................60
Lab 3.2: Using Structures and Arrays....................................................................63
Module 4: Working with Procedures
Overview .................................................................................................... .............1
Lesson: Creating Procedures ...................................................................................2
Lesson: Using Procedures .....................................................................................21
Lesson: Using Predefined Functions .....................................................................36
Review.............................................................................................. .....................51
Lab 4.1: Creating and Using Procedures ...............................................................53
Module 5: Decision Structures and Loops
Overview .................................................................................................... .............1
Lesson: Using Conditional Expressions ..................................................................2
Lesson: Using Decision Structures........................................................................14
Lab 5.1: Using Decision Structures .......................................................................21
Lesson: Using Conditional Loop Structures..........................................................25
Review.............................................................................................. .....................37
Module 6: Validating User Input
Overview .................................................................................................... .............1
Multimedia: Validating User Input..........................................................................2
Lesson: Restricting User Input ................................................................................4
Lesson: Validating Field Data ...............................................................................17
Lesson: Validating Form Data...............................................................................29
Review.............................................................................................. .....................36
Lab 6.1: Validating User Input ..............................................................................38
Module 7: Object-Oriented Programming in Visual Basic .NET
Overview .................................................................................................... .............1
Multimedia: Introduction to Object-Oriented Concepts ..........................................2
Lesson: Understanding Classes ...............................................................................3
Lesson: Working with Classes.................................................................................8
Lesson: Using Shared Members ............................................................................21
Lesson: Inheritance, Polymorphism, and Namespaces..........................................27
Review.............................................................................................. .....................35
Lab 7.1: Creating a Derived Class.........................................................................37
Module 8: Handling Errors and Exceptions
Overview .................................................................................................... .............1
Lesson: Types of Errors...........................................................................................2
Lesson: Using the Debugger....................................................................................8
Lesson: Handling Exceptions ................................................................................31
Review.............................................................................................. .....................42
Lab 8.1: Implementing Structured Exception Handling........................................44
Module 9: Enhancing the User Interface
Overview .................................................................................................... .............1
Lesson: Creating Menus ..........................................................................................2
Lesson: Creating Status Bars .................................................................................14
Lesson: Creating Toolbars.....................................................................................21
Review.............................................................................................. .....................31
Module 10: Deploying Applications
Overview .................................................................................................... .............1
Lesson: Introduction to Deployment .......................................................................2
Lesson: Deploying a Windows-based Application................................................10
Review.............................................................................................. .....................21
Lab 12.1: Deploying an Application .....................................................................23
Course Evaluation .................................................................................................28
Exam 70–310*: Developing XML Web Services and Server Components with Microsoft Visual Basic.NET and the Microsoft .NET Framework;
1*course 2524: Developing XML Web Services Using Microsoft ASP.NET;
Module 1: The Need for XML Web ServicesCource Details
The following topics are covered in this module:
Lessons
1 Evolution of Distributed Applications
2 Problems with Traditional Distributed Applications
3 Introducing XML Web Services
4 The Web Technology Stack and .NET
5 The .NET Alternatives to XML Web Services
6 Common XML Web Service Scenarios
Module 2: XML Web Service Architectures
The following topics are covered in this module:
Lessons
1 Service-Oriented Architecture
2 XML Web Service Architectures and Service-Oriented Architecture
3 Roles in an XML Web Services Architecture
4 The XML Web Services Programming Model
Module 3: The Underlying Technologies of XML Web Services
The following topics are covered in this module:
Lessons
1 HTTP Fundamentals
2 Using HTTP with the .NET Framework
3 XML Essentials
4 XML Serialization in the .NET Framework
5 SOAP Fundamentals
6 Using SOAP with the .NET Framework
Module 4: Consuming XML Web Services
The following topics are covered in this module:
Lessons
1 WSDL Documents
2 XML Web Service Discovery
3 XML Web Service Proxies
4 Implementing an XML Web Service Consumer Using Visual Studio .NET
Module 5: Implementing a Simple XML Web Service
The following topics are covered in this module:
Lessons
1 Creating an XML Web Service Project
2 Implementing XML Web Service Methods
3 Managing State in an ASP.NET XML Web Service
4 Debugging XML Web Services
Module 6: Publishing and Deploying XML Web Services
The following topics are covered in this module:
Lessons
1 Overview of UDDI
2 Publishing an XML Web Service
3 Finding an XML Web Service
4 Publishing an XML Web Service on an Intranet
5 Configuring an XML Web Service
Module 7: Securing XML Web Services
The following topics are covered in this module:
Lessons
1 Overview of Security
2 Built-In Authentication
3 Custom Authentication: SOAP Headers
4 Authorization: Role-Based Security
5 Authorization: Code Access Security
6 Encryption
Module 8: Designing XML Web Services
The following topics are covered in this module:
Lessons
1 Datatype Constraints
2 Performance
3 Reliability
4 Versioning
5 HTML Screen Scraping XML Web Services
6 Aggregating XML Web Services
Module 9: Global XML Web Services Architecture
The following topics are covered in this module:
Lessons
1 Introduction to GXA
2 Routing and Referral
3 Security and Licensing
This course has the following prerequisites cource:
a-- course :Introduction to XML and the Microsoft® .NET Platform;
Module 1: The Microsoft .NET Platform and XMLCource Details
Overview
Lesson: XML in the .NET Platform
Lesson: XML as a W3C Standard
Module 2: Basic XML
Overview
Lesson: The Form of XML
Lesson: Designing an XML Vocabulary
Lesson: Namespaces
Lab 2: Designing an XML Vocabulary
Review
Module 3: Validating XML
Overview
Lesson: Introducing Validation
Lesson: Using XSD Schemas
Quiz
Lab 3: Using Office XP to Generate a Schema
Module 4: Technologies for Handling XML Data
Overview
Lesson: Metadata and XML Processing
Lesson: XML Processing Technologies
Module 5: Creating and Manipulating Trees Using DOM
Overview
Lesson: How Does DOM Work?
Lesson: Using DOM and the .NET Framework XML Classes
Lab 5: Changing a DOM Tree
Review
Module 6: Using XPath to Navigate a Tree of Nodes
Overview
Lesson: What Is XPath
Lesson: Using XPath
Lesson: The Range of Application of XPath
Lab 6: Using XPath to Navigate and Select Data
Review
iv Introduction to XML and the Microsoft® .NET Platform
Module 7: Formatting and Transforming: XSL and XSLT
Overview
Lesson: Defining XSL
Lesson: Transforming XML Using XSLT
Lesson: XSLT in the Microsoft .NET Framework
Lab 7: Creating and Editing XSLT in FrontPage 2002 and Visual Studio .NET
Review
Module 8: Using XQuery to Link and Query XML Documents
Overview
Lesson: What Is XQuery?
Lesson: Using XQuery
Lab 8: Using Simple and Advanced XQuery Expressions
Review
Course Evaluation
Module 9: SQL XML
Overview
Lesson: XML Support in SQL Server 2000
Lesson: Using HTTP to Access and Input XML Data
Lab 9: Creating SQL Queries Using XML
Review
Module 10: The Challenge of Designing XML Solutions
Overview
Lesson: Solutions That Use XML
Lesson: XML Web Services
Lesson: What Is Next?
Lab 10: Building a Menu System
Review
2*course 2257: Building COM+ Applications Using Microsoft .NET Enterprise Services;
Module 1: Introduction to COM+ ServicesCource Details
This module covers the evolution of applications from monolithic applications to client/server applications to component-based applications and the supporting application infrastructure that COM+ services provides. The module also covers the COM+ runtime architecture and how it uses surrogates, context, and interception to provide services to components.
Lessons
1 History of Server-Based Applications
2 The COM+ Runtime Architecture
Module 2: Configuring Just-in-Time Activation and Synchronization
This module describes the attributes that you can assign to components and how to write a serviced component. This module also describes how to access the object context from within code, JIT activation, synchronization, the relationship between synchronization and JIT activation, and how you can set JIT activation and synchronization for a component.
Lessons
1 The .NET Enterprise Services Programming Model
2 Just-in-Time Activation
3 Synchronization
Lab 2: Configuring Just-in-Time Activation
4 Exercise 1: Creating a Serviced Component
5 Exercise 2: Using a Serviced Component
Module 3: Using ADO.NET to Work With Data
This module describes how to run a query and retrieve a result set by using ADO.NET. The module also covers how to pass parameters to a stored procedure, create typed DataSet objects, and use construction strings to specify connection information to establish a connection to a data source.
Lessons
1 The ADO.NET Architecture
2 Accessing a SQL Server Database
Lab 3: Using ADO.NET in a Serviced Component
3 Exercise 1: Creating a New Typed Dataset
4 Exercise 2: Updating the PurchasingSelect Component
5 Exercise 3: Updating the OrderProcessing Component
6 Exercise 4: Modifying the PlaceOrder Web Page
Module 4: Transaction Services
This module describes transaction processing, how it is implemented in .NET Enterprise Services, and how you add attributes to code to enable transaction processing.
Lessons
1 Introduction to Transaction Processing
2 .NET Enterprise Services Transactions
Lab 4: Using Transaction Services
3 Exercise 1: Creating a Transactional Component
4 Exercise 2: Updating the OrderProcessing Component
5 Exercise 3: Updating the OrderApp Web Application
6 Exercise 4: Testing with the OrderApproval Client
Module 5: Securing Enterprise Applications
This module explains how to implement COM+ role-based security in serviced components by using .NET Enterprise Services.
Lessons
1 Introduction to Application Security
2 Implementing COM+ Role-Based Security
3 Authentication and Impersonation
Lab 5: Securing Enterprise Applications
4 Exercise 1: Updating the PurchasingUpdate component
5 Exercise 2: Updating the OrderProcessing Component
6 Exercise 3: Updating the OrderApproval Client
Module 6: State Management
This module describes how to manage state in .NET Enterprise Services. It explains how to use the Shared Property Manager (SPM) to store state, use ASP.NET applications to store application and session state, and use ASP.NET caching.
Lessons
1 Introduction to State Management
2 Using the Shared Property Manager
3 Using ASP.NET to Store State
Lab 6: Managing Component State
4 Exercise 1: Updating the OrderProcessing Component
Module 7: Compensating Resource Managers
This module describes the architecture of CRMs and how to implement CRMs.
Lessons
1 Introduction to Compensating Resource Managers
2 Implementing Compensating Resource Managers
Lab 7: Implementing Compensating Resource Managers
3 Exercise 1: Creating the OrderDocCRM Component
4 Exercise 2: Updating the OrderProcessing Component
Module 8: Loosely Coupled Events
This module describes the architecture of LCEs and the LCE system. This module also describes how to configure and implement publishers, subscribers, and event classes.
Lessons
1 Introduction to Loosely Coupled Events
2 COM+ Events
3 Using Loosely Coupled Events
Lab 8: Using Loosely Coupled Events
4 Exercise 1: Creating an Event Class
5 Exercise 2: Creating a Publisher
6 Exercise 3: Creating a Subscriber
Module 9: Queued Components
The following topics are covered in this module:
Lessons
1 Introduction to Queuing
2 Developing Queued Components
3 Queued Components and Transactions
Lab 9: Creating a Queued Component
4 Exercise 1: Creating a Queued Component
5 Exercise 2: Calling the Queued Component
Module 10: Debugging COM+ Applications
In this module, you will learn how to debug applications that use .NET Enterprise Services.
Lessons
1 Debugging Tools
2 Common Debugging Scenarios
Lab 10: Debugging COM+ Applications
3 Exercise 1: Debugging DCOM Problems
4 Exercise 2: Debugging Transaction Problems
5 Exercise 3: Debugging Security Problems
Module 11: Deploying and Administering COM+ Applications
This module introduces the COMAdmin objects and additional techniques and tools for deploying and administering COM+ applications. It describes the advantages and drawbacks of each technique so those students can select the one most appropriate for your application.
Lessons
1 Deploying a COM+ Application Built Using .NET Enterprise Services
2 Using COMAdmin Objects in WSH Scripts
Lab 11: Administering COM+ Applications
3 Exercise 1: Creating a COM+ Application
4 Exercise 2: Adding a Role to a COM+ Application
5 Exercise 3: Deleting a COM+ Application
6 Exercise 4 (Optional): Exposing a COM+ Application as an XML Web Service
7 Exercise 5 (Optional): Creating the OrderDispatch Service
Module 12: COM+ 1.5 Enhancements
This module explains how to use new COM+ version 1.5 features that help you manage, scale, and maximize the uptime of your COM+ application more efficiently. The module also explains how to use .NET Enterprise Services without having to implement serviced components.
Lessons
" Scalability and Availability Enhancements " Manageability Enhancements " Other COM+ Features