Computer Power Plus IT training specialists

Introduction to Programming in C# (Level 5) | Short Course

Programming C#

 

Overview

This short course is an ideal skills enhancement solution for any programmer using the C# language. The course provides comprehensive learning from the fundamentals of programming to advanced C# programming skills and includes training in SQL.

This course is only available to New Zealand citizens or Permanent Residents.

Aims

  • Gain an understanding of Structured Query Language, and get the skill and knowledge to use Microsoft SQL Server.
  • Get an introduction to the Microsoft Visual Studio IDE, along with C# language fundamentals.The course will also provide an introduction to Object-Oriented Programming using C#.
  • Learn C# programming using Visual Studio and prepare for the external examination Microsoft exam Programming in C# (70-483).

Content

    Introduction to Visual Studio and SQL
  • Introduction to SQL/SQL Server
  • SQL basics
  • Advanced SQL commands
  • Using the SQL Server Management Studio Query Editor tool
  • Introduction to Visual Studio development
  • C# syntax fundamentals
  • Arrays, arraylists and text files
  • Object-oriented programming with C#
  • Programming in C#
  • Manage program flow
  • Create and use types
  • Debug applications and implement security
  • Implement data access

Learning outcomes

    Introduction to Visual Studio and SQL
  • Understand the relational model of database design
  • Introduce SQL Servers  and the common statements of the SQL language
  • Use aggregate and scalar functions, and group and sort data
  • Use conditional and logical operators and the CASE statement
  • Create multi-table queries, use inner and out joins and create sub queries
  • Create GUI applications that incorporate menus, buttons, text boxes and other GUI controls that react to events
  • Use both primitive and reference data types, including arrays and array lists
  • Apply rudimentary principles of modular and object-oriented design
  • Programming in C#
  • Implement and manage multithreading and asynchronous processing and implement program flow
  • Create and implement events and callbacks and implement exception handling
  • Create and consume types, and find, execute, and create types at runtime by using reflection
  • Create and implement a class hierarchy, and enforce encapsulation and manage the object life cycle
  • Manipulate strings and validate application input  and perform I/O operations
  • Perform symmetric and asymmetric encryption
  • Serialize and deserialize data and manage assemblies
  • Debug an application and implement diagnostics in an application
  • Store data in and retrieve data from collections and query and manipulate data and objects by using LINQ

Duration

On-campus, face-to-face learning and assessment: Up to 225 hours.
Home study: Up to 112 hours.
  • Part-time study: up to 27 weeks
    Based on 8 hours per week on campus + 4 hours/week home study
  • Full-time study: up to 9 weeks
    Based on 25 hours per week on campus + 12.5 hours/week home study

2018 start dates

  • Weekly
  • Fees

    • $2,095
      Fees are inclusive of GST and include all institute based learning guides, texts and access to resources. Fees do not include external examination fees.

What do I need to start?

  • New Zealand Certificate in Computing (Level 3) or equivalent.
    Register your interest to enrol in this courses.

Locations

You can study at one of our three training centres: Auckland, Wellington or Christchurch.


Register your interest
Top