Comprehensive Dot Net Course – Master .NET Framework at Acrosys Technologies

What will I learn in this course?

• C#


• SQL SERVER


• HTML5


• CSS3


• Bootstrap


• ASP.NET MVC


• Entity Framework


• ASP.NET Web API

Who is this course for?

This course is for anyone who wants to learn how to build applications from beginning to end, or anyone who just wants to strengthen their front and back-end development skills.

Session 1: Introduction to C#

History of C# Version,C# Code Execution,Installing and Configuring Visual Studio,Variable,Data Type,Safe Type Casting with IS and AS Operator

Session 2: C# Conditional Statements and Loops

Operators,Operators precedence, Conditional Statements: if, if..else if, switch., , Loops: do..while, while, for, foreach., ,Jump Statements

Session 3: C# Arrays and Strings

Arrays,Types of Arrays,Strings,String Methods

Session 4: Object-Oriented Programming in C#

Object-Oriented Programming Concepts,Access Modifiers,Constructor,Inheritance,Methods,Structure

Session 5: C# Concepts: Abstract Class, Interface and Partial Class

Abstract Class,Interface,Interface vs. Abstract Class,Static Class,Extension Methods,Partial Class,Partial Methods

Session 6: C#: Property, Indexer, Attributes and Exception Handling

Property,Indexer,Exceptional Handling,Enum,Attributes

Session 7: C# Concepts: Anonymous Type, Delegates, Events and Lambda

Extension Methods,Anonymous Type,Var and Dynamic,Delegates,Events,Anonymous Methods,Lambda Expression,Expression Tree

Session 8: C# Asynchronous Programming – Async and Await

What is Synchronous and Asynchronous?,Asynchronous Programming Patterns in .NET,Asynchronous Programming Model (APM),Event-based Asynchronous Pattern (EPM),Task-based Asynchronous Pattern (TAP),Async and Await in Task-based Asynchronous Pattern TAP,Asynchronous vs. Multithreading

Session 9: 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

Session 10: 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,Try..Catch

Session 11: SQL Server Views and Indexes

SQL Server Views,Types of Views,SQL Sever Indexes,Types of Indexes

Session 12: 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

Session 13: SQL Server Triggers and Cursors

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

Session 14: 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

Session 15: Introduction to HTML

HTML5 Basics: Tags, Elements and Attributes,HTML5 Tables, Lists and Layouts,HTML5 Forms, Media and Storage,HTML5 New Input Elements,HTML5 Forms Attributes,HTML5 Validations,HTML Media,HTML Audio,HTML Video,HTML and JavaScript,HTML Storage API,HTML Graphics

Session 16: CSS3

CSS3 Fundamentals,CSS3 Advanced Concepts

Session 17: Bootstrap

Introduction to Bootstrap,Bootstrap 4 Flexbox, Style and Utilities,Bootstrap 4 CSS Components: Images, List, Tables, Button and Cards,Bootstrap 4 CSS Components: Forms, Navbars, Pagination and Spinners

Session 18: Introduction to ASP.NET MVC

Introduction to ASP.NET MVC,ASP.NET MVC vs. ASP.NET Web Forms,Advantages of ASP.NET MVC,Creating ASP.NET MVC5 Project,Understanding ASP.NET MVC Folder Structure,Layout, Sections and View Start,MVC Pattern,MVC vs. Tier,Action Methods and Result Types

Session 19: ASP.NET MVC Fundamentals

Razor View Engine,Razor View Engine vs. WebForms Engine,Razor Syntax,Creating Custom View Engine,Routing : Routes and Constraints,HTML Helpers,Validation Summary,AJAX Helpers,Data Passing Techniques: ViewData, ViewBag, TempData, Session, QueryString,Partial Views

Session 20: ASP.NET MVC Forms and Validation

ASP.NET MVC Forms,Model Binding,Custom Model Binding,Synchronous Forms,Asynchronous Forms,Forms Validations : Server Side and Client Side,Custom Validation

Session 21: Working with Data Using Entity Framework

Introduction to Entity Framework,Creating Database Using Code First,Database CRUD Operations,Working with jQuery AJAX,Calling Stored Procedure and Functions,Listing, Paging, Sorting using WebGrid,AJAX WebGrid

Session 22: .NET CORE

NET Applications and Tools,.Net Standards,Core C#,Classes, Records, Structs, and Tuples,Arrays,Delegates, Lambdas, and Events,Collections,Language Integrated Query,Errors and Exceptions,threading and Tasks and Asynchronous Programming,Reflection, Metadata,Managed and Unmanaged Memory,Libraries, Assemblies, Packages, NuGet,Dependency Injection and Configuration,File Handling, Stream Management and Serialization,Networking,Security,Entity Framework Core

Session 23: Asp.net Core

Understanding Web Technologies,Introduction of ASP.Net Core,Understanding ASP .Net Core Project Structure,Understanding Static Files,Writing Custom Middleware,State Management,Working with Razor Pages and Razor Component,HTML Helper classes,MVC in ASP.Net Core,Data Handling in .Net Core using LINQ,Data Handling in .Net Core using EF Core,Security,Call WEB API,Globalization & Localization,Unit Testing,Deployment

Session 24: Web API

Introduction and Architecture,Methods in API - Postman,Working with Data and ODATA,CRUD in API,Routing,Configurating,Content Formatter,Security and DI

Session 25: Building RESTful Services with ASP.NET Web API

Introduction to ASP.NET Web API,Building ASP.NET Web API,ASP.NET Web API CRUD Operations,Testing Web API Using Postman,Consuming Web API in ASP.NET MVC,Performing CRUD Operations using ASP.NET MVC

Session 26: Introduction to Entity Framework: Getting Started

Introduction to Entity Framework,Introduction to ORM Tools,Introduction to Entity Framework,Entity Framework Architecture,Data Modeling Approaches,Getting Started With EF

Session 27: Entity Framework Database First Approach

Database First Approach,DbContext in EF 6,EF CRUD Operations Using ASP.NET MVC,Mapping Stored Procedures and Functions,Calling Stored Procedures and Functions,Performing CUD Operations

Session 28: Entity Framework Code First Approach

EF Code First Modeling,EF Conventions,Database Annotation,EF Fluent API,CRUD Operations Using ASP.NET MVC,Calling Stored Procedure and Functions,Handling Input and Output Parameters,Handling Multiple Result sets

Session 29: EF Code First Migrations and Relationships

Code First Migrations,Script Migrations,Migrations with Existing Database,Reverse Engineering,Database Initializers,Database Relationships – one-to-one, one-to-many, many-to-many,EF Inheritance

Session 30: Entity Framework Advanced Concepts

Queries,Entity and States,Data Loading,Transactions and Async Query,Working with Entity States,Eager Loading vs Explicit Loading,Handling Concurrency Conflicts,Working with Transactions in EF

Session 31: Introduction to Web API: Getting Started

Introduction to SOA,Introduction to REST,Introduction to ASP.NET Web API,WCF vs. Web API,Building Web API,Testing API Using Postman

Session 32: ASP.NET Web API Fundamentals

Routing – Convention and Attribute Routing,Route Constraints,Action Result,Content Negotiation,Media Type Formatters,Model Binding,Model Validation,Handling Validation Errors

Session 33: Building RESTful Services with ASP.NET Web API

Introduction to ASP.NET Web API,Building ASP.NET Web API,ASP.NET Web API CRUD Operations,Testing Web API Using Postman,Consuming Web API in ASP.NET MVC,Performing CRUD Operations using ASP.NET MVC

Session 34: ASP.NET Web API Advanced Concepts

ASP.NET Web API Pipeline,Web API Filters,Creating Custom Filters,Exception Handling,Dependency Injection,Web API Versioning,Web API Hosting

Session 35: Angular

Overview of Angular,Typescript,Architecture of Angular,Angular Components, Modules, Data Binding,Angular Directives,Angular Forms, validations, Routing,Pipes, Services, Dependency injection, HTTP Client,Observable,Testing Angular