(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

Section 1: Introduction to Visual Studio

How to get started with Visual Studio

• Introduction to the .NET Framework
• A tour of the Visual Studio IDE
• How to test a project

How to design a Windows Forms Application

• Visual Studio Options and Settings
• Creating new projects

How to code and test a Windows Forms Application

• Introduction to object-oriented programming
• Properties, methods, and events
• How an application responds to events
• Coding a form
• How to run, test, and debug a project

Section 2: The C# language essentials

How to Work with Numeric and String Data

• Built-in value types
• Declaring and initializing variables and constants
• Arithmetic expressions
• Assignment statements
• Casting
• Using the Math class

How to code control structures

• Boolean expressions
• Conditional statements
• Loops

How to code methods and event handlers

• Coding and calling methods
• Parameterizing methods
• Refactoring code into a method
• Passing arguments by value and by reference to a method

How to handle exceptions and validate data

• How exceptions work
• Using Structured exception handling
• Validating data

How to use Arrays and Collections

• One-dimensional arrays
• Multi-dimensional arrays
• Jagged arrays
• Collections

Section 3: Object-Oriented Programming

How to create and use classes

• Introduction to classes
• Adding classes to a project
• Adding class members
• Fields
• Properties
• Methods
• Constructors
• Static Members
• Diagraming classes
• Structures

How to work with Inheritance

• How inheritance works
• Creating base and derived (sub) classes
• Polymorphism

Section 4: Database Programming

An introduction to database programming

• Components of a client/server system
• Introduction to relational databases
• Using SQL
• Introduction to ADO.NET

How to use ADO.NET to write your own data access code (If Time Permits)

• Connections and Commands
• Paramaterized SQL Statements
• Executing Commands

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

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

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