Learn Programming with C# Classes

Overview
This is an introductory programming course provides a strong foundation that would allow students to further their skills with additional education. This course describes how to use the Visual Studio environment, and how to write good syntax in code constructs within that environment. In addition, important object-oriented concepts will be introduced. The course will conclude by incorporating database connectivity into .NET applications.

Audience Profile
This course is intended for both novice programmers and more experience programmers looking to get familiar with C# and object-oriented principles.

At Course Completion
After completing this course, students will be able to:
• Comfortably navigate the Visual Studio environment
• Visually design, code, and test a Windows Forms Application
• Understand data types and choose when different types are appropriate
• Use code structures such as conditional statements and loops
• Create methods and handle events
• Utilize Arrays and Collections
• Respond to runtime errors and validate user data
• Create and use classes
• Utilize inheritance
• Understand the basics of database connectivity
• Use ADO.NET to write custom data access code (If Time Permits)

Prerequisites
Before attending this course, it is recommended that students:
• Have comfort in navigating around a Windows computer system
• Prior programming experience is not required, but helps provide some perspective
If you have prior programming experience, you should consider our regular Introduction to C# course. For details on this alternative faster paced course for programmers course, go to
C# Programming Level 1: Introduction for Programmers

Course Outline
(Note: the course material contains much more information that can serve as a useful reference to the learner going forward. This is why the chapter numbers listed are not in perfect numeric order)

Section 1: Introduction to Visual Studio

How to get started with Visual Studio
o     Introduction to the .NET Framework
o     A tour of the Visual Studio IDE
o     How to test a project

How to design a Windows Forms Application
o     Visual Studio Options and Settings
o     Creating new projects

How to code and test a Windows Forms Application
o     Introduction to object-oriented programming
o     Properties, methods, and events
o     How an application responds to events
o     Coding a form
o     How to run, test, and debug a project

Section 2: The C# language essentials

How to Work with Numeric and String Data
o     Built-in value types
o     Declaring and initializing variables and constants
o     Arithmetic expressions
o     Assignment statements
o     Casting
o     Using the Math class

How to code control structures
o     Boolean expressions
o     Conditional statements
o     Loops

How to code methods and event handlers
o     Coding and calling methods
o     Parameterizing methods
o     Refactoring code into a method
o     Passing arguments by value and by reference to a method

How to handle exceptions and validate data
o     How exceptions work
o     Using Structured exception handling
o     Validating data

How to use Arrays and Collections
o     One-dimensional arrays
o     Multi-dimensional arrays
o     Jagged arrays
o     Collections

Section 3: Object-Oriented Programming

How to create and use classes
o     Introduction to classes
o     Adding classes to a project
o     Adding class members
     Fields
     Properties
     Methods
     Constructors
     Static Members
o     Diagraming classes
o     Structures

How to work with Inheritance
o     How inheritance works
o     Creating base and derived (sub) classes
o     Polymorphism

Section 4: Database Programming

An introduction to database programming
o     Components of a client/server system
o     Introduction to relational databases
o     Using SQL
o     Introduction to ADO.NET

How to use ADO.NET to write your own data access code (If Time Permits)
o     Connections and Commands
o     Paramaterized SQL Statements
o     Executing Commands

Overview
In this live, instructor-led training course, students who already have a programming background will learn to program in C#. Attendees will learn: how C# works and its place in the world of programming languages; its relationship with the Common Language Infrastructure and .NET Framework; C# data types and operators; to write selection statements and loops; generic programming and working with collections; processing data; and error handling. This C# course is taught using C# 8.

Audience
Students new to the C# language who already have experience with other programming languages.

Prerequisites
This course is specially designed for individuals with prior programming background. You should also have a working knowledge of Object Oriented Programming concepts. If you have no prior programming experience or are not familiar with Object Oriented Programming, you should consider our "C# Programming Level 1: Introduction for Non-Programmers" course instead. For details on this alternative course for non-programmers, go to:
C# Programming Level 1: Introduction for Non-Programmers

Outline

Section 1 An introduction to Visual Studio

• Chapter 1 How to get started with Visual Studio
• Chapter 2 How to design a Windows Forms application
• Chapter 3 How to code and test a Windows Forms application

Section 2 The C# language essentials

• Chapter 4 How to work with numeric and string data
• Chapter 5 How to code control structures
• Chapter 6 How to code methods and event handlers
• Chapter 7 How to handle exceptions and validate data
• Chapter 8 How to use arrays and collections
• Chapter 9 How to work with dates and strings
• Chapter 10 More skills for working with Windows forms and controls
• Chapter 11 How to debug an application

Section 3 Object-oriented programming

• Chapter 12 How to create and use classes
• Chapter 13 How to work with indexers, delegates, events, and operators
• Chapter 14 How to work with inheritance
• Chapter 15 How to work with interfaces and generics
• Chapter 16 How to organize, document, and test your classes

Section 4 Basic skills for working with data

• Chapter 17 How to work with file I/O
• Chapter 18 How to use LINQ

Section 5 Database programming

• Chapter 19 An introduction to database programming
• Chapter 20 How to use Entity Framework Core
• Chapter 21 How to use ADO.NET to write your own data access code
• Chapter 22 How to use the DataGridView control

Overview
In this C# training course, students already familiar with C# programming will learn advanced C# techniques.

This advanced C# course is taught using C# 8.

Prerequisites
Students should have experience with C# and working knowledge of the skills covered in Core Skills: Level 1. Specifically, you should know: how C# works and its place in the world of programming languages; its relationship with the Common Language Infrastructure and .NET Framework; C# data types and operators; how to write selection statements and loops; generic programming and working with collections; tools for processing data with C#; and error handling.

For more information on the Level 1 course, go to:
C# Programming Level 1: Introduction for Programmers

COURSE OUTLINE

1 Advanced Topics
Delegates and events
Delegates
Events
Anonymous types
Tuples
The Tuple class
Value tuples
Pattern matching
The is expression
The switch expression
Regular expressions
Overview
Matching input text
Finding substrings
Replacing parts of a text
Extension methods

2 Resource Management
Garbage collection
Finalizers
The IDisposable interface
The using statement
Platform invoke
Unsafe code

3 Lambdas, LINQ, and Functional Programming
Functional programming
Functions as first-class citizens
Lambda expressions
LINQ
Standard query operators
Query syntax
Currying
Closures
Monoids
Monads

4 Reflection and Dynamic Programming
Understanding reflection
Dynamically loading assemblies
Understanding late binding
Using the dynamic type
Attributes
System attributes
User-defined attributes
How to use attributes?
Attribute targets
Assembly attributes
Attributes in reflection

5 Multithreading and Asynchronous Programming
What is a thread?
Creating threads in .NET
Using the ThreadPool class
Understanding synchronization primitives
The task paradigm
Synchronous implementations of asynchronous methods
Occasionally asynchronous methods
Breaking the task chain – blocking the thread
Manually creating a task
Long-running tasks
Breaking the task chain – fire and forget
Task and exceptions
Canceling a task
Monitoring the progress of a task
Parallelizing tasks
Signaling tasks with the TaskCompletionSource object
Synchronization context

6 Unit Testing
What is unit testing?
What are Microsoft tools for unit testing?
Creating a C# unit testing project
Writing unit tests
Analyzing code coverage
The anatomy of a test
Writing data-driven unit tests
Data from attributes
Dynamic data
Data from external sources

Overview
This training course teaches developers the programming skills that are required for developers to create Windows applications using the Visual C# language. During their four days in the classroom students review the basics of Visual C# program structure, language syntax, and implementation details, and then consolidate their knowledge throughout the week as they build an application that incorporates several features of the .NET Framework.

Audience profile
This course is intended for experienced developers who already have programming experience in C, C++, JavaScript, Objective-C, Microsoft Visual Basic, or Java and understand the concepts of object-oriented programming.

This course is not designed for students who are new to programming; it is targeted at professional developers with at least one month of experience programming in an object-oriented environment.

Prerequisites
Developers attending this course should already have gained some limited experience using C# to complete basic programming tasks.

Course Outline

Section 1 An introduction to Visual Studio
Chapter 1 How to get started with Visual Studio
Chapter 2 How to design a Windows Forms application
Chapter 3 How to code and test a Windows Forms application

Section 2 The C# language essentials
Chapter 4 How to work with numeric and string data
Chapter 5 How to code control structures
Chapter 6 How to code methods and event handlers
Chapter 7 How to handle exceptions and validate data
Chapter 8 How to use arrays and collections
Chapter 9 How to work with dates and strings
Chapter 10 More skills for working with Windows forms and controls
Chapter 11 How to debug an application

Section 3 Object-oriented programming
Chapter 12 How to create and use classes
Chapter 13 How to work with indexers, delegates, events, and operators
Chapter 14 How to work with inheritance
Chapter 15 How to work with interfaces and generics
Chapter 16 How to organize, document, and test your classes

Section 4 Basic skills for working with data
Chapter 17 How to work with file I/O
Chapter 18 How to use LINQ

Section 5 Database programming
Chapter 19 An introduction to database programming
Chapter 20 How to use Entity Framework Core
Chapter 21 How to use ADO.NET to write your own data access code
Chapter 22 How to use the DataGridView control

Overview
This training course teaches developers the programming skills that are required for developers to create Windows applications using the Visual C# language. During their five days in the classroom students review the basics of Visual C# program structure, language syntax, and implementation details, and then consolidate their knowledge throughout the week as they build an application that incorporates several features of the .NET Framework 4.7.

Audience profile
This course is intended for experienced developers who already have programming experience in C, C++, JavaScript, Objective-C, Microsoft Visual Basic, or Java and understand the concepts of object-oriented programming.

This course is not designed for students who are new to programming; it is targeted at professional developers with at least one month of experience programming in an object-oriented environment.

Prerequisites
Developers attending this course should already have gained some limited experience using C# to complete basic programming tasks. More specifically, students should have hands-on experience using C# that demonstrates their understanding of the following:
How to name, declare, initialize and assign values to variables within an application.
How to use: arithmetic operators to perform arithmetic calculations involving one or more variables; relational operators to test the relationship between two variables or expressions; logical operators to combine expressions that contain relational operators.
How to create the code syntax for simple programming statements using C# language keywords and recognize syntax errors using the Visual Studio IDE.
How to create a simple branching structure using an IF statement.
How to create a simple looping structure using a For statement to iterate through a data array.
How to use the Visual Studio IDE to locate simple logic errors.
How to create a Function that accepts arguments (parameters and returns a value of a specified type.
How to design and build a simple user interface using standard controls from the Visual Studio toolbox.
How to connect to a SQL Server database and the basics of how to retrieve and store data.
How to sort data in a loop.
How to recognize the classes and methods used in a program.

At course completion
After completing this course, students will be able to:
• Describe the core syntax and features of Visual C#.
• Create methods, handle exceptions, and describe the monitoring requirements of large-scale applications.
• Implement the basic structure and essential elements of a typical desktop application.
• Create classes, define and implement interfaces, and create and use generic collections.
• Use inheritance to create a class hierarchy and to extend a .NET Framework class.
• Read and write data by using file input/output and streams, and serialize and deserialize data in different formats.
• Create and use an entity data model for accessing a database and use LINQ to query data.
• Access and query remote data by using the types in the System.Net namespace and WCF Data Services.
• Build a graphical user interface by using XAML.
• Improve the throughput and response time of applications by using tasks and asynchronous operations.
• Integrate unmanaged libraries and dynamic components into a Visual C# application.
• Examine the metadata of types by using reflection, create and use custom attributes, generate code at runtime, and manage assembly versions.
• Encrypt and decrypt data by using symmetric and asymmetric encryption.

Course Outline

Module 1: Review of Visual C# Syntax
The Microsoft .NET Framework version 4.7 provides a comprehensive development platform that you can use to build, deploy, and manage applications and services. By using the .NET Framework, you can create visually compelling applications, enable seamless communication across technology boundaries, and provide support for a wide range of business processes. In this module, you will learn about some of the core features provided by the .NET Framework and Microsoft Visual Studio. You will also learn about some of the core Visual C# constructs that enable you to start developing .NET Framework applications.
Lessons
Overview of Writing Application by Using Visual C#
Data Types, Operators, and Expressions
Visual C# Programming Language Constructs
Lab : Implementing Edit Functionality for the Students List
Implementing Insert Functionality for the Students List
Implementing Delete Functionality for the Students List
Displaying a Student’s Age

Module 2: Creating Methods, Handling Exceptions, and Monitoring Applications
Applications often consist of logical units of functionality that perform specific functions, such as providing access to data or triggering some logical processing. Visual C# is an object-orientated language and uses the concept of methods to encapsulate logical units of functionality. A method can be as simple or as complex as you like, and therefore it is important to consider what happens to the state of your application when an exception occurs in a method. In this module, you will learn how to create and use methods and how to handle exceptions. You will also learn how to use logging and tracing to record the details of any exceptions that occur.
Lessons
Creating and Invoking Methods
Creating Overloaded Methods and Using Optional and Output Parameters
Handling Exceptions
Monitoring Applications
Lab : Extending the Class Enrolment Application Functionality
Refactoring the Enrolment Code
Validating Student Information
Saving Changes to the Class List

Module 3: Basic types and constructs of Visual C#
To create effective applications by using Windows Presentation Foundation (WPF) or other .NET Framework platforms, you must first learn some basic Visual C# constructs. You need to know how to create simple structures to represent the data items you are working with. You need to know how to organize these structures into collections, so that you can add items, retrieve items, and iterate over your items. Finally, you need to know how to subscribe to events so that you can respond to the actions of your users. In this module, you will learn how to create and use structs and enums, organize data into collections, and create and subscribe to events.
Lessons
Implementing Structs and Enums
Organizing Data into Collections
Handling Events
Lab : Writing the Code for the Grades Prototype Application
Adding Navigation Logic to the Grades Prototype Application
Creating Data Types to Store User and Grade Information
Displaying User and Grade Information

Module 4: Creating Classes and Implementing Type-Safe Collections
In this module, you will learn how to use interfaces and classes to define and create your own custom, reusable types. You will also learn how to create and use enumerable, type-safe collections of any type.
Lessons
Creating Classes
Defining and Implementing Interfaces
Implementing Type-Safe Collections
Lab : Adding Data Validation and Type-Safety to the Application
Implementing the Teacher, Student, and Grade Structs as Classes
Adding Data Validation to the Grade Class
Displaying Students in Name Order
Enabling Teachers to Modify Class and Grade Data

Module 5: Creating a Class Hierarchy by Using Inheritance
In this module, you will learn how to use inheritance to create class hierarchies and to extend .NET Framework types.
Lessons
Creating Class Hierarchies
Extending .NET Framework Classes
Lab : Refactoring Common Functionality into the User Class
Refactoring Common Functionality into the User Class
Implementing Password Complexity by Using an Abstract Method
Creating the ClassFullException Custom Exception

Module 6: Reading and Writing Local Data
In this module, you will learn how to read and write data by using transactional file system I/O operations, how to serialize and deserialize data to the file system, and how to read and write data to the file system by using streams.
Lessons
Reading and Writing Files
Serializing and Deserializing Data
Performing I/O by Using Streams
Lab : Generating the Grades Report
Serializing Data for the Grades Report as XML
Previewing the Grades Report
Persisting the Serialized Grade Data to a File

Module 7: Accessing a Database
In this module, you will learn how to create and use entity data models (EDMs) and how to query many types of data by using Language-Integrated Query (LINQ).
Lessons
Creating and Using Entity Data Models
Querying Data by Using LINQ
Lab : Retrieving and Modifying Grade Data
Creating an Entity Data Model from The School of Fine Arts Database
Updating Student and Grade Data by Using the Entity Framework
Extending the Entity Data Model to Validate Data

Module 8: Accessing Remote Data
In this module, you will learn how to use the request and response classes in the System.Net namespace to directly manipulate remote data sources. You will also learn how to use Windows Communication Foundation (WCF) Data Services to expose and consume an entity data model (EDM) over the web.
Lessons
Accessing Data Across the Web
Accessing Data by Using OData Connected Services
Lab : Retrieving and Modifying Grade Data Remotely
Creating a WCF Data Service for the SchoolGrades Database
Integrating the Data Service into the Application
Retrieving Student Photographs Over the Web (If Time Permits)

Module 9: Designing the User Interface for a Graphical Application
In this module, you will learn how to use Extensible Application Markup Language (XAML) and Windows Presentation Foundation (WPF) to create engaging UIs.
Lessons
Using XAML to Design a User Interface
Binding Controls to Data
Lab : Customizing Student Photographs and Styling the Application
Customizing the Appearance of Student Photographs
Styling the Logon View
Animating the StudentPhoto Control (If Time Permits)

Module 10: Improving Application Performance and Responsiveness
In this module, you will learn how to improve the performance of your applications by distributing your operations across multiple threads.
Lessons
Implementing Multitasking
Performing Operations Asynchronously
Synchronizing Concurrent Access to Data
Lab : Improving the Responsiveness and Performance of the Application
Ensuring That the UI Remains Responsive When Retrieving Teacher Data
Providing Visual Feedback During Long-Running Operations

Module 11: Integrating with Unmanaged Code
In this module, you will learn how to interoperate unmanaged code in your applications and how to ensure that your code releases any unmanaged resources.
Lessons
Creating and Using Dynamic Objects
Managing the Lifetime of Objects and Controlling Unmanaged Resources
Lab : Upgrading the Grades Report
Generating the Grades Report by Using Word
Controlling the Lifetime of Word Objects by Implementing the Dispose Pattern

Module 12: Creating Reusable Types and Assemblies
In this module, you will learn how to consume existing assemblies by using reflection and how to add additional metadata to types and type members by using attributes. You will also learn how to generate code at run time by using the Code Document Object Model (CodeDOM) and how to ensure that your assemblies are signed and versioned, and available to other applications, by using the global assembly cache (GAC).
Lessons
Examining Object Metadata
Creating and Using Custom Attributes
Generating Managed Code
Versioning, Signing, and Deploying Assemblies
Lab : Specifying the Data to Include in the Grades Report
Creating and Applying the IncludeInReport attribute
Updating the Report
Storing the Grades.Utilities Assembly Centrally (If Time Permits)

Module 13: Encrypting and Decrypting Data
In this module, you will learn how to implement symmetric and asymmetric encryption and how to use hashes to generate mathematical representations of your data. You will also learn how to create and manage X509 certificates and how to use them in the asymmetric encryption process.
Lessons
Implementing Symmetric Encryption
Implementing Asymmetric Encryption
Lab : Encrypting and Decrypting the Grades Report
Encrypting the Grades Report
Encrypting the Grades Report