Microsoft .NET

You will learn how to

• Design and program modern applications using Microsoft .NET, Visual Basic and C#
• Write variables, IF statements, loops, functions, error handlers and custom classes
• Analyse user requirements and design programs and databases
• Leverage Visual Studio 2005 tools for rapid application development
• Build Windows, Web and console user interface applications
• Create SQL Server databases, tables, indexes and relationships

Course benefits
Microsoft .NET is a suite of tools for developing any type of modern software application. Its advanced features, productivity tools and modern languages allow aspiring programmers to quickly gain practical skills that can generate immediate results.

In this course, you acquire the fundamental knowledge and hands-on experience to write applications using Visual Basic 2005 and C#. Introductory topics include language syntax, application design, database concepts, Visual Studio 2005 features, Windows Forms and ASP.NET.

Who should attend
This course is valuable for Web designers, administrators, power users and others who are unfamiliar with object-oriented programming and want an introduction to programming applications using .NET. No prior programming experience is required.

Hands-on training
You develop a complete application with Visual Basic 2005 or C# and the .NET Framework. Exercises include:

• Writing applications using Visual Basic or C# language constructs
• Testing and debugging using console applications
• Planning and modelling applications and database structures
• Leveraging Visual Studio 2005 tools for rapid application development
• Programming Windows user interfaces
• Saving data to the file system and relational databases
• Programming ASP.NET Web applications

Course content

VB Language Fundamentals Programming logic and concepts Straight line Branch Loop Declaring variables Statements Working with data types and conversions Strings Dates and time Integers Floating point numbers Performing data type conversions Programming Logic and Structured Code Decision-making statements Changing program flow with IF statements Simplifying complex logic with CASE statements Modularising code with functions Calling functions from an application Passing arguments to functions Retrieving data from functions Repeating statements with loops For...Next loops Top and bottom evaluation Do...Loops Storing multiple values with arrays Testing and debugging Try...Catch...Finally error handling Documenting your code Analysing User Requirements and Designing Applications Mapping application features to programming code Building applications using an iterative programming process Translating requirements into design Constructing the three logical layers Presentation Business Data Modelling Windows and Web application user interfaces Planning data storage requirements Crafting Custom Data Types and Business Classes Coding classes Programming fields, methods and property procedures Initialising objects with constructors Allocating memory: the Stack vs. the Heap The role of the business class Encapsulating functionality with methods Self validation and object persistence Simplifying Application Development with Visual Studio 2005 Managing business solutions Visual Studio projects and solutions Setting project properties and references Adding files, folders and code Exploiting Visual Studio 2005 tools Solution Explorer Toolbox Server Explorer Properties Window Code editor/IntelliSense Help system Constructing the Windows User Interface Windows application basics Creating forms and positioning controls Navigating with menus Handling events Displaying data on a Windows Form Specifying and retrieving property values Managing collections of objects Designing ASP.NET Web User Interfaces Creating the Web site Virtual directories Web applications Web pages HTML Hyperlinks Processing ASP.NET Web Forms Displaying data and gathering user input Activating Web Forms with events Maintaining variables with Sessions Validating and saving user changes Controlling Web site access Activating Web Forms security Creating a user login page Adding user accounts Incorporating Relational Databases Relational database concepts Employing databases for fast, efficient storage Select, insert, update and delete query syntax Creating a SQL Server database Adding tables, fields and indexes Defining primary and foreign key relationships Accessing the database with ADO.NET Connecting to the database and running SQL commands Storing user changes Displaying existing records