Databases

Oracle DBA Training

Architecture & Configuration

1. Overview of Oracle DBA tasks

  • Oracle as a flexible, complex & robust RDBMS
  • He evolution of hardware and the relation to Oracle
  • Different DBA job roles(VP of DBA, developer DBA, production DBA, database babysitter)
  • The changing job role of the Oracle DBA
  • Environment management (network, CPU, disk and RAM)
  • Instance management (managing SGA regions)
  • Oracle table and index management

2. Instance Architecture

  • Instance vs. database
  • Components of an instance
  • Creating the OFA file structure ($DBA, bdump, udump, pfile)

3. Oracle Instance Internals

  • SGA vs. PGA
  • Background processes
  • Interfaces with server and disk I/O subsystem

4. Using SQL*Plus for DBA management

  • Connecting and executing SQL
  • Using the “as sysdba” syntax
  • Overview of SQL*Plus DBA commands (startup, etc.)

5. Control file, UNDO and REDO management

  • Explaining the use of control files
  • Listing the Contents of the control File
  • File locations for control Files
  • Obtaining Control File Information
  • Listing control file contents
  • Displaying and Creating Undo segments
  • Altering Undo Segments
  • Determining the Number and Size of Undo segments
  • Understanding flashback technology
  • Troubleshooting Undo – snapshot too old
  • Redo log concepts for recovery
  • Online redo log (log_buffer) online redo logs and archived redo logs
  • Oracle ARCH and LGWR background processes
  • Redo log dictionary queries
  • Redo log switch frequency and performance
  • Multiplexing the Online Redo Log Files
  • Archiving the Oracle Redo Logs
  • Recovery using the redo log files

6. User and privilege management

  • Creating New Database Users
  • Using pre-spawned Oracle connections
  • Auditing User activity
  • Identifying System and Object Privileges
  • Granting and Revoking Privileges
  • Creating and Modifying Roles
  • Displaying user security Information from the Data Dictionary

Oracle object management
1. Oracle tables, views and materialized views

  • Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables)
  • Oracle Views
  • Oracle materialized views

2. Oracle indexes

  • Types of Oracle indexes (b-tree, bitmap, bitmap join index)
  • Creating B*-Tree, bitmap and function-based Indexes
  • Function-based indexes
  • Finding indexing opportunities
  • Index maintenance

3. Oracle constraints

  • Costs & benefits of constraints
  • Types of Oracle indexes constraints (check, not null, unique, PK, FK)
  • Cascading constraints

4. Schema, File & tablespace management

  • Describing the relationship between data files, tablespaces and table
  • Understanding Oracle segments
  • Creating Tablespaces – using the autoextend option
  • Changing the Size of Tablespaces – alter database data file command
  • Defining a TEMP tablespace
  • Changing the default storage Settings for a tablespace
  • Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists).
  • Monitoring Chained rows (fetch continued rows)
  • Monitoring Insert and Update performance (pctused, APPEND)

5. Database Maintenance

  • Reason for reorgs – chained rows, imbalanced freelists
  • Reorganizing Tables using Export and Import
  • Using CTAS to reorganize data
  • Index rebuilding
  • Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking)

6. Oracle DBA Utilities

  • Data pump (Imp and exp utilities)
  • SQL*Loader
  • LogMiner
  • Flashback
  • Introduction Data Guard
  • Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
  • Introduction Replication (Streams, multimaster, materialized views)

Oracle database management
1. Overview of instance management

  • Parameter files (init.ora, listener.ora, tnsnames.ora
  • Rules for sizing SGA components
  • Automated Oracle memory management (AMM)

2. Initialization file management

  • Creating the init.ora file
  • Using spfile
  • Displaying init.ora values with v$parameter

3. Oracle*Net configuration

  • Creating the listener.ora file
  • Creating the tnsnames.ora file

4. Data buffer configuration & sizing

  • Inside the Oracle data buffers
  • Using the KEEP pool
  • Monitoring buffer effectiveness
  • Using multiple blocksizes (multiple buffer pools)

5. Shared pool and PGA configuration & Sizing

  • Shared pool concepts and components
  • Understanding the library cache
  • Relieving shared pool contention
  • Overview of PGA for sorting and hash joins
  • Using sort_area_size, hash_area_size and pga_aggregate_target

6. Troubleshooting network connectivity

  • Verifying network connectivity with ping and tnsping
  • Testing database links

Monitoring Oracle
1. Dictionary and v$ views

  • The dba_, all_ and user_ structures
  • Querying the tables, indexes, and segments views
  • Querying the AWR (STATSPACK) tables

2. Table & index monitoring

  • Monitoring table extents and fragmentation
  • Using the dba_tables and dba_segments views
  • Monitoring table CBO statistics
  • Monitoring table extents and fragmentation
  • Locating chained rows
  • Monitoring table & index growth
  • Monitoring index usage
  • Monitoring index fragmentation
  • Locating un-used indexes
  • Identifying IOT candidates
  • Reorganizing Indexes with alter index rebuild
  • Dropping Indexes
  • Getting Index Information from the Data Dictionary

3. Oracle environment monitoring

  • Displaying and managing Oracle sessions (v$session, v$process)
  • Using AWR to monitor disk, network and CPU consumption
  • Monitoring the alert log
  • Oracle trace/dump files

4. STATSPACK and AWR performance management

  • Installing STATSPACK
  • Running STATSPACK reports
  • Interpreting a STATSPACK report
  • Getting time series reports with STATSPACK
  • Finding performance signatures with STATSPACK

Performance Management
This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck.
1. Bottleneck performance analysis

  • Drill-down into AWR reports
  • Top-5 timed events
  • External Server Bottlenecks (Network, I/O, RAM, CPU)
  • Network troubleshooting

2. Instance Tuning

  • Changing init.ora optimizer parameters (index_optimizer_cost_adj, optimizer_mode)
  • Managing region parameters (shared_pool_size, db_cache_size)
  • Understanding instance contention (e.g. Buffer busy waits, library cache contention)

3. SQL and CBO behavior

  • Introduction to cost-based optimization
  • Changing the default optimizer modes
  • Optimizer parameters
  • Dynamic sampling
  • Collecting table and index statistics (dbms_stats)
  • Using column histograms and skewonly

4. Tracing SQL Execution

  • Using EXPLAIN PLAN
  • Using “set autotrace”
  • Interpreting EXPLAIN PLAN Output
  • Using TKPROF / SQL*Trace

5. SQL Execution Internals

  • Review of Basic joining methods
  • Merge join
  • Hash Join
  • Nested Loop join
  • Advanced SQL operators
  • Between operator

6. SQL Tuning

  • Using hints to improve SQL performance
  • Using parallel query to improve performance
  • SQL reusability within the library cache
  • Table high-water mark
  • Table striping and table partitions
  • Using indexes to improve performance
  • Identifying full-table scans
  • Re-writing SQL queries
  • Tuning sub-queries

7. Oracle High Availability tools

  • Continuous availability and disaster recovery
  • Quantifying the cost of unplanned downtime
  • Oracle multi-master replication
  • Introduction to Data Guard
  • Introduction to Oracle Streams
  • Introduction to Real Application Clusters

8. Backup & Recovery

  • OS-level backups
  • Hardware-level backup & recovery
  • Block-level change tracking
  • Disk mirroring
  • Backup & recovery and RAID level
  • Oracle-level backups (exp, expdp & RMAN)
  • Hot vs. Cold backups
Oracle Forms and reports

 Introduction to PL/SQL
Objectives

  • Describe the building blocks of PL/SQL and its environment
  • Explain the benefits of the basic components of PL/SQL structures
  • Explain the benefits of packages over stand-alone procedures and functions
  • Create various types of triggers
  • Create and use procedures

Topics

  • PL/SQL
  • PL/SQL Structures
  • Packages
  • Triggers
  • Stored Procedures

 Developer/2000 Applications
Objectives

  • Create Oracle Forms templates containing visual attributes, property classes, a toolbar, and triggers
  • Use OLE2 in your application
  • Use Visual Basic Custom Controls to enhance your application
  • Create Oracle Reports templates containing standard headers, trailers, and margin items
  • Create break, drill-down, and integrated application reports using templates and OLE2
  • Add buttons and PL/SQL to drill-down into a detail report
  • Create a report trigger for auditing

Topics

  • Developing Oracle Forms Applications
  • Developing Oracle Reports Applications

 

 Forms 4.5 and Reports 2.5
Objectives

  • Develop a Forms application, a menu, and a library
  • Use the PL/SQL Editor in Oracle Forms
  • Develop tabular and master/detail reports
  • Use the Data Model Editor, Parameter Form Editor, and Program Unit Editor in Oracle Reports

Topics

  • Overview of Oracle Forms
  • Introducing Forms Designer
  • The Layout Editor
  • The PL/SQL and Menu Editors
  • Creating Forms Objects and Libraries
  • Overview of Oracle Reports
  • Introducing Reports Designer
  • The Reports Designer Editors
  • Displaying Report-Style Formats

 

 Graphics 2.5 and Procedure Builder 1.5
Objectives

  • Develop a pie chart and a column chart
  • Use the Chart Template Editor in Oracle Graphics
  • Develop functions, procedures, packages, and database triggers
  • Use the Database Trigger Editor in Oracle Procedure Builder

Topics

  • Overview of Oracle Graphics
  • Introducing Graphics Designer
  • The Layout Editor
  • The Chart Template and Program Unit Editors
  • Displaying Chart Types
  • Overview of Procedure Builder
  • Introducing Procedure Builder
  • The Procedure Builder Editors
  • Debugging PL/SQL Program Units

 

 

 Developer/2000 Integration
Objectives

  • Create a parameter-driven display
  • Pass parameters from Oracle Forms to Oracle Graphics
  • Create a format trigger to conditionally modify a chart
  • Import an image file
  • Create multiple environments for development, testing, demonstration, training, and production
  • Recognize GUI styles and standards
  • Optimize memory, disk space, and performance
  • Insert OLE2 objects into an Oracle database

Topics

  • Developing Oracle Graphics Applications
  • Integration and Deployment in the Windows Environment

 Overview of Developer/2000
Objectives

  • Navigate the menus and toolbars of the development environment
  • Describe the features available for editing and debugging an application
  • Explain the features that provide object-orientation, product integration, and OLE2 support

Topics

  • Introducing Oracle Applications
  • The Windows Interface
  • The Object Navigators
  • Setting Object Properties
  • Introducing the Layout Editors
  • Working with Objects in the Layout Editor
  • Introducing the PL/SQL Editors
  • Getting Help
  • Object Orientation and OLE2
SQL Server 2008 Training

 

SQL Server 2005 & 2008 Overview

  • Availability and Scalability Features
  • Security Features
  • Data Management Features
  • Administration and Maintenance Features
  • Development Features
  • To enable SQLiMail
  • Testing mail delivery

Installing SQL Server 2005 & 2008

  • SQL Server 2005 & 2008 Editions
  • Installing Microsoft SQL Server
  • System Requirements
  • Preparing for a SQL 2005 Installation
  • Installation Checklist
  • Setup Features
  • Using the System Consistency Checker
  • Component Install
  • Unattended Installation
  • Installation Sequence
  • Installation Maintenance

Upgrading to SQL Server Management Studio

  • Management Studio Windows
  • Registered Servers
  • Object Explorer
  • Review Database Objects
  • Modify Database Properties
  • Create Database Scripts
  • The Maintenance Plans Node
  • Solution Explorer
  • Query Editor
  • Template Explorer
  • Dynamic Help
  • Upgrading to SQL Server Computer Manager
  • SQL Server 2005 & 2008 Services node
  • SQL Server 2005 & 2008 Network Configuration node
  • SQL Server 2005 & 2008 Native Client Configuration node
  • The SQLCMD Management Utility
  • SQLCMD Syntax
  • SQLCMD Variables
  • Dedicated Administrative Connection
  • SQL Server Management Studio SQLCMD Mode

Monitoring the Database Server

  • Managing Metadata Views
  • Metadata Storage
  • System Views
  • Information Schema
  • Catalog Views
  • Sys All
  • Dynamic Management Views
  • System Stored Procedures

Database and Index Maintenance

  • Index Management
  • New Index Features
  • Creating Indexes
  • Online Index Maintenance
  • Parallel (multiple CPU) Index Operations
  • Lock Options
  • Included Columns in Indexes
  • Partitioned Tables and Indexes
  • XML Index Support
  • Altering an Index
  • Rebuilding an Index
  • Reorganizing an Index
  • Disabling an Index
  • Dropping an Index
  • Index Fragmentation
  • Using the Database Tuning Advisor

Securing SQL Server 2005 & 2008

  • Implementing Securable
  • New Security Features
  • Principals
  • Securable
  • Permissions
  • Permission Types
  • Managing Logins
  • Managing Schemas
  • Managing Users
  • Schema Definition
  • Using Schemas
  • Managing Execution Context
  • Managing Permissions
  • Manage Server Permissions
  • Manage Server-Scope Securable Permissions
  • Manage Database Permissions
  • Manage Database-Scope Securable Permissions
  • Native Data Encryption
  • Code and Module Signing

SQL Server Disaster Recovery

  • Disaster Recovery
  • SQL 2005 Disaster Recovery Feature
  • Enhanced Features
  • Database Snapshots
  • Creating a Snapshot
  • Common Snapshot Applications
  • Undeleting table rows
  • Undoing a table update
  • Recovering a dropped object
  • Backup and Restore
  • Media Integrity Changes
  • Recovering the MASTER Database
  • Create a mirrored backup
  • Restore from the backup mirror
  • Create a snapshot
  • Restore the snapshot data
  • Automate the creation of daily snapshots

Database Availability

  • SQL 2005 Data Availability
  • Database Mirroring
  • The Witness Server and Automatic Failover
  • Configuring Database Mirroring
  • Transaction Safety Level
  • Operating Modes
  • High Availability Operating Mode
  • High Protection Operating Mode
  • High Performance Operating Mode
  • Monitoring Mirroring
  • Database States for Database Mirroring
  • Prepare the Servers
  • Configure Mirroring
  • Verify Principal and Mirror Access
  • Execute the Mirror Failover
  • Verify Mirror and Witness Status
  • Terminating the Mirror Session

Replicating Information

  • Replication Enhancements
  • Stand-alone Replication Monitor
  • Support for Oracle Publishing
  • HTTP Synchronization for Merge Replication
  • Subscriber Initialization
  • Replicating DDL Statements
  • Modified User Interface
  • Replication Management Objects
  • To Configure Publishing and Distribution
  • Configuring Peer-to-Peer Replication
  • Create a Publication
  • Create a Subscription with RMO

SQL Server 2005 & 2008 Integration Services

  • Creating the Database Objects
  • Creating a Package Using Business Intelligence Studio
  • Integration Services Project Template
  • OLE DB Command object
  • Column Mappings
  • Adding a Data Viewer

Monitoring and Performance

  • SQL Server Profiler
  • Optimal Data Storage
  • Diagnostic Tools
  • Query Analyzer
  • Database Engine Tuning Advisor
  • Index Optimization
  • Federated Database Servers
  • Partitioned Indexes
  • Lock Optimization
  • Best Practices for Native XML Web Services
SQL Server Performance & Tuning Course

Optimal Database Design

  • Database Design
  • Table Design
  • Indexes
  • OLTP databases
  • Data Warehouses

Index Optimisation

  • Index Types
  • Covering Indexes
  • Index Strategies

Locking

  • Lock Types
  • Locking & Granularity
  • Blocking
  • Locking & Transactions
  • Transaction Isolation Levels
  • Transaction Design
  • Analysing Locks

Analyzing Queries

  • Query Analyser & Execution Plans
  • SHOWPLAN
  • Graphical
  • Index Statistics
  • Index Tuning Wizard

Tuning SQL Statements

  • Comparing Queries
  • Avoiding Subqueries
  • Table Hints

Database Application Tuning

  • Using Stored Procedures & User Defined Functions
  • Views
  • Partitioning Data
  • Derived Data
  • Minimising Redundant Data With Triggers
  • Optimising Transactions
  • Optimising Cursors

Query Optimisation

  • Query Optimiser
  • Recompilation
  • Query Cache
  • Query Types
  • Range
  • Ordering
  • Grouping
  • Table joins & Join Algorithms

Performance & Tuning

  • Sizing & Planning
  • Monitoring Performance
  • Analyzing Performance Data
  • Tuning & Optimising Performance

SQL Server Internals

  • Windows & SQL Server Architecture
  • Process & Thread management
  • Memory Use & Management
  • I/O Management
  • Networking

SQL Server Architecture

  • Data Storage
  • Transaction Logging
  • Locking
  • Indexing
  • OLTP databases
  • Data Warehouses

Planning A SQL Server Database Application

  • Capacity Planning
  • Sizing Databases
  • Sizing Servers

System Performance & Tuning

  • Hardware Resource Tuning
  • I/O Performance
  • Database Layout
  • SQL Server Configuration Options

Monitoring Tools

  • Performance Monitor
  • SQL Profiler
  • DBCC

Tuning SQL Server Services & Tasks

  • Replication Services
  • DTS Packages
  • Backup & Recovery
 
UNIX Shell Programming

 

Introduction

  • The UNIX Shell The Bourne,
  • Korn & C Shells UNIX Shell Scripts

Review

  • Commands, ls,
  • Redirection, Pipes, Find, Grep, Sort

UNIX Shell Features

  • Invoking a Shell,
  • Command line expansion,
  • Command Arguments,
  • Meta-characters,
  • Quotation marks,
  • Redirection,
  • File descriptors,
  • Here documents, Redirection, Pipes, Tee,
  • Defining Exporting and Environment variables,
  • Command grouping,
  • Conditional execution

Basic Shell Scripts

  • Positional and Automatic Parameters, Set, Reading input, Writing to standard output, Display attributes, Interactive Shell scripts

Bourne & Korn Shell Programming

  • If statement,
  • While statement,
  • Case statement,
  • Test command,
  • For statement,
  • Break statement,
  • Continue statement,
  • Tests on numeric values,
  • String comparisons,
  • Command exit status,
  • Logical operators,
  • Error handling,
  • Arithmetic.

Korn Shell Extensions

  • Extensions,
  • Command substitution,
  • Arithmetic expressions,
  • Valid arithmetic operators,
  • Variable attributes,
  • Typeset, Built-in variables,
  • Select command.
Web logic Server Administration

Web logic Server Basics

  • Understanding TCP/IP and HTTP
  • Web logic Application server
  • Web logic 10.3 Features
  • Web logic system administrator Infrastructure
  • J2EE Components
  • Servlets
  • JSP
  • EJB

Web logic Application  Server Installation and configurations

  • WLS domain Server
  • Machine
  • Cluster
  • Directory structure
  • Starting WLS
  • Upgrading
  • Configuring Domain attributes
  • Configuring server, cluster
  • Service configurations
  • Configuring  JMS options
  • Configuring Database Connectivity
  • Connection Pools, Data Sources and Multi Pools

Application Deployment

  • Auto Deployment
  • Deployment tools
  • Cluster Deployment Load balancing and session replication
  • Setting up a Cluster across multiple machines
  • Weblogic Virtual Hosting
  • Configuring Node Manager, Weblogic Server Logging
  • Weblogic Server threading model and creating own execute queue

Weblogic and J2EE

  • JMS application
  • Configuring JMS
  • Weblogic JNDI

WLS and HTTP servers

  • WLS HTTP server
  • Plug-in

Weblogic Performance Tuning Basics

  • Reduce the application down time OS ,Network tuning Basics
  • Techniques to troubleshoot and fix the OOM, Memory leak, Server Hang, Server Crash problems

Administration Tools

  • Web logic java utilities
  • Licenses,Architecture,Configurations
  • Monitoring alls the domain resources, Servers, Clusters, JMS, Connection pools etc

Application Security

  • Managing Web Logic Security and Security providers Authorization framework
WebSphere Administration

WebSphere Administration Overview

  • WebSphere product family
  • Overview of WebSphere administration
  • Themes in WebSphere administration
  • What’s new with WebSphere 6.1

Installing WebSphere 6.1

  • WebSphere installer overview
  • Graphical installer vs. Silent Installer
  • Installing and Uninstalling WebSphere 6.1
  • Installing WebSphere 6.1 Network Deployment

Profiles and Centralized Configuration Management

  • Profiles what they are and how they work
  • WebSphere Configuration repository
  • Centralized configuration management in WebSphere

Basic Administration

  • Using the administration console
  • Installing applications
  • Creating data sources
  • Configuring security in the administration console
  • Configuring and administering the web container
  • Configuring and administering the EJB container
  • Basic troubleshooting and log files
  • Virtual hosts

Advanced Administration

  • JMX
  • WebSphere Administration Architecture
  • WebSphere scripting overview
  • JACL and Jython
  • Automating WebSphere administrative tasks
  • Java Connector Architecture

HTTP Plug-in and Web Servers

  • Installing IHS
  • Installing HTTP Plug-in
  • Basic IHS administration
  • Configuring the HTTP plug in
  • Strategies for integrating WebSphere and an HTTP Server

WebSphere Clustering & High Availability

  • Clustering topologies
  • High availability WebSphere configurations
  • Creating and managing clusters
  • Data replication service

Advanced Application Deployment

  • J2EE class loaders
  • J2EE packaging
  • Deployment Descriptors
  • Automating application builds and deployments with ANT
  • Troubleshooting application deployment issues

Securing WebSphere

  • WebSphere security architecture
  • Java and J2EE Security Model
  • WebSphere & SSL
  • WebSphere security scenarios

Odds and Ends (Optional Topics)

  • Configuring JMS
  • Tivoli Performance Viewer
  • WebSphere performance management
WPF

Windows Presentation Foundation Using C# Training
Introduction to WPF
What Is WPF
.NET Framework 3.0 (WinFX)
WPF Overview
Application and Window
A Simple WPF Application
Using Visual Studio
Brushes
Panels
XAML
Role of XAML
Elements and Attributes
Namespaces
Property Elements
Type Converters
Content Property
Collections
XAML and Procedural Code
WPF Controls
Button
Label
Text Box
Tool Tip
Radio Button
Check Box
List Box
Combo Box
Layout
Positioning
Transforms
Canvas
Drawing Shapes
StackPanel
WrapPanel
DockPanel
Grid
Scrolling
Scaling
Dialogs
Message Boxes
Win32 Common Dialogs
Custom Modal Dialogs
Custom Modeless Dialogs
Menus and Commands
Menus
Context Menus
Icons on Menu Items
Commands
Keyboard Shortcuts
Disabling Menu Items
Checking Menu Items
Toolbars and Status bars
Toolbars
Toolbars and commands
Status bars
Dependency Properties and Routed Events
Dependency Properties

WCF
Windows Communication Foundation Using C# Training Introduction to WCF
What is WCF
Address, Binding and Contract
WCF Services and Clients
IIS Hosting
WCF Architecture
Addresses and Bindings
Addresses
Bindings
Message Exchange Patterns
Configuring Bindings
Interoperating with ASMX Web services
Hosting in a Console Application
Channel Factories
Multiple Endpoints
Service Contracts
Defining Service Contracts
Defining Operation Contracts
Services with Multiple Contracts
Contract Inheritance
Operation Overloading
Instance Management
Using Per - Call Services
Using Per - Session Services
Using Singleton Services
Configuring Behaviors
Data Contracts
Implementing Data Contracts
Mapping Data Contracts to XSD Schema
Serialization
Array and Generic Collections
Enums
Versioning Data Contracts
More about Service Contracts
Versioning Service Contracts
Implementing Message Exchange Patterns
Oneway Contracts
Duplex Contracts
Asynchronous Proxies
Handling Errors
Faults and Exceptions
Generating and Handling Faults
Fault Contracts
Faults and Sessions

WWF

Introduction to Workflow
What is Windows Workflow Foundation?
Creating Your First Workflow
Hosting a Workflow in a Windows Application
Handling Conditions an Exceptions
Introducing Conditional Activities
IfElse Activity
While Activity
ConditionedActivityGroup Activity
Replicator Activity
Handling Exceptions
Flow Activities
Introducing Flow Activities
Delay Activity and Handling Properties
Listen Activity
Suspend and Terminate Activities
Parallel and SynchronizeScope Activities
Handling Cancellation
Making Decisions in Workflows
Using Rules in Workflows
Using the Policy Activity
Setting Priorities
Forward Chaining
Workflow Communications
Calling Methods in the Host from the Workflow
Handling Host Events in the Workflow
Bi-Directional Communications
Creating State Machine Workflows
Introduction to State Machines
State Machine Activities
Creating a State Machine Workflow
Circular Navigation in State Machines
Using and Building Persistence Services
Introducing Workflow Persistence
Using the SQL Persistence Service
Creating a Custom Persistence Service
Using and Building Tracking Services
Workflow Tracking Services
Using the SQL Tracking Service
Tracking Profiles
Creating a Custom Tracking Service
Creating Custom Activities
Introducing Custom Activities
Creating a Simple Activity
Creating a More Complex Activity
Creating Composite Activities
Handling Workflow Transactions
Transactions
Transactions in Workflows
Transactions and Batches of Work
Compensation in Workflows
Dynamic Workflow Updates
Introduction to Dynamic Updates
Modifying a Workflow from the Host Application
Modifying a Workflow from within the Workflow
Dynamic Rule Conditions
Workflows and Web Services
Workflow-Based Web Services
Building a Workflow Web Service
Maintaining State in Web Services
Invoking a Web Service in a Workflow