Home » Training » Power Sessions » Power Sessions Archive
Building Rich Mobile Applications for Pocket PC 2002
Mobile computing has been a promise for ages. PDAs are a really convenient device
for many business uses. This session shows how .NET developers can use VS.NET and
the .NET Compact Framework to create real world applications. This demo will be
using SQL Server on a handheld device. Along the way Adam will highlight some of
the features and technologies that you need to be especially careful with and show
how you can overcome their limitations.
ADO.NET - Introduction to ADO.NET
ADO.NET is a significant upgrade from ADO, and it changes the techniques for working
with data. Whether the data is from SQL Server 2008, a Jet MDB file, an XML file,
or almost any other data source, ADO.NET provides the tools for working with your
data. This session introduces the basics of ADO.NET, and demonstrates how to retrieve
and update data.
ADO.NET Going Hardcore with SQL Server 2008
This session focuses on one of the hottest new areas in data access development.
Learn how you can harness Visual Studio's deep XML support with ADO .NET to
integrate interoperable, robust data access into your applications and components.
The .NET framework includes many new classes for data access that require a fundamentally
different way of using data than in ADO classic. This includes relational data,
XML data, and other data stores, collectively making up the new ADO.NET. It is designed
to simplify data access, reduce network traffic, and support distributed, disconnected
applications. You'll find out how to code the ADO .NET to access the data in SQL
Server 2008 and the use of strongly typed datasets using XSD and SQL Server 2008
stored procedures.
Utilizing XML as the Solution for n-Tier Development
This session will highlight and detail how and where XML can be
utilized within data tiers. We will discuss the advantages of XML over DCOM and
MTS/COM+. You’ll also be given a snapshot profile on how to:
- Build stateless objects with XML via ADO
- Design COM objects to use XML efficiently
- Develop an N-tier solution that can use the Internet as its
network
- Build highly scalable distributed applications
- Use Data Islands for "rich" browser development
XML & e-Business
XML brings power, flexibility and interoperability to Web-based
applications and provides developers and users with an industry standard for expressing
structured data. XML, a standard developed by the World Wide Web Consortium (W3C),
is viewed as the cornerstone technology for building e-business applications. This
session looks at how developers can use XML in their applications.
- Where you will be using XML
- Assigning attributes
- Defining tags
- Entity references
- Processing instructions
- Validation/document type definitions
Then you'll advance into:
- Uniquely tagging data with XML
- Developing flexible web applications
- Incorporating XML into your Access and Visual Basic Applications
- Integrating data from multiple, disparate sources and building
three-tiered Web-enabled applications
Get to know ALL about ActiveX Data Objects (ADO)
ActiveX Data Objects (ADO) is Microsoft's strategic, high-level
interface for all kinds of data. ADO provides the fastest, easiest and most productive
means for accessing both relational and non-relational data. You'll review the ADO
object model, and the role of the Connection, Command, Recordset, and Parameters
objects. Learn how to use ADO to build database solutions in Access, Visual Basic,
and Office.
- What is ADO?
- Assessing when to use ADO and when to use DAO
- Understanding connection strings to ensure your code will work
with any back-end
- Minimising network traffic via ADO access over the Internet
and Intranets
Build on your skill set by:
- Creating recordsets
- Updating recordset data, deleting records and working with
multiple result sets
- Creating and using Command Objects
- Developing a constant connection to your datasource
Advanced ADO
Catapult your working knowledge of ADO through this intensive session
packed full of key features. To name a few:
- Executing a stored procedure
- input and output parameters
- return values
- Utilizing prepared statements
- Returning multiple result sets to a single Recordset object
- Using ADO to support complex cursors, including batch, client
and server side cursors
- Using batch updating
- Generating multiple result sets
- Working with Persistent Recordsets
- Asynchronous Operations
- Using ADOx for Data Definition Language (DDL) operations
Microsoft SQL Server 2008 Notification Services
Come learn about the premier platform for developing and deploying a new class of
scalable Web applications that deliver personalized, timely information updates
to a variety of mobile devices.
Writing
a Newsletter application with Microsoft SQL Server 2008 Notification Services
Come see a session using SQL Server Notification Services. During this session you
will see the code to develop a number of Event Providers. It is a new way of developing
and deploying scalable Web applications that deliver personalized, timely information
updates to a variety of devices. The version we will build, monitor web pages
and deliver HTML emails.
Usability - Rules to Better
Web Forms
Are you looking to eradicate bugs and ensure consistency? Learn
how to take control of your code, ensuring large, complex source code can be simplified,
cleaned and maintained. The focus is on the most popular .NET languages (C#, VB.NET)
for both Web Forms and ASP.NET; however, you will learn how to maintain quality
code in any language.
As a project or company grows, managing code standards throughout your team becomes
virtually impossible. Consistent code is crucial to future development and maintenance.
Learn how to review your web apps and projects.
The tools we will explore include FX Cop and SSW Code Auditor.
Advanced MS Excel (For Power-Users)
This topic will help power-users get the most out of Excel and
includes the following material:
- Create a database using only Excel
- Sort a database
- Perform multiple sorts
- Use the Data Form
- Locate records
- Delete records
- Use compound criteria
- Extract unique records
- Use database functions
- Import & export data
- Formula auditing
- Add Auto Filter to apply filters to a database to display specified
data
- Specify conditions that apply designated formatting to cells
that meet the conditions
- Create Custom Lists that can be automatically inserted into
a worksheet
- Design custom number formats
- Link and embed Word objects
- Record Macros to automate repetitive tasks
- Work with multiple workbooks
- Create Pivot Tables to display data from different perspectives
- Create templates (pre-designed forms)
- Customize toolbars