Home » Training » Power Sessions » Power Sessions Archive

Visual Studio and TFS

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

SQL Server

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.

Other

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