This course will cover the practical aspects of multi-tier application development using the .NET framework. The goal of this course is to introduce the students to the basics of distributed application development. We will introduce the students to Web Service development and .NET remoting. Technologies covered include the Common Language Runtime (CLR), .NET framework classes, C#, ASP.NET, and ADO.NET. We will also cover service oriented architecture, design, performance, security, content managements systems and deployment issues encountered in building multi-tier distributed applications

Course content

C#

NET: What You Need To Know

• Installation
• .NET Executables and the CLR
• Using Visual Studio

First C# Programs

• Hello, World
• Namespaces
• Variables and Expressions
• Using C# as a Calculator
• Input/Output in C#
• .NET Framework Class Library

Data Types in C#

• Data Types
• Integer Types
• Floating Point Types
• Decimal Type
• Characters and Strings
• Boolean Type
• Conversions
• Nullable Types

Operators and Expressions

• Operator Cardinality
• Arithmetic Operators
• Relational Operators
• Logical Operators
• Bitwise Operators
• Assignment Operators
• Expressions
• Checked and Unchecked

Control Structures 

• If Tests
• Loops
• Arrays
• Foreach
• More about Control Flow
• Switch

Object-Oriented Programming

• Objects
• Classes
• Inheritance
• Polymorphism
• Object-Oriented Languages
• Components

Classes

• Classes as Structured Data
• Methods
• Constructors and Initialization
• Static Fields and Methods
• Constant and Read only

More about Types

• Overview of Types in C#
• Value Types
• Boxing and Unboxing
• Reference Types

Methods, Properties and Operators 

• Methods
• Parameter Passing
• Method Overloading
• Variable-Length Parameter Lists
• Properties
• Operator Overloading

Characters and Strings

• Characters
• Strings
• String Input
• String Methods
• StringBuilder Class
• Programming with Strings

Arrays and Indexers

• Arrays
• Array
• Random Number Generation
• Jagged Arrays
• Rectangular Arrays
• Arrays as Collections

Inheritance

• Single Inheritance
• Access Control
• Method Hiding
• Initialization

Virtual Methods and Polymorphism

• Virtual Methods and Dynamic Binding
• Method Overriding
• Fragile Base Class Problem
• Polymorphism
• Abstract Classes
• Sealed Classes
• Heterogeneous Collections

Formatting and Conversion

• ToString
• Format Strings
• String Formatting Methods
• Type Conversions

Exceptions

• Exception Fundamentals
• Structured Exception Handling
• User-Defined Exception Classes
• Inner Exceptions

Interfaces

• Interface Fundamentals
• Programming with Interfaces
• Using Interfaces at Runtime
• Resolving Ambiguities

.NET Interfaces and Collections

• Collections
• IEnumerable and IEnumerator
• Copy Semantics and ICloneable
• Comparing Objects
• Generic Types
• Type-Safe Collections

Delegates and Events

• Delegates
• Anonymous Methods
• Events

Introduction to Windows Forms

• Creating Windows Applications Using Visual Studio
• Partial Classes
• Buttons, Labels and Textboxes
• Handling Events
• Listbox Controls

Additional C# Features 

• Auto-Implemented Properties
• Implicitly Typed Variables
• Object Initializers
• Collection Initializers
• Anonymous Types
• Partial Methods
• Extension Methods
• Lambda Expressions
• Language-Integrated Query (LINQ)

SQL Server: Beginner to Advanced

Getting Started with SQL Server

• Introduction to Database
• Introduction to SQL Server
• Installing SQL Server and Components
• SQL Server Database and Tables
• SQL Keys
• SQL Commands
• SQL Constraints
• Types of Database

T-SQL Fundamentals with SQL Server

• Data Types, Variables and Operators
• SQL Server Control Of Flow
• SQL Query and Sub Query
• SQL Clauses
• SQL Predicates
• SQL Joins
• SQL Exceptions
• .Catch

SQL Server Views and Indexes

• SQL Server Views
• Types of Views
• SQL Sever Indexes
• Types of Indexes

SQL Server Stored Procedures and Functions

• Introduction to Stored Procedure
• Types of Stored Procedure
• Creating Stored Procedures For Insert, Update and Delete
• Stored Procedures Parameters
• SQL Server Functions
• Scalar Functions
• Table Valued Functions

SQL Server Triggers and Cursors

• SQL Server Triggers
• Types of Triggers
• SQL Server Cursors
• Types of Cursors
• Cursor Alternatives

Understanding and Managing Azure SQL Database

• Introduction to Azure SQL Database
• Database Deployment Models
• Azure SQL Database Server
• Creating and Managing Single Database
• Purchasing Models: DTU and vCore
• Azure SQL Database Tools
• Database Migration Using DMA
• Creating and Managing Elastic Pool
• Creating Managed Instance

Windows Forms

Introduction to Windows Forms

• What Are Windows Forms?
• Windows Forms Class Hierarchy
• Building a Form
• The Application Class
• Trapping Events
• Buttons
• Labels and Textbox Controls

Visual Studio and the Forms Designer

• Using the Forms Designer
• Code Generated by Forms Designer
• Adding Event Handlers
• Creating Attractive Forms
• Creating Easy To Use Forms

Using Controls

• Checkbox, Radio Button, and Group Box
• Numeric Up/Down
• Trackbar
• Progress
• MonthCalendar
• DateTimePicker

List Controls

• List box and Combo box
• Domain UpDown
• List View
• Storing Objects in List Controls
• Working with Dialogs
• Modal vs. Modeless Dialogs
• Message Boxes
• Common Dialogs
• Creating a Modal Dialog
• Configuring the Dialog Result
• Access Data from the Dialog
• Validating Data
• Error Provider Control
• Modal Dialogs
• Creating a Modeless Dialog

Menus, Tool bars and Status Bars 

• Main Menus
• Context Menus
• Building a Status Bar
• Building a Toolbar
• Using the Timer Control

Using Advanced Controls 

• Panel
• Tree View
• Splitter
• Tab Control
• Resources
• Image Resources
• Resource Files
• String Resources
• Working with Resources in Visual Studio
• Resource Managers
• Cultures and Internationalization
• Building Localizable Forms

Data Access and Data Binding

• NET Overview
• .NET Data Providers
• Using DataReaders
• Data Sets
• Data Tables
• Data Views
• Data Binding
• Interacting with XML Data

 .NET Windows Forms

• Tool Strip Control
• Split Container Control
• Web Browser Control
• Data Grid View Control
• Other .NET Controls
• New Data Binding
• Application Settings
• Background Worker Component
• Click Once Deployment

ASP.NET

Introduction to ASP.NET 

• From ASP to NET
• Web Forms
• Web Services
• NET Features

Web Forms Architecture

• Page Class
• Web Forms Life Cycle
• Web Forms Event Model
• Code-Behind

ASP.NET and HTTP 

• Request/Response Programming
• HTTP Request Class
• HTTP Collections
• HTTP Response Class
• Redirection
• HTTP Utility Class

Web Applications Using Visual Studio

• Using Visual Web Developer
• Visual Studio Forms Designer
• Using Components
• Shadow Copying
• Using the Global.asax File
• Data Binding

State Management and Web Applications 

• Session State
• Application State
• Multi Threading Issues
• Cookies

Server Controls 

• HTML Server Controls
• Web Forms Server Controls
• Rich Controls
• Validation Controls
• User Controls

Caching in ASP.NET 

• What Is Caching
• Page-Level Caching
• Page Fragment Caching
• Optimizing Your ASP.NET Application
• Application Caching

ASP.NET Configuration and Security Fundamentals

• Configuration Overview
• Authentication and Authorization
• Forms Authentication
• Windows Authentication
• Security and NET

Debugging, Diagnostics and Error Handling

• Debugging
• Application Tracing
• Page Tracing
• Error Handling

More Server Controls 

• Most recent ASP.NET Controls
• Menus
• Master Pages

Data Access in ASP.NET 

• Data Source Controls
• Connection String Storage
• Grid View
• Details View
• Form View
• Object Data Sources
• List View
• Data Pager
• Linq Data Source

Personalization and Security 

• Configuration Overview
• Themes
• Skins
• Security in NET
• Membership and Roles
• Login Controls
• User Profiles

Introduction to ASP.NET AJAX 

• Rich Client Applications
• AJAX
• Script Manager
• Update Panel 5

HTTP Pipeline

• Pipeline Architecture
• Context
• Applications
• Handlers
• Modules

Webservices

What Are Web Services?

• Introduction to Distributed Computing
• Network Latency
• Object State and Scalability
• Interoperability
• SOAP
• WSDL
• UDDI
• Web Service Business Models
• Service Oriented Architecture (SOA)
• NET Web Services
• Web Service Enhancements (WSE)
• Windows Communications Framework (WCF)

Web Services Fundamentals

• Creating a Web Service Using NET
• Deploying a Web Service Using IIS
• Testing a Web Service
• HTTP
• XML
• SOAP
• Web Service Clients
• WSDL

Developing ASP.NET Web Services

• Using Visual Studio to Develop Web Services
• Visual Web Developer
• Using ASP.NET Development Server
• An Overview of the Web Services Namespaces
• Deriving from the WebService Class
• @Webservice Attribute
• WebService Class
• Adding a WebMethod to Web Services
• Debugging Web Services

Web Service Clients

• Web Service Proxies
• Web Services Description Language Tool (Wsdl.exe)
• Understanding the Proxy Code
• Creating a Proxy with Visual Studio
• Returning Complex User-Defined Data Types
• Writing a Client for the Google Search API

ADO.NET

Introduction to ADO.NET

• Microsoft Data Access Technologies
• From ADO to NET
• NET Architecture
• Namespaces and Classes
• Interfaces
• DataSets and Disconnected Access
• First ADO.NET Programs
• Acme Computer Case Study

ADO.NET Connections

• .NET Data Providers
• IDbConnection
• Connection Classes
• Connection Strings
• Connection Pooling
• Connection Events
• Error Handling
• Database Programs with NET

ADO.NET Commands 

• IDbCommand
• Command Objects
• Creating Commands
• Executing Commands
• Parameterized Queries
• Command Types
• Using Stored Procedures
• Batch Queries

DataReaders and Connected Access 

• DataReaders
• IDataRecord
• Type-Safe Accessors
• Null Columns
• ExecuteReader Options
• Multiple Result Sets
• Obtaining Schema Information

Data Sets and Disconnected Access 

• Data Set
• Data Adapter
• Command Objects
• Data Table
• Data Column
• Data Row
• Row States and Versions
• Accept or Reject Changes
• Data Table Events
• Updating a Database from a Data Set
• Command Builders

More About Data Sets

• Filtering Data Tables
• Multiple Table DataSets
• Schema
• Constraints
• Relations
• Navigating a DataSet
• DataMapping
• Creating a DataSet Programmatically

XML and ADO.NET(Not covered in the Windows and Web offerings)

• Strong Coupling Between ADO.NET and XML
• Rendering XML from a DataSet
• Controlling XML Output
• Reading XML into a DataSet
• XML Schema and DataSets
• Typed DataSets
• Table Adapters
• Synchronizing DataSets and XML
• XML Serialization

New Features in ADO.NET

• Using Server Explorer in Visual Studio
• Asynchronous Database Operations
• Multiple Active Result Sets
• Bulk Copy in NET

WCF

Introduction to WCF

• What is WCF?
• Address, Binding and Contract
• WCF Services and Clients
• IIS Hosting
• WCF Architecture

Addresses and Bindings 

• Addresses
• Bindings
• Message Exchange Patterns
• Configuring Bindings
• Interoperating with ASMX Web Services
• Hosting in a Console Application
• Channel Factories
• Multiple Endpoints

Service Contracts 

• Defining Service Contracts
• Defining Operation Contracts
• Services With Multiple Contracts
• Contract Inheritance
• Operation Overloading

Instance Management

• Using Per-Call Services
• Using Per-Session Services
• Using Singleton Services
• Configuring Behaviors

Data Contracts

• Implementing Data Contracts
• Mapping Data Contracts to XSD Schema
• Serialization
• Arrays and Generic Collections
• Enums
• Versioning Data Contracts

More about Service Contracts 

• Versioning Service Contracts
• Implementing Message Exchange Patterns
• Oneway Contracts
• Duplex Contracts
• Asynchronous Proxies

Handling Errors

• Faults and Exceptions
• Generating and Handling Faults
• Fault Contracts
• Faults and Sessions

WPF

Introduction to WPF

• Why WPF?
• What Is WPF?
• NET Framework 4.5 (WinFX)
• WPF Overview
• Application and Window
• A Simple WPF Application
• Using Visual Studio
• Brushes
• Panels

XAML 

• Role of XAML
• Elements and Attributes
• Namespaces
• Property Elements
• Type Converters
• Content Property
• Collections
• XAML and Procedural Code

 WPF Controls 

• Button
• Label
• TextBox
• ToolTip
• RadioButton
• CheckBox
• ListBox
• ComboBox

Layout

• Sizing
• Positioning
• Transforms
• Canvas
• Drawing Shapes
• StackPanel
• WrapPanel
• DockPanel
• Grid
• Scrolling
• Scaling

Dialogs

• Message Boxes
• Win32 Common Dialogs
• Custom Modal Dialogs
• Custom Modeless Dialogs

Menus and Commands 

• Menus
• Context Menus
• Icons on Menu Items
• Commands
• Keyboard Shortcuts
• Disabling Menu Items
• Checking Menu Items

Tool bars and Status Bars

• Toolbars
• Toolbars and Commands
• Status Bars

Data Binding

• Binding Sources
• Sharing Sources with DataContext
• Data Templates
• Value Converters
• Collection Views
• Data Providers
• Validation Rules

MVC

Introduction

• ASP and ASP.NET WebForms
• Web Standards and REST
• JavaScript and AJAX
• The MVC Design Pattern
• Unit Testing
• Managing Dependencies

ASP.NET MVC Architecture

• NET Platform
• Controllers, Models, and Views
• URL Routing
• Controller Actions
• Razor View Engine
• Extensibility

Defining the Model

• Persistence Ignorance
• Repository Pattern
• Object Relational Mapping (ORM)
• NET
• Entity Framework (EF)
• nHibernate
• Using an IoC Container

Routes and URLs

• Introduction to Routing
• Defining Routes
• Route Evaluation
• The Controller Factory
• Constraints
• Exempting URLs
• Constructing Outgoing URLs
• Unit Testing Route

Controllers and Actions 

• IController, Controller Base, and Controller
• Defining Actions
• Action Selectors
• Action Filters
• HTTP Verbs
• Http Context and Route Data
• Maintaining Testability
• Returning Data with Action Result
• Parameters and the Model Binder
• Asynchronous Action Methods

Views 

• View Engines
• Templates and Scaffolding
• Razor Syntax
• ViewData and ViewBag
• Strongly-Typed Views
• Layout Pages
• Custom Sections
• Partial Views
• Child Actions
• Using a View Model Object

HTML Helpers 

• Basic Helpers
• Strongly-Typed Helpers
• Creating Custom Helpers
• Declarative Helpers

Data Validation

• Data Annotations
• Validation HTML Helpers
• ModelState
• IValidatableObject
• Client Side Validation

Authentication and Authorization 

• Using Windows Authentication
• Building a Custom Account Controller
• Configuring Forms Authentication
• Using the Authorize Attribute

AJAX

• Controller Actions for Ajax
• Ajax Helpers
• Unobtrusive Ajax
• Ajax with jQuery

Customizing and Extending ASP.NET MVC 

• Customizing and Extending ASP.NET MVC
• NET MVC Pipeline
• Advanced Routing
• Custom Global Filters
• Customizing MVC Code Templates
• Creating a Custom Controller Factory

Deployment

• Server Requirements
• Configuration Options

Web API

ASP.NET WEB API – Basics

• Introduction to ASP.NET Web API
• Creating ASP.NET Web API Application
• How to add Swagger in Web API
• How to use Fiddler to test Web API
• How to use POSTMAN to test Web API
• NET Web API using SQL Server
• Content Negotiation in Web API
• Media Type Formatter in Web API
• How to Implement GET Method in Web API
• How to Implement POST Method in Web API
• How to Implement PUT Method in Web API
• How to Implement DELETE Method in Web API
• Custom Method Names in Web API
• Parameter Binding in Web API
• Consuming Web API Service From jQuery
• Calling Web API Service in a Cross Domain Using jQuery AJAX
• Cross-Origin Resource Sharing in WEB API

WEB API Routing and Attribute Routing

• NET Web API Routing
• Routing Variations in WEB API
• Routing and Action Selection in Web API
• NET Web API Attribute Routing
• Optional Parameters in Web API Attribute Routing
• Route Prefix in Web API
• Web API Attribute Routing Route Constraints
• Route Names and Route Orders in Attribute Routing

ASP.NET WEB API – Security

• Authentication and Authorization in Web API
• NET Web API Basic Authentication
• Role-Based Basic Authentication in Web API
• Web API Service with Basic Authentication
• HTTP Message Handlers in WEB API
• Basic Authentication Using Message Handler in Web API
• HTTP Client Message Handler in Web API
• Token Based Authentication in Web API
• Client Validation Using Basic Authentication in Web API
• Refresh Token in Web API
• HMAC Authentication in Web API

Web API Versioning

• Web API Versioning Using URI
• Web API Versioning using Query string Parameter
• Web API Versioning Using Custom Header
• Web API Versioning Using Accept Header
• Web API Versioning Using Custom Media Types

Advanced Concepts

• Enable SSL in Visual Studio Development Server
• Enable HTTPS in Web API

To see the full course content Download now