Use .NET tutorials within 'POWER .NET Developer Career Bundle** on DVD-ROM' to obtain .NET Developer skills.'

1.0 Introduction to the C# Language
1.1 History of C#
1.2 .NET Languages
1.3 Visual Studio “Jump Start”
1.4 Our First C# Application

2.0 The C# Compiler
2.1 Compile Steps
2.2 .NET Assemblies
2.3 Debug vs. Release
2.4 The Main Method

3.0 The .NET Class Library
3.1 Our First Console Application
3.2 The Class Library Object Browser
3.3 Writing Data to the Console
3.4 Formatting Strings
3.5 Namespaces

4.0 Basic Language Elements
4.1 CTS: The Common Type System
4.2 Intrinsic C# Data Types
4.3 Statements
4.4 Operators
4.5 Comments
4.6 Naming Conventions
4.7 IDE Tips

1.0 Value-Type Variables
1.1 Declaring Local Variables
1.2 Enumerations
1.3 Structures
1.4 Constants

2.0 Reference-Type Variables
2.1 Declaring a Reference to an Object
2.2 Creating a new Object
2.3 Calling an Object Method
2.4 The String Class
2.5 Value-Types vs. Reference-Types

3.0 Flow Control Statements
3.1 The if Statement
3.2 The switch Statement
3.3 The while Statement
3.4 The for Statement
3.5 The foreach Statement

4.0 Methods
4.1 Defining a Method
4.2 Returning a Value from a Method
4.3 Input Parameters
4.4 Output Parameters
4.5 Updatable Parameters
4.6 Method Overloading

5.0 Arrays
5.1 Array Syntax
5.2 Initializing Array Elements
5.3 Array Methods and Properties
5.4 Array Rank

1.0 Introduction to OOP
1.1 Classes, Class Members and Objects
1.2 Using the Class Designer
1.3 Class Inheritance
1.4 Instantiating Objects
1.5 Constructors

2.0 Using OOP in C# Programs
2.1 Properties
2.2 Instance Members
2.3 Static Members
2.4 Abstract Base Classes
2.5 Interfaces

1.0 Configuring The IDE
1.1 Visual Studio Toolbars
1.2 Solution Explorer
1.3 Project Files
1.4 Configuring The Output Window

2.0 Coding Tools
2.1 DataView
2.2 Design View
2.3 Code View

3.0 Debugging
3.1 The Debug Toolbar
3.2 Setting Breakpoints
3.3 DataTips
3.4 The Debug Windows
3.5 Stepping Through your code
3.6 Debugging Strategies

1.0 Creating Windows Applications
1.1 Text Editor Application
1.2 Application Icon
1.3 ToolStrip
1.4 RichTextBox
1.5 SaveFileDialog
1.6 OpenFileDialog
1.7 OurFormClass.Designer.cs
1.8 ControlCollection.Add ( )
1.9 WinApp3 Summary

2.0 Events
2.1 Application.Run ( )
2.2 Event Handlers
2.3 Delegates
2.4 Events Summary

3.0 Exceptions
3.1 The Exception Class Hierarchy
3.2 try...catch…finally
3.3 Exception Assistant

4.0 New Concepts in C# 2005
4.1 Nullable Types
4.2 Static Classes
4.3 Generic Collections
4.4 Anonymous Methods
4.5 Visibility of Property Accessors
4.6 Accessing The Global Namespace
4.7 Click Once Deployment

1.0 Introduction to .NET
1.1 What is .NET?
1.2 Managed Code and the CLR
1.3 How .NET Compiles and Executes Programs

2.0 Introduction to the Visual Basic Language
2.1 A Brief History of Visual Basic
2.2 Visual Basic 2005's Role in .NET
2.3 Language Comparisons (C#, J#)

3.0 Your First VB 2005 Application
3.1 The Structure of a VB 2005 Application
3.2 Building a VB 2005 Console Application
3.3 Documenting Your Code with Comments

1.0 The Visual Studio 2005 IDE
1.1 Managing Files, Projects, and Solutions
1.2 The Windows of the IDE

2.0 Writing an Application
2.1 Working with Code

3.0 Debugging An Application
3.1 Breakpoints, Watches, and Edit and Continue

1.0 Creating a Windows Forms Application
1.1 Building Forms
1.2 Handling Control Events

2.0 A Survey of Various Controls
2.1 The Button, Text Box, and Label Controls
2.2 The Listbox, Combo Box, and Timer Controls

3.0 Working with Forms
3.1 Setting Properties and Dealing with Multiple Forms
3.2 Tabs and Anchoring
3.3 The MessageBox Class

1.0 Basic Language Elements
1.1 Intrinsic Data Types
1.2 Variables, Constants, and Enumerations
1.3 String Concatenation
1.4 Mathematical Operators
1.5 Logical Operators and Short Circuiting
1.6 Access Modifiers

2.0 Program Flow Control
2.1 The While and Do Loops
2.2 The For Next Loop
2.3 Exiting and Continuing Loops
2.4 If Statements
2.5 Select Case Statements

3.0 Creating Routines
3.1 Subs and Functions
3.2 Passing Parameters

1.0 Structured Error Handling
1.1 Try... Catch... Finally

2.0 Arrays
2.1 Creating and Resizing Arrays
2.2 Iterating through Arrays

3.0 Collections
3.1 Collections vs. Arrays
3.2 Working with Collections

4.0 XML Comments
4.1 Using XML Comments

1.0 Introduction to Classes and Objects
1.1 Classes and Objects
1.2 The Structure of a Class
1.3 Fields and Properties
1.4 Methods
1.5 Events
1.6 Constructors and Destructors
1.7 Namespaces

2.0 Class Keywords
2.1 The My and Me Keywords
2.2 Shared Elements
2.3 Partial Classes
2.4 Access Modifiers

3.0 Overloading
3.1 Overloaded Methods
3.2 Overloaded Constructors

4.0 Inheritance
4.1 Base Classes
4.2 Derived Classes

1.0 Working with the Data Wizards
1.1 Using the Graphical Data Tools
1.2 Building Applications with the Graphical Data Tools

2.0 The Data Classes
2.1 Connections
2.2 Commands
2.3 DataReaders
2.4 Using DataReaders in Applications
2.5 DataSets and DataAdapters
2.6 Using DataSets in Applications

1.0 About this course
1.1 What we’ll cover – slide show

• Making the Transition
• Generic Collections
• Object Oriented Programming
• Visual Basic 2005 and C#
• Advantages of ASP.NET 2.0
• Data
• Security
• Personalization

• Software
• Hardware
• Where to get Support
• Affiliations and Disclaimers

2.0 Taking a glimpse at what is to come
2.1 Quick review of projects

• Creating a First Project
• Relational Operators
• Generic Collections
• Creating Applications
• Data Manipulation
• Web Form Security
• Personalization
• Web Parts
• Navigation & Master pages

1.0 About transitioning to VB 2005
1.1 Where are the challenges
1.2 Feel free to skip what you know
1.3 How the material is organized

2.0 Language Elements
2.1 Types

• Numeric Types
• Non-numeric Types: String and Boolean
• User Defined Types

• variables
• constants
• statements
• White Space
• Comments

3.0 Branching and Iteration
3.1 Unconditional branching

• Method Calls
• Goto
• Exceptions

3.2 Conditional Branching

• If...Then
• Else
• Elseif
• Select ... Case

• While
• Do while .. Loop
• Do Until .. Loop
• For
• Breaking Out of a Loop

4.0 Operators
4.1 Arithmetic operators

• +, -, *, / ,\
• Mod

• Logical Operators
• Operator Precedence

1.0 Arrays
1.1 Simple Arrays

• Declaring Arrays
• Default Values
• Accessing Array Elements
• For Each

• Rectangular Arrays
• Jagged Arrays

2.0 Generics
2.1 What are generics?

• Disadvantages of Arrays
• Non Generic Classes are not Type Safe
• Generic Classes are Type Safe
• Advantages of Type Safe

• Using Integers
• Using Strings
• Not Using User-Defined Types

• Generic Queues
• Generic Stacks
• Generic Dictionaries

1.0 Windows forms
1.1 Creating a user input form
1.2 Adding data

2.0 Advanced data
2.1 Master/ Details
2.2 Updating Data

1.0 Cool Controls
1.1 web browsers in Forms
1.2 Masked Text box
1.3 Printing

2.0 File Management
2.1 Creating a file copier

3.0 Custom Controls
3.1 Designing and Implementing Custom Controls

1.0 GDI
1.1 Creating a clock from scratch
1.2 Adding the control to the form
1.3 Drawing the Time
1.4 Adding the Marching Date

2.0 Mice and fonts
2.1 The mouse
2.2 Fonts

3.0 Legacy COM
3.1 ActiveX Controls and Com DLLs

1.0 Relational Databases
1.1 What is a Database?
1.2 Relational Algebra1
1.3 Relational

2.0 Database Normalization
2.1 How to Normalize a Database
2.2 Case study: Employee Time Tracking System

3.0 An Overview of SQL Server
3.1 Features & Capacities

4.0 Creating Databases
4.1 SQL Server Databases & Logs
4.2 Files & FileGroups
4.3 Creating a Database
4.4 Database Size Planning
4.5 Using T-SQL to create a database

1.0 Creating Tables
1.1 SQL Server Data Types
1.2 Creating Tables
1.3 Adding Data to a Table
1.4 Creating Tables Using T-SQL

2.0 Constraints & Indexes
2.1 Data Integrity
2.2 Indexes

2.3 Creating CHECKS & Rules
2.4 Using T-SQL to Create Constraints

3.0 Retrieving Data
3.1 Select Statement
3.2 WHERE Clause
3.3 DISTINCT & Calculated Columns
3.4 ORDER BY Clause
3.5 Using SLQ Query Analyzer

1.0 Advanced Queries
1.1 Aggregated Functions
1.2 Grouping Data
1.3 Advanced Queries
1.4 Distributed Queries

2.0 Joining Tables
2.1 Inner Joins
2.2 Outer Joins
2.3 Cross Join & Self Join
2.4 Subqueries
2.5 Unions

3.0 Data Modification
3.1 INSERT Statements
3.2 Creating Temporary Tables
3.3 UPDATE Statements
3.4 DELETE Statement

4.0 System Function
4.1 Date Functions
4.2 Mathematical Functions
4.3 String Functions
4.4 System Functions
4.5 Security Functions
4.6 Conversion Functions
4.7 User-Defined Functions
4.8 System Variables

1.0 Stored Procedures
1.1 Intro to Stored Procedures
1.2 Passing Parameters
1.3 Returning information from Stored Procedures
1.4 OUTPUT Parameters
1.5 Dynamic SQL
1.6 Cursors

2.0 Triggers & Views
2.1 Update Triggers
2.2 Insert Triggers
2.3 Delete Triggers
2.4 INSTEAD OF Triggers
2.5 Views

3.0 Locking Issues
3.1 Locking Scenarios
3.2 Isolation Levels
3.3 Resource Lock Types
3.4 Lock Modes
3.5 Lock Escalation
3.6 Viewing Locks
3.7 Setting the Isolation Level
3.8 Locking Hints

1.0 Transaction Processing
1.1 What is a Transaction?
1.2 Nesting Transactions
1.3 Transactions in Triggers
1.4 Trying out Transactions
1.5 Deadlockss

2.0 Data Transfers
2.1 Services Available
2.2 BCP
2.3 BULK INSERT
2.4 DTS

3.0 Full Text Search
3.1 What is Full Text Search?
3.2 Setting up Full Text Search
3.3 Performing a Full Text Search
3.4 Full Text SystemProcedures
3.5 FTS Enhancements in SQL 2000

4.0 Optimization
4.1 Optimizing your Server
4.2 Database design
4.3 Query Optimization
4.4 Index Usage
4.5 Statistics & Index Analyzer
4.6 SQL Server Profiler
4.7 Performance Monitor

5.0 System Databases & Tables
5.1 System Databases
5.2 System Tables

1.0 Using XML Extensions
1.1 Creating a Virtual Root
1.2 Using a Virtual Root
1.3 Returning Element Based XML
1.4 Passing Parameters
1.5 Multiple Result Sets
1.6 Using Stored Procedures

1.7 Inserting Data using XML
1.8 Joining Tables
1.9 Retrieving Data from VB

2.0 Application Developmen
2.1 OLE DB, ODBC & ADO
2.2 Using ADO

1.0 Introduction
1.1 Pre requisites for this course
1.2 What is ADO.NET
1.3 Building your first application – Drag and Drop Winforms

• Adding a datasource to your winforms application
• ConnectionStrings section in Web.Config
• Brief introduction to a Strongly Typed Dataset
• Introduction to DataGridView or Details View for Winforms
• Introduction to TableAdapters
• Introduction to BindingSource
• Introduction to BindingNavigator

• Authentication, security and connection strings in web based applications
• A slightly more hands on approach
• Introduction to SqlDataSource
• Specifying your own queries to a SqlDataSource
• Tying together a SqlDataSource with a ConnectionString in the config file
• The ASP.NET GridView Control
• Tying an ASP.NET GridView to a SQLDataSource
• Enabling Paging/Sorting on GridView
• Why Drag & Drop is not all you need to know?

• The SqlConnection Object
• Connecting to the database
• The ConnectionStringBuilder
• Connection Pooling
• Best practice: Open as late as possible and close as early as you can.

• The SqlCommand Object
• The various execute methods on a SqlCommand
• Fetching Scalar Values out of the database

• The SqlComamnd.ExecuteReader method
  
• Checking for the existence of rows in a data reader
• Fetching different datatypes out of a data reader
• The right usage and limitations of a SqlDataReader.
• CommandBehaviors when creating SqlDataReaders
• Configuring the Internal buffering behavior of SqlDataReader using CommandBehavior.SequentialAccess
• Batched TSQL commands
• Using Batched TSQL commands, or stored procedures to return multiple tabular results in a resultset
• Using a SqlDataReader to browse over multiple tabular results.

• Limitations of running Execute commands on a SqlCommand object
• Basics of ASynch execution
• The Begin/End design pattern for running Asynch operations
• Modifying a synchronous SqlDataReader application to convert it into an Asynch application
• Things to be careful of in an Asynch application.

2.0 Disconnected Objects

• The need for disconnected objects
• Desirable characteristics for disconnected objects
• Disconnected data objects
• Business Objects
• Disconnected data objects
• Data Transfer Objects
• DataSet and family

• Creating a Strongly Typed Dataset in Visual Studio
• Specifying relations between tables in Strongly typed datasets
• Examining the auto generated code.
• Using the strongly typed dataset - reading and writing to an XML file
• Controlling the XML output using the Nested Property on DataRelation
• Creating an application to load, edit, create, and save a strongly typed dataset
• Extending the same application to load, edit, create, and save a non-strongly typed dataset
• Compare the usage of strongly typed dataset versus non-strongly typed dataset
• Discussing other possibilities with disconnected objects

• Creating a new row and adding it to a DataTable
• Examining the RowStates for Detached and Added rows
• Modifying a datarow contents
• Comparing the Added vs. Modified Rowstates
• Extracting Changes from a DataSet
• Setting Expressions on new data columns & limitations of non-strongly typed datasets

• Finding a specific row in a DataTable using the Find Method
• Specifying a primary key to a DataTable
• The difference between Removing and Deleting a row from a DataTable
• Finding more than one matching rows using the Select Method
• Sorting DataTable data
• Filtering data as per RowStates
• Comparing the filtering usage in strongly typed datasets
• Browsing through relational data in a dataset

• Comparing a dataview to a database view
• DataTable.Select versus DataView.RowFilter
• Sorting using a DataView
• Limiting the number of columns in the resultset
• Comparing holding a reference to a DataTable, to creating a new DataTable
• Doing a select distinct equivalent on a DataTable

3.0 Filling, Using and Updating Disconnected Data 3.1 Filling Data – The DataAdapter

• Various ways of setting up a DataAdapter
• Demonstrating the interaction of SqlConnection and DataAdapter, and how DataAdapter gives you better connection pooling
• Modifying disconnected data
• Demonstrating that the data is indeed disconnected

• DataAdapter.Update
• The Update that inserts, updates and deletes
• Specifying Insert, Update and Delete commands to a DataAdapter
• Creating the commands automatically using a CommandBuilder object
• Demonstrating the connection between RowStates and the exact command called
• Why are the default CommandBuilder commands are woefully terrible
• Restrictions on using CommandBuilder
• Demonstrate options for fixing CommandBuilder commands Conflict Option

• Situations where you must specify your own commands
• Specifying Stored Procedures to SqlCommands
• Adding Parameters to a SqlCommand
• Connecting a DataTable with a Stored procedure
• The SourceColumn property of a SqlParameter
• Concurrency Issues
• Adding new key values to new rows

• Concurrency Management Basics
• Avoiding concurrency conflicts
• Optimistic vs. Pessimistic Concurrency Checks
• Various kinds of Optimistic concurrency mechanisms and their problems
• Concurrency management in hierrachical data

• Using a DataGridView to restrict user input based on a Strongly Typed Dataset
• Creating a windows based, handwritten data driven application
• Writing your own commands that fetch back identity values
• Specifying negative seed and increment values on the primary key to generate fake keys
• Replacing the fake keys with database generated keys during DataAdapter.update

4.0 Transactions

• Transaction Basics
• What is a Transaction?
• Basic Characteristics of a Transaction.

• Writing two SqlCommands in a non-transactional code, comparing it to TSQL
• The SqlTransaction data type
• Wrapping those two commands inside a transaction using the SqlTransaction variable.
• Using Try-Catch blocks to write elegant transactional code.
• Best practices in writing Transactional Code

• Using SqlTransaction with DataAdapters
• Fetching the last refresh of data, after having saved data using a DataAdapter
• The need for tying in all commands on a dataadapter on a SqlTransaction
• Various Scenarios in transactional updates using DataAdapters
• Using GetChanges and Merge to gracefully refresh data out of the database
• Specifying Schema information to a DataSet, so Merge works intelligently
• AcceptChangesOnUpdate
• Preserving RowStates in event of a failed transaction
• ContinueUpdateOnError
• Continue with further rows in event of a failed command

• Various options for distributed transactions
• Introduction to System.Transactions
• Important names
• Resource Managers and Transaction Coordinator
• Two phase commit basics
• Lightweight Transaction Manager versus MSDTC
• Enlistment Mechanisms
• Volatile, Durable and Promotable

• Usage of TransactionScope
• Rolling back using System.Transactions
• Demonstrating promotion to MSDTC
• Isolation level increment on promotion of a transaction

5.0 CLR Integration – Introduction

• Comparing SQLCLR with TSQL
• Right usage of SQLCLR
• Comparing SQLCLR with extended stored procedures

• Leveraging Visual Studio to write SQLCLR objects
• Enabling SQLCLR Debugging on a server
• Writing a simple UDF in SQLCLR
• Debugging SQLCLR code

• Specifying FillRowMethodName and TableDefinition to a UDF
• Returning an IEnumerable for the table
• Seperating out a row's contents into column details, implementing the Fill Row Method
• Implementing the enumerator
• Pros and Cons of using inbuilt enumerators versus writing your own.

• An intro to Context connections
• Restrictions on Context Connections
• How many context connections can you open?
• Using SQLCLR code inside a transaction with other TSQL code
• Latching onto the current transaction using System.Transactions
• System.Transactions integration with SQLCLR
• Best practices for using SqlTransaction versus System.Transactions in SQLCLR code.

1.0 Introduction to XML
1.1 What is XML?
1.2 What is Markup Language?
1.3 XML Goals
1.4 Dynamic HTML
1.5 Document Object Model (DOM)

1.6 XML Parsers & Browser Support
1.7 Introducing Document Type Definition (DTD)
1.8 Introducing Schemas
1.9 XML & Data Transfer
1.10 Web Applications & XML

1.0 XML Document Structure
1.1 XML Hierarchies
1.2 XML Objects/Elements
1.3 XML Objects/Attributes

1.4 XML Objects/Entities
1.5 Namespaces
1.6 Parsing XML Documents

1.0 XML Validation
1.1 Overview of Validation
1.2 DTD vs. Schema
1.3 DTD Overview

1.4 Schema Overview
1.5 DTD in Depth
1.6 Microsoft Schemas in Depth
1.7 XML Development Tools

1.0 XML Associated Technologies
1.1 XML Output Formatting
1.2 Cascading Style Sheets (CSS) in Action
1.3 Extensible Style Language (XSL)

1.4 Extensible Style Language Transformations (XSLT)
1.5 XPath
1.6 Xlink
1.7 Xpointer

1.0 XML Programming
1.1 DOM/OOP
1.2 Document Object Model (DOM)
1.3 The W3C DOM

1.4 Simple Application Programming Interface for XML (SAX)
1.5 The Microsoft DOM
1.6 XML Data
1.7 Simple Object Access Protocol (SOAP)