1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming LINQ with Visual Basic Extended Features: Hands-On

Building Data-Centric Applications
 
Course: 974   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Develop data-centric Visual Basic applications with LINQ
  • Exploit Language INtegrated Query (LINQ) to integrate diverse data sources
  • Map objects to relational data sources
  • Manipulate, filter and group data using LINQ queries
  • Parse and create XML documents with LINQ
  • Leverage VB to write stored procedures

Course Benefits

With the introduction of .NET 3.5 extended features, including LINQ, Visual Basic has evolved into a full data-manipulation language. .NET 3.5 extended features enable programmers to overcome many of the difficulties encountered working with disparate data sources, such as relational databases, XML and object data. In this course, you learn how to apply extended features to programming problems.

Who Should Attend

Visual Basic programmers who want to improve their software development capabilities by using the extended language features, and in particular Language Integrated Query (LINQ). Visual Basic Programming experience at the level of Course 503, "Visual Basic 2008 Programming," is assumed.

Hands-On Training

Through an extensive case study, you gain experience applying VB extended features and LINQ. Exercises include:
  • Applying Visual Basic shortcut features
  • Retrieving results using LINQ queries
  • Processing objects and data to insert, update and delete with LINQ
  • Integrating in-memory objects, relational databases and XML
  • Entity-class publishing using the O/R Designer tool
  • Parsing XML documents using LINQ
  • Building stored procedures with Visual Basic

Related Courses

 
Visual Basic is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Mar 3 - 6, 2009
 Washington, DC (Alexandria, VA)
Mar 10 - 13, 2009
 Toronto
Mar 17 - 20, 2009
 Washington, DC (Rockville, MD)
Mar 24 - 27, 2009
 New York
Mar 24 - 27, 2009
 Ottawa
Mar 31 - Apr 3, 2009
 Los Angeles
Apr 21 - 24, 2009
 Washington, DC (Reston, VA)
Jun 2 - 5, 2009
 Chicago (Schaumburg)
Jun 9 - 12, 2009
 Toronto
Jun 9 - 12, 2009
 Washington, DC (Alexandria, VA)
Jun 23 - 26, 2009
 Washington, DC (Rockville, MD)
Jun 29 - Jul 2, 2009
 New York
Jul 14 - 17, 2009
 Ottawa
Jul 28 - 31, 2009
 Washington, DC (Reston, VA)
Aug 4 - 7, 2009
 Los Angeles

For complete schedule, please visit www.learningtree.com
 
http://www.lerningtree.com/courses/974pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming LINQ with Visual Basic Extended Features: Hands-On

Building Data-Centric Applications
 
Course: 974   Type: Hands-On Training   Duration: 4 Days
 
 
Course 974 Content
 

Introduction

  • Review of three-tier OO application architecture
  • Data access and data processing
  • Polymorphism
  • Inheritance
  • Encapsulation
  • Implementing to an interface
  • Working with generic collections

Adopting .NET 3.5 Visual Basic Language Features

Language constructs

  • Writing query expressions
  • Benefiting from implied-type declaration

Simplifying code

  • Instantiating entity objects
  • Comparing constructors with object initializers
  • Alternative object initialization

Writing LINQ Queries

Syntax and semantics

  • Coding LINQ queries
  • Ordering data and objects
  • Filtering data and objects using Where

Iterating collections

  • Interfacing between VB and LINQ using IEnumerable<T>
  • Converting from IEnumerable<T> to List<T>

Querying SQL with LINQ

Comparing ADO.NET with LINQ

  • DataReader vs. Generic Collections
  • Processing data-tier information
  • Building a middle tier with entity classes

Connecting to and reading from a database

  • Attaching to a database with LINQ
  • Working with table and entity classes
  • Mapping objects to relational databases with the Object Relational Designer (O/R Designer) tool
  • Creating External Maps with SQLMetal

Updating a database

  • Inserting, updating and deleting data
  • Error handling and exceptions
  • Committing and rolling back transactions

Coding Lambda Expressions and Extension Methods

Filtering and ordering data with lambda expressions

  • Constructing lambda expressions
  • Specifying Where and Order By constraints

Applying extended features

  • Making code more flexible with interfaces
  • Sorting with IComparer<T>
  • Streamlining code with anonymous types

Processing Data with LINQ Queries

Manipulating data

  • Selecting data from multiple sources with Select
  • Retrieving unique results with Distinct
  • Combining multiple results with Join
  • Aggregating with Average and Count

Filtering data

  • Limiting result sets with Take
  • Discarding results with Skip

Grouping data

  • Choosing data with Union and Concat
  • Collating with Group By
  • Creating hierarchical data structures with Group Join

Processing XML with LINQ

Accessing XML

  • Retrieving the document, elements and attributes
  • Parsing an XML document using LINQ

Integrating XML in your code

  • Creating XML directly: XML literals
  • Embedding XML literals in dynamic expressions

Implementing Stored Procedures using LINQ

Exploiting stored procedures

  • Writing stored procedures in VB
  • Calling stored procedures

Updating data via stored procedures

  • Processing data with LINQ
  • Integrating results sets
 
http://www.lerningtree.com/courses/974pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming LINQ with Visual Basic Extended Features: Hands-On Tuition

Building Data-Centric Applications
 
Course: 974   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.lerningtree.com/courses/974pf.htm