Shedding Light on windows Programming Home Training Resources Registration About the Paul Yao Company
The Paul Yao Company





Microsoft Windows Embedded Partner


Programming SQL Server for Windows CE

Overview
This three-day, lecture & lab based workshop prepares programmers for developing distributed applications that use SQL Server as the host database and SQL Server CE as the remote database. This workshop focuses on developing a SQL Server CE application and on exchanging data between SQL Server CE and SQL Server.

Who Should Attend
Anyone involved in the design, development, testing or support of SQL Server CE based distributed applications.

Workshop Highlights
  • Describe the basic design goals of Windows CE and outline the set of Win32 services which are supported.
  • Describe the basic design goals of Windows CE and outline the set of Win32 services which are supported.
  • Creating SQL Server CE schema declaratively and programmatically
  • Developing SQL Server CE applications
  • Analyzing host data exchange connectivity
  • Using RDS to exchange data with host SQL Servers
Performance Objectives
On completion of this workshop, attendees will be able to...
  • Write SQL Server CE applications
  • Understand the capabilities and limitations of SQL Server CE
  • Exchange data between SQL Server CE and a host SQL Server in a multi-user environment
  • Understand conflict resolution in a multi-user environment
  • Understand the role of the internet in data exchange
  • Understand the administration of the data exchange environment
  • Meet the security requirements of host data exchange
Overview
Who Should Attend
Workshop Highlights
Performance Objectives
Workshop Syllabus
Delivery Format
Request More Information
Workshop Syllabus

Day 1 Day 2 Day 3

Architecture

  • Structure of SQL Server CE
  • Architecture of host data transfer

ADOCE, OLEDBCE, and ADOXCE

  • Using ADO objects
  • Processing recordsets
  • Handling errors
  • Using OLE / DB
  • Using ADOXCE

SQL Server CE databases, tables, and indexes

  • Concepts, databases, tables, indexes, internal structures
  • In place SQLCE database creation
  • Creating a SQL Server CE database from a SQL Server database
  • Differences between SQL Server CE and SQL Server

Retrieving SQL Server CE data

  • Specifying criteria
  • Ordering, aggregating, grouping, and joining
  • Differences between SQL Server CE and SQL Server

Modifying SQL Server CE data

  • Insert, updata and delete
  • Differences between SQL Server CE and SQL Server

Optimizing SQL Server CE performance

  • Using indexes
  • Rewording queries
  • ADO / OLEDB parameters
  • Adjusting application design

Transfering data between SQL Server CE and SQL Server

  • Concepts
  • Connectivity issues
  • Built in tools: RDS and Merge replication

Using Remote Data Access

  • Establishing connectivity
  • PUSH
  • PULL
  • Submit SQL
  • Handling conflicts and errors

Using Merge Replication - Part I

  • Connectivity: Publishers, subscribers, and distributors
  • Implementation

Using Merge Replication - Part II

  • Establishing partitioning
  • Using ranged identities
  • Detecting and resolving conflicts
  • Handling errors
  • Chosing between RDS and Merge replication

Summary

  • SQL Server CE
  • ADO and OLE DB
  • RDS
  • Merge Replication
CONTACT US LOGISTICS REQUEST MORE INFORMATION
(c) Copyright 1990-2024 The Paul Yao Company. All rights reserved.