Skip to content

Online Intermediate C# Programming course

Virtual classroom - online courses available


Impartica IT Training

Summary

Price
£708 inc VAT
Study method
Online + live classes
Duration
2 days · Full-time
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

9 students enquired about this course

Add to basket or enquire

Overview

This follow-on to our popular Programming with C# course will introduce those with some C# experience to more advanced concepts such as interfaces, indexers, and how to query collections with LINQ. It will also show you how to read/write data to/from a database using ADO.NET, or to/from XML.

Certificates

Certificate of completion

Digital certificate - Included

Description

Interfaces

  • What is an interface?
  • Interface rules
  • Inheriting from an interface
  • Creating an interface
  • Properties of an interface
  • Methods in an interface
  • Basing a class on an interface
  • Basing an interface on an interface
  • Multiple inheritance
  • Interfaces as variable or parameter data types
  • The IComparable Interface

LINQ

  • LINQ (Language INtegrated Query)
  • Example LINQ query
  • How LINQ works
  • LINQ query syntax
  • The query variable
  • The from clause
  • The select clause
  • Returning a customised data type
  • The where clause
  • The orderbyclause
  • The group clause
  • The Single method
  • Aggregate functions
  • Aggregate functions where no arguments are required
  • Lambda Expressions
  • Example: Lambda Expressions requiring only one line of code

Working with XML

  • XML and .NET
  • The System.Xmlnamespace
  • Using XmlReader to read XML
  • Using XmlWriter to create XML
  • Using the DOM
  • Using XmlDocument
  • Using XmlDocument to create a new document
  • Using XmlDocument to create a document from a file
  • The GetElementsByTagNamemethod
  • The SelectNodes method
  • Modifying an XML document
  • Serialising objects into XML
  • Default XML layout
  • Customising the default XML layout
  • Modifying XML output without access to the class code
  • Deserialising XML to an object
  • LINQ and XML
  • Example: creating XML with Linq

Indexers

  • What are Indexers?
  • Syntax: Declaring an Indexer
  • Example: Class with an indexer
  • Using indexers
  • Overloaded Indexers
  • Example: class with overloaded indexers

Connected data access with ADO.NET

  • What is ADO.NET?
  • ADO.NET namespaces
  • High level data access process
  • Creating a connection object
  • Storing connection strings in config files
  • Command objects
  • CommandType and CommandText
  • Command object methods
  • Disposing of resources
  • The using statement
  • ExecuteNonQuery
  • ExecuteScalar
  • ExecuteReader
  • Data readers
  • Command parameters
  • Adding parameters to commands

ADO.NET disconnected data access

  • The DataTable Object
  • The DataColumn object
  • The DataRow object
  • Manually creating and filling a datatable
  • The Rows collection
  • The Columns collection
  • The DataSet object
  • Data adapters
  • Data adapter properties
  • Working with data locally
  • Filling a DataTable with a data adapter

Who is this course for?

This course is for anyone who wants to learn Intermediate C# Programming

Requirements

Delegates should have a working knowledge of C#, to the level provided by our Programming with C# course. If in doubt please contact us before booking.

Career path

These skills could be useful for anyone in a role that requires knowledge of Intermediate C# Programming

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs