ADO .NET

ADO .NET

Module 0: ADO .NET Connected Data
| ADO .NET Overview
Connections
Connected Data: SQL Statements
Connected Data: Stored Procedures
Using Transactions


| Module 1: Ado.net: Disconnected Data
| Using the Dataset Class
Change Management
Constraints and Relations
Updating the Database
Data Binding
XML Integration


| Module 2: Linq for SQL
| Introducing Linq for SQL
About Orm with Linq
Creating the Context
Linq Basic Syntax
Linq Advanced Syntax
Linq and Inheritance

This two-day instructor-led course provides students with the knowledge and skills to access and modify data by using ADO.NET 3.5.




Audience



This course is intended for application developers who know how to create applications in Visual Studio 2005 or 2008.








At Course Completion



After completing this course, students will be able to:

�Describe the purpose and structure of ADO.NET 3.5.
�Explain the role of data providers in ADO.NET 3.5.
�List the technologies and techniques available for managing data with ADO.NET 3.5.
�Insert, update, and delete data by using ADO.NET Command objects.
�Implement transactions to control data integrity and concurrency.
�Define and use a DataSet for retrieving data.
�Use a DataSet to update a database.
�Use a DataSet as a local cache in an occasionally connected environment.
�Define LINQ queries for selecting data from an in-memory data structure.
�Use LINQ to SQL to query data in a database.
�Use LINQ to SQL to modify data and save changes to the database.
�Explain how to use the ADO.NET Entity Framework to map a database schema to a logical business model.
�Use the ADO.NET Entity Framework to query and manage data.
�Explain how Synchronization Services supports occasionally-connected solutions.
�Use Synchronization Services to download data from a SQL Server database.
�Use Synchronization Services to upload data to a SQL Server database.

This course will teach developers to build data-centric applications and Web services with Microsoft ADO. NET, Microsoft SQL Serverâ„?2000, and the Microsoft .NET Framework.



Audience



This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for his or her organization. It is designed for developers who have component and Web application development skills, and who have previously built solutions by using Microsoft Visual Studio®.

Typically, these individuals will have the following skills: Experience with a .NET language such as Microsoft Visual Basic® .NET, Microsoft Visual C#� or Microsoft Visual C++®; an understanding of object-oriented concepts and terminology; experience developing distributed applications; and experience developing Web-based applications hosted on Internet Information Server.



At Course Completion



After completing the course, students will be able to:

Describe data-centric applications, ADO. NET architecture, and ADO. NET and XML.
Connect to SQL Server and other data sources.
Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML.
Build a DataSet schema, populate it with data, and modify the data programmatically.
Build a DataSet from an existing data source.
Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments.
Build a Web service that uses ADO. NET to query and update a data source.
Troubleshoot errors within an ADO. NET application.

Visual Studio IDE and VB .NET
VB-6 vs. VB.NET
Upgrading VB6 to VB.NET
Control Structures
Procedures, Functions and Arrays
Object-Based Programming
Object-Oriented Programming
.NET Framework
.NET Base Class Library
Exception Handling
Graphical User Interface Concepts
Multithreading
Strings, Characters and Regular
Windows Forms, and Controls
Building Controls
Graphics and Multimedia
Files and Streams
Extensible Markup Language (XML) and SOAP
SQL and ADO .NET
Crystal Reports for VB.NET
.NET Security
Deployment
Overview of ASP.NET
Overview of Windows Services
Overview of XML Web Services
Project

Pages:- 1 2
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>