Course Outline

Module 1: .NET Programming Fundamentals for Government

Principles of Programming

  • Writing a procedural program
  • Transitioning to the object-oriented philosophy
  • Coding using fundamental C# syntax and semantics
  • Reviewing, compiling, and executing a program

Module 2: C# Language Syntax for Government

Coding Object-Oriented Applications

  • Dividing code into classes
  • Adding fields, methods, and properties
  • Defining code layout and limiting scope
  • Instantiating objects

Working with Data Types and Conversions

  • Strings
  • Dates and time
  • Integers
  • Real numbers
  • Boolean values
  • Performing calculations with mathematical operators
  • Converting between data types

Controlling Program Execution

  • IF statements
  • Writing complex criteria expressions
  • CASE (switch) statements
  • For...Next loops
  • Do While...loops

Module 3: Programming Web Applications with .Net Core API for Government

  • POST vs GET methods
  • Command validators
  • Dependency injection
  • Three-layer architecture

Module 4: Accessing Relational Databases for Government

Relational Database Concepts

  • Employing databases for fast, efficient storage
  • Selecting, inserting, updating, and deleting query syntax

Creating a SQL Server Database

  • Adding tables, fields, and indexes
  • Defining primary and foreign key relationships

Accessing the Database with Entity Framework

  • Connecting to the database
  • Storing user information
  • Retrieving existing records
  • Updating and saving user information
  • Adding and deleting records

Module 5: More Object-Oriented Programming for Government

Object-Oriented Program Layout

  • Encapsulating data
  • Ensuring proper object creation using constructors
  • Extending classes using inheritance
  • Overriding methods using virtual functions

Code Quality and Error Handling

  • Ensuring type safety with enums
  • Throwing and handling exceptions
  • Try...Catch...Finally error handling
  • Commenting code for clarity and maintenance

Requirements

  • A foundational understanding of the Windows Operating System for government use
  • Essential computer skills
  • Ability to access web applications
  • Previous basic programming experience
 35 Hours

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories