.NET

Select the title to review a description of the course. Please note that these courses can often be adapted for virtual delivery and modified based on the target audience and goals of your program. Please contact us to discuss your training needs and we will work with you to identify and craft the best solution.
  • .NET Web Services Review/Recap and Hands-On Lab

    • .NET Web Services Review/Recap and Hands-On Lab

      Course Number: 527-JK
      Recommended Duration: 1-2 days

      Intended Audience: Experienced .NET programmers who have taken prerequisite online (e.g. Web-Based Training or Computer Based Training) in Web Services and XML.

      Course Overview

      There are five hands-on exercises. Exercises use the Microsoft Visual Studio tool (2005 or 2003).

      Objectives

      This session provides reinforcement for on-line learning in a classroom environment with hands-on exercises to practice creation and use of Web Services in the .NET environment. Hands-on environment will use the Microsoft Visual Studio tool (2005 or 2003).

      Prerequisites

      Students must have experience in or have completed appropriate online (WBT or CBT) courses in Web Services, XML, and .NET. (We can evaluate your online training's suitability for this follow-on)

      Topics

      • Review of Web Service and Service Oriented Architecture (SOA)
      • Web Service client
      • Web Service provider
      • SOAP
      • Web Service Description Language (WSDL)
      • Universal Description Discovery and Integration (UDDI)
      • Creating a Web Service
      • Publishing a Web Service
      • Finding a Web Service
      • Using a Web Service
      • Testing, debugging, and SOAP faults

      Share with others

  • Introduction to .NET

    • Introduction to .NET

      Course Number: 520-JK
      Recommended Duration: 1 day

      Intended Audience: Managers, designers, developers, and other people needing an introduction to the Microsoft .NET environment.

      Course Overview

      Course appropriate for Visual Studio .NET 2003.

      Objectives

      Students will learn the terms and tools that are part of .NET and Visual Studio.

      Prerequisites: No prior experience is needed

      Topics

      • Understanding Microsoft .NET managed execution environment
      • Common Language Runtime (CLR) and Intermediate Language (IL)
      • Common Type System, Common Language Specification, and Framework Class Library
      • Microsoft only? Not anymore
      • Introduction to Visual Studio .NET
      • Visual Basic .NET application development
      • C# .NET application development
      • Comparing C# and Visual Basic .NET
      • Internet Information Server (IIS) Concepts
      • Windows Forms, Web Forms, Web Services,
      • ASP.NET (Active Server Pages for .NET)
      • ADO.NET (ActiveX Data Objects for .NET)
      • SQL Server and other databases

      Share with others

  • Introduction to Web Services with .NET

    • Introduction to Web Services with .NET

      Course Number: 526-JK
      Recommended Duration: 2 days

      Intended Audience: Experienced .NET programmers (C#.NET or VB.NET) needing to learn how to create and use Web Services.

      Course Overview

      Experienced C#.NET and VB.NET developers learn how to create and use Web Services. There are five hands-on exercises. Exercises use Microsoft's Visual Studio 2005 (or 2003) tool. (must be available on classroom machines)

      Objectives

      Participants will learn to use Microsoft Visual Studio and .NET to use existing Web Services and to create Web Services for others to use. Class exercises will use WSDL (Web Services Description Language) and SOAP (Simple Object Access Protocol) to process Web Services.

      Prerequisites

      Students must have .NET experience (C#.NET or VB.NET) or have completed Microsoft Visual Basic .NET, Microsoft C# .NET Programming, or Microsoft C# .NET Programming with TDD. Students with VB 6.0 should become familiar with VB.NET changes before attending. Students also require XML experience, or have completed XML Introduction.

      Topics

      • Introduction to Web Services
      • Simple Object Access Protocol (SOAP)
      • Web Service Description Language (WSDL)
      • Web Service client
      • Web Service provider
      • Universal Description Discovery and Integration (UDDI)
      • Publishing a Web Service
      • Finding a Web Service
      • Using a Web Service

      Share with others

  • Microsoft .NET Framework Programming

    • Microsoft .NET Framework Programming

      Course Number: 525-JK
      Recommended Duration: 4 days

      Intended Audience: People needing to create or enhance programs using complex features of the Microsoft .NET Framework.

      Course Overview

      Students create robust web server based applications using .NET Framework features such as ADO .NET and ASP .NET. There are fourteen hands-on lab exercises. Exercises may be organized to incorporate Test-Driven Development upon request. All class exercises use Microsoft Visual Studio .NET and may be performed using either Visual C# .NET or Visual Basic .NET.

      Objectives

      Students will work with Microsoft .NET Framework features enabling them to create robust web server based applications. Class exercises will focus on using .NET Framework features such as ADO .NET and ASP .NET to implement rich applications.

      Prerequisites

      Experience programming with Microsoft Visual Studio and either Visual C# .NET or Visual Basic .NET (Visual Basic programmers should have prior knowledge of and experience with the .NET environment).

      Topics

      • .NET platform and framework
      • .NET Framework and Architecture
      • .NET Framework Class Library
      • ADO .NET
      • Accessing Relational Databases: Connections, Concurrency
      • DataGrids
      • DataSets
      • DataReaders
      • DataViews
      • Exception Handling
      • Serialization and Deserialization
      • XML access
      • ASP.NET and Web Forms
      • Event-driven Forms
      • Data binding
      • Attributes, and Reflection
      • Server Controls and Client Controls
      • State and State Management
      • Security, SSL, and Forms-based authentication
      • Deployment Issues
      • Networking with Socket-Client

      Share with others

  • Microsoft C# .NET Programming

    • Microsoft C# .NET Programming

      Course Number: 523-JK
      Recommended Duration: 4 days

      Intended Audience: People needing to create programs using Microsoft C#.

      Course Overview

      Students will create, maintain, and test Visual Basic .NET applications for Windows and/or Web applications. There are seventeen hands-on lab exercises.

      Objectives

      Students will create, maintain, and test C# .NET applications. Programming assignments provide immediate practice creating and testing applications.

      Prerequisites

      Experience programming in any language and ability to navigate in Microsoft Windows.

      Topics

      • .NET platform and framework
      • Components of C# programming
      • Compiling, executing, debugging
      • Generating documentation (XML)
      • Classes, Methods, and Variables
      • Object-oriented principles (Inheritance, Polymorphism, Encapsulation, etc…)
      • Comments and Javadoc
      • Data types and variables
      • Common and User-Defined Types
      • Arrays, Collections, and Indexers
      • Operators, delegates, and events
      • Reference vs. Non-Reference types
      • Classes and Objects
      • Operators and Expressions
      • Conditions: if-then-else, switch
      • Loops: for/while/do while
      • Accessing SQL data using ADO.NET
      • Introduction to ASP.NET and Web Forms

      Share with others

  • Microsoft C# .NET Programming with TDD

    • Microsoft C# .NET Programming with TDD

      Course Number: 524-JK
      Recommended Duration: 4 days

      Intended Audience: People needing to create programs using Microsoft C#.

      Course Overview

      Students will create, maintain, and test C# .NET applications using the Visual Studio .NET environment. Test Driven Development concepts are discussed and exercises include use of NUnit. There are seventeen hands-on lab exercises. Several exercises require a Test-Driven Development approach.

      Objectives

      Students will create, maintain, and test C# .NET applications. Programming assignments provide immediate practice creating and testing applications.

      Prerequisites

      Experience programming in any language and ability to navigate in Microsoft Windows.

      Topics

      • .NET platform and framework
      • Components of C# programming
      • Compiling, executing, debugging
      • Generating documentation (XML)
      • Classes, Methods, and Variables
      • Object-oriented principles (Inheritance, Polymorphism, Encapsulation, etc…)
      • Comments and Javadoc
      • Data types and variables
      • Common and User-Defined Types
      • Arrays, Collections, and Indexers
      • Operators, delegates, and events
      • Reference vs. Non-Reference types
      • Classes and Objects
      • Operators and Expressions
      • Conditions: if-then-else, switch
      • Loops: for/while/do while
      • Accessing SQL data using ADO.NET
      • Introduction to ASP.NET and Web Forms
      • Test Driven Development (TDD) concepts and issues
      • NUnit unit testing tool

      Share with others

  • Microsoft SQL Server

    • Microsoft SQL Server

      Course Number: 662-JK
      Recommended Duration: 3 days

      Intended Audience: Personnel needing to create and execute queries and manipulate the SQL Server database.

      Course Overview

      Participants are introduced to the SQL Server database and SQL. Several exercises use Transact-SQL and SQL to query and modify the database. The participant will also learn how to work with views, indexed views, and XML. SQL Server 2008 and SWL Server 2005. Course can be taught with earlier versions of the database.

      Prerequisities

      No programming background or experience is necessary, although a technical orientation is helpful.

      Topics

      • Relational database concepts
      • SQL syntax and usage
      • SELECT statement
      • Expressions
      • XML, XPath, and XQuery
      • Built-in functions
      • Joins, Outer joins
      • Subqueries (Nested Queries)
      • Views and Indexed Views
      • Synonyms
      • Sequences
      • Data Dictionary
      • UPDATE, INSERT, DELETE, and
      • MERGE
      • COMMIT, ROLLBACK, SAVE (savepoints)
      • Locking
      • CREATE/ALTER: Tables, Views, Indexed Views, Synonyms, Indexes
      • Referential Integrity (Primary & Foreign keys)
      • Security: GRANT/DENY/REVOKE, roles
      • Statistics and Performance overview

      Share with others

  • Microsoft Visual Basic .NET Programming

    • Microsoft Visual Basic .NET Programming

      Course Number: 522-JK
      Recommended Duration: 5 days

      Intended Audience: People needing to create programs using Microsoft Visual Basic.

      Course Overview

      Students will create, maintain, and test Visual Basic .NET applications for Windows and/or Web applications.

      Course appropriate for Visual Studio .NET 2005.

      Objectives

      Students will create, maintain, and test Visual Basic applications. Programming assignments provide immediate practice creating both Windows and Web applications that use GUI controls and process file data.

      Prerequisites

      Experience programming in any language and ability to navigate in Microsoft Windows.

      Topics

      • Components of Visual Basic programming
      • Understanding the impact of the .NET framework
      • .NET platform and framework
      • Windows Applications
      • Web Applications
      • Forms, Menus, and Controls
      • Form and Control properties
      • Text boxes, labels, buttons, check boxes, lists, and more
      • Event-driven processing
      • Visual Basic commands and syntax
      • Data types, variables and arrays
      • Looping and program control
      • Sub and Function Procedures
      • Pre-defined functions
      • Interactive debugging and exception handling
      • Object-Oriented features
      • Accessing SQL data using ADO.NET

      Share with others

  • Microsoft Visual Studio .NET

    • Microsoft VIsual Studio .NET

      Course Number: 521-JK
      Recommended Duration: 4 days

      Intended Audience: People needing to create dynamic web sites using Microsoft tools.

      Objectives

      Students will learn to create web sites using Visual Studio. Class presentations and exercises will show how to use Visual Studio to create dynamic web sites

      Prerequisites

      Experience or training with HTML, VBScript or JavaScript, the WWW, and the available browser are necessary.

      Topics

      • Using Visual Studio to create a web site
      • Using VBScript and JavaScript in web pages
      • VBScript compared to JavaScript
      • Client-side and Server-side scripts
      • Using Active-X controls
      • Internet Information Server (IIS) concepts
      • Dynamic HTML (DHTML)
      • ASP.NET (Active Server Pages)
      • Use ADO.NET to access data objects
      • Record sets and tables
      • Query Designer and Database Designer
      • Stored procedures
      • Deployment of applications
      • Creating scalable applications

      Share with others

  • Transact-SQL Programming

    • Transact-SQL Programming

      Course Number: 714-JK
      Recommended Duration: 3 days

      Intended Audience: Application developers and designers who will use create Stored Procedures and triggers using T-SQL in their applications.

      Course Overview

      Participants will learn to use Transact-SQL (T-SQL) to enhance SQL Server applications. Several exercises take students from the basics of T-SQL through advanced features enabling improved programming and enhanced performance. Course is for SQL Server 2008 and SQL Server 2005.

      Prerequisites

      Prior knowledge of SQL Server fundamentals and basic SQL is necessary. No previous experience with T-SQL or Stored Procedures is required.

      Topics

      • T-SQL, syntax and fundamentals
      • SQL Server variables and parameters
      • Global Variables
      • Built-in functions
      • Arithmetic, Looping, and Conditional
      • Logic
      • Error handling (Try-Catch)
      • Using cursors
      • Temporary Tables
      • Using Table variables
      • Implicit and Explicit Cursors
      • Stored Procedures
      • Dynamic queries
      • Executing remote procedures
      • User-Defined Functions
      • Dependencies
      • Triggers
      • RETURN
      • New features of T-SQL
      • Security
      • Performance and T-SQL
      • Transactions and Locking
      • Snapshot Isolation
      • Using Hints

      Share with others


Please click here to return to the Technical Skills page.