Layout Table~~~~6024~6024~~

7 Sessions - 21 Hours of Interactive Training~
Bruce Jones, an industry expert in the C# language, provides in-depth coverage of the information you need to build a solid foundation in C#. Bruce further explores and teaches advanced topics and a solid framework in ADO. This course is built to help experienced programmers get up to speed and start developing applications in C#.NET. Over 14 hours of instruction covering 107 topics including…

Objects and Classes • Methods • Keywords • Arrays • Delegates • Event Handlers and Publishers • Exception Handling • Introduction to ADO • Action and Scalar Queries • Stored Procedures • Data Tables • DataSets • Visual Database Tools • Using the Data Application Block:

Course Includes:
7 CD's • Over 140 hours of instruction • 540 Page Reference Text • 5 user licence included~~~6024~6025~~

Course Outline Table~~~~6024~6026~~

Session 1~C#.NET Phase I - Fundamentals
1.0 Introduction to C#
1.1 Why Use the C# Language
1.2 Creating a C# Application
1.3 Adding Comments
1.4 Basic Data Types
1.5 The Code Editor
1.6 Constants
1.7 Converting Variable Types
1.8 Enumerations
1.9 Source Code Formatting Issues
2.0 Conditions, Classes, Methods, and Constructs
2.1 Looping and Branching Constructs and the IF Condition
2.2 The ELSE IF Clause
2.3 Code Blocks
2.4 The Switch Statement
2.5 Creating and Calling Methods
2.6 FOR and While Constructs
3.0 Operators
3.1 Overview
3.2 The Mathematical Operators
3.3 AND or OR Operators
3.4 The C# Conditional Operator
3.5 The Bit Shifting Operator
3.6 Short Circuiting
3.7 The C# Compound Assignment Operator~~~6024~6027~~

Session 2~C#.NET Phase II - Fundamentals
1.0 Objects & Classes
1.1 Objects and Classes
1.2 Methods
1.3 The Constructor
1.4 The THIS Keyword
1.5 The NEW Keyword
1.6 STATIC Members
1.7 Stack and Heap Oriented Objects
1.8 The OUT KeyWord
1.9 The Static Constructor
1.10 The Private Default Constructor
2.0 Methods
2.1 Inheritance
2.2 "Boxing"
2.3 The Virtual Keyword
2.4 Abstract Classes and Abstract Methods
2.5 One Version of a Constructor Calling Another
2.6 Derived Class Method Calling a Base Class Method
3.0 More on Operators
3.1 Operator Overloading Capabilities
3.2 Operator Functionality to User Defined Classes
3.3 Overloading Relational Operators
3.4 Unreadable or Non-Maintainable Code~~~6024~6028~~

Session 3~C#.NET Phase III - Fundamentals
1.0 Classes and Struts
1.1 Important Differences
2.0 The Finer Points of the .NET Base Framework
2.1 Interfaces
2.2 Extending the Interface
2.3 Mixing and Matching Interfaces
2.4 How to Determine if any Other Interfaces are Implemented
2.5 Two Interfaces With a Common Member Name
2.6 Hiding the Members When an Object of the Class is Created
3.0 Arrays
3.1 Creating and Array
3.2 The Foreach Loop
3.3 Filling Arrays with Data
3.4 Multidimensional Arrays
3.5 Throwing Exceptions
3.6 Populating Multidimensional Arrays
3.7 Creating Jagged Arrays
3.8 Accepting an Array of Parameters
3.9 Object Mimicking Arrays
3.10 Text Files
3.11 Non-standard Array Manipulation Features
4.0 Managing Arrays
4.1 Utilizing the Foreach Loop
4.2 An Arraylist
4.3 Sorting Items in an Arraylist~~~6024~6029~~

Session 4~C#.NET Phase IV - Fundamentals
1.0 Delegates
1.1 Introduction
1.2 Instance and Static
1.3 Passing Delegates
1.4 Multicast Delegates
1.5 Static Members
2.0 Events
2.1 Creating a Set of Classes that Publish and Subscribe to Events
2.2 Adding the Additional Parameters (System.EventArgs)
2.3 Event Handlers and Event Publishers
3.0 Errors
3.1 The Start Page-User Profile
3.2 Setting Breakpoints and Viewing and Modifying Their Properties
3.3 Stepping Through the Program
3.4 Watch Variables
3.5 The Immediate Window and Other Windows
3.6 The Debug Class
3.7 Hard Coding Checks (Debug. Assert)
3.8 Conditional Compilation
3.9 Debug Write Methods
4.0 Exception Handling
4.1 The Non-Trapped Error
4.2 The Try Catch Block
4.3 Determining the Type of Exception
4.4 Creating Methods that can Throw an Exception
4.5 A Finally Block
4.6 Innerexception
4.7 Creating A User-Defined Exception Class~~~6024~6030~~

Session 5~C#.NET Phase V- ADO
1.0 Introduction to ADO.NET
1.1 Creating an OleDb And SQLClient Connection
1.2 Using the IDbConnection Interface
1.3 Start The Data Access Class Library
1.4 Executing Action Queries With The Command Object
1.5 Executing Scalar Queries With The Command Object
1.6 The Different Scalar Return Types
1.7 Add The Command Object To The Class Library
2.0 The Datareader Class
2.1 Introduction
2.2 Get Data by Ordinal Position
2.3 Get Specific Data Types
2.4 Automatically Close The Connection
2.5 Get One Row of Data
2.6 Read Columns Sequentially
2.7 Combine Multiple Command Behaviors
2.8 Return Multiple Result Sets
2.9 Add The Datareader To The Class Library
2.10 Nested Data Readers
3.0 Parameterized Queries
3.1 Introduction
3.2 A Query With Multiple OleDb Parameters
3.3 Solving The String Delimiter Problem
3.4 A Query Wit hMuyltiple SqlClient Parameters
3.5 Add Parameterized Queries To The Class Library
4.0 Stored Procedures
4.1 Introduction
4.2 OleDb Stored Procedures With One Parameter
4.3 OleDb With Inputs, Outputs, And Return Values
4.4 OleDb Alternate Syntax
4.5 SqlClient With Inputs, Outputs, And Return Value~~~6024~6031~~

Session 6~C#.NET Phase VI - ADO
1.0 Introduction to DataTables
1.1 Introduction to Data Tables
1.2 Adding DataColumns
1.3 Adding DataRows
1.4 Adding Primary Keys
1.5 Adding Unique Constraints
1.6 Adding Multi Column Constraints
1.7 Adding Read Only Columns
1.8 Allow Null Values in Selected Columns
1.9 Set A Max Length For Text Columns
1.10 Use An Autoincrement For a Primary Key
1.11 Add A Calculated Column
1.12 Calculations Based On a Group of Rows
2.0 DataTable Row
2.1 Find a Data Table Row Using The Primary Key
2.2 Selecting A Set of Rows
2.3 Using The RowState Property
2.4 The BeginEdit. EndEdit, and CancelEdit Methods
2.5 Using The RowVersions
2.6 Selecting Rows Using RowVersion
2.7 Row Versiuon With BeginEdit and EndEdit
2.8 Create one DataTable From Another
2.9 Using DataViews
3.0 Introduction to DataSets
3.1 Introduction to DataSets
3.2 Adding DataTables To A DataSets
3.3 Foreign Key Constraints
3.4 Cascading Updates
3.5 Enforce Referential Integrity
3.6 Null Values in Foreign Keys
3.7 Adding Relationships
3.8 Using Relationships To Get Child Rows
3.9 Using Relationships to Get Parent Row
4.0 Introduction to DataAdapters
4.1 Introduction To DataAdapters
4.2 Filling a DataSet
4.3 TableMappings
4.4 TableMapping Pass Through Fields
4.5 TableMapping Blocked Fields
4.6 Throw An Exception For Unmapped Fields
4.7 Get A DataSet From The Class Library~~~6024~6032~~

Session 7~C#.NET Phase VII - ADO
1.0 Working with Data Adapter
1.1 Update Data with Data Adapter
1.2 Insert and Delete Data with Data Adapter
1.3 Save Changes Without a Data Adapter
1.4 Save Changes Using Stored Procedures
1.5 Dealing with Concurrency Issues
1.6 Detecting a Failed Concurrency Issue
1.7 Using Transactions
2.0 Using Visual Database Tools
2.1 Introduction to the Visual Database Tools
2.2 Adding a DataAdapter Using the Visual Tools
2.3 Using the DataAdapter to Fill a DataSet
2.4 The Problem With Regular DataSets
2.5 Solving The Problem With Typed DataSets
2.6 The Problem With Typed DataSets
2.7 Using The Visual Tools vs Programming
3.0 Using Data Application Block
3.1 Introducing the Data Access Application Block
3.2 Examining the DAAB Help File
3.3 Adding the DAAB to a Project and Creating a Simple Dataset
3.4 Create a Wrapper Around the DAAB
3.5 Using Stored Procedures to Create Dataset
3.6 A Stored Procedure Parameter Wrapper
3.7 Wrapper Class Code Generator~~~6024~6033~~

Ordering~~~~6024~6042~~

C#.NET Training Course by Blast~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~5 USER LIBRARY LICENCE%3A CD Course|!104242|~6024~6043~c# .net ado~