An in depth Introduction to C# and .NET programming

Intended Audience This course is aimed at reasonably experienced programmers who need to master C# and .NET. Attendees are expected to have some programming experience. A typical attendee would have several years experience e.g. with VB6 programming, C programming or COBOL programming.This course would also be suitable for someone who has completed the Introduction to C# programming course and spent several months writing C# code prior to coming on this course. The course is targetted at developers who wish to create commercial .NET applications from within the Visual Studio 2008 IDE using C# 2.0, C# 3.0 The latest version of .NET is .NET 3.0. .NET is Microsoft's framework for web and Windows application development. .NET applications and web services can be deployed to, and used on both desktop and mobile platforms. An imp0ortant feature of .NET is that it provides support for applications built from modules developed using different programming languages, e.g. C# and Visual Basic . This course will concentrate on C# and .NET. Course Overview The course will cover The structure and functionality of the Common Language Runtime (CLR) and the .NET framework Designing object-oriented software in C# Details of Object Oriented programming in C# - inheritance, polymorphism, encapsulation Writing applications to query databases using SQL and display the result Basic UML notation, including its use to to capture entity-relationship-attribute models Implementing applications that can create databases and populate them with tables and data Provide experience of RAD (Rapid Application Development) using the Tools present in Visual Studio 2008 Foundations of building of multi-tier applications - using LINQ, and ADO.NET Designing and implementing web and windows data driven interfaces WinForms - for Windows applications WebForms for ASP.NET server side applications Provide an introduction and overview of Web Services The course will use MySQL, running on either Windows, Linux. It is generic in the sense that it does not depend on any particular operating system and that it concentrates on the most commonly used standard parts of SQL. The Relational database and SQL topics covered on this course can readily be applied to other databases such as Oracle, SQL Server or PostgreSQL. Practical Work About 50% of the course time will be allocated to practical exercises. The exercises will be built around a specific case study, and so will cover the entire process from design, to implementation, to application development. Course Contents Overview of Visual Studio 2008 and .NET .NET and Visual Studio 2008 Creating and working with .NET Projects Overview of the Common Language Runtime (CLR) Intellisense and other "behind the scenes" features of Visual Studio 2008 Foundations of C# and Object Oriented Programming Survey of the .NET Framework and Class Library Value types and Reference types Structures and Classes Class Diagrams in Visual Studio Inheritance Polymorphism Interfaces Generics Lambda Expressions Extension Methods Error and Exception Handling Patterns for Creating Scaleable Applications Layered applications Presentation / Business / Data Access Layers Model - View - Controller pattern Using databases to organise and query data Understanding SQL Statements and Stored Procedures Interfaces Exploring the Framework Class Library (FCL) Forms and Controls Regular Expressions File input - output Collection classes ADO.NET - data access functionality Windows Presentation Layer Details Designing and Creating Forms Building WinForms applications Data display and data update User Input Validation Binding Controls to Data Web Presentation Layer Details Designing and Creating WebForms Building WinForms applications Data display and data update User Input Validation Binding Controls to Data Distributed Services and Service Oriented Architectures - an Overview Web Service concepts Web Service Clients Tiered service based applications Versioning and Deployment Applying .NET configuration and settings Preparing the release build Private and Shared Assemblies Versioning XCopy and Setup projects compared Overview of Windows Presentation Foundation Features and Idioms of WF Declarative programming vs. Imperative Programming Overview of LINQ LINQ dat query and data manipulation idioms Language Independent Data Querying Manipulating different forms of data in a consistent manner