• Introduction and characteristics

• Prerequisites and Environment

• .Net core application types and configuring applications

• Kinds of applications with .Net core

• .Net core data types

• .Net core garbage collection

• .Net core modularity

• .Net core libraries

• .Net core project files, package references and Nuget package manager.

• Visual studio

• Building .Net core applications

• C# Fundamentals
• Data types
• Operators
• Struct,enum , classes,partial classes and interfaces
• Static methods, instance methods and property methods
• Conditions & Loops
• Anonymous types,nullable types , dynamic types , value and reference types
• Date and time, stringbuilder, covariance and contra variance
• Extension methods
• Collections
• Exception handling
• File I/O
• Events and Delegates
• Net for database connectivity

• Introcution
• Net core project structure
• Dependency injection in .Net core
• Middle ware
• Logging
• Environment variables
• Serving static content
• MVC – Model  view controller
• Routing
• Razor views
• Entity framework
• Dbcontext
• net core identity
• Web API
• Web API Controllers
• Configure Web API
• Routing in ASP.NET Web API
• Parameter Binding in ASP.NET Web API
• Return Types of Web API Action Method
• Request, Response Formats in ASP.NET Web API
• Media Type Formatters in ASP.NET Web API
• Web API Filters
• Hosting web applications with IIS

1. Introduction to Basic Database Concepts

• Limitations of File Management System.
• Basic Concepts of Advantages of DBMS.
• Exploring Relational DBMS
• Understanding Client and Server
• Entities and their Relationships
• First Normal Form
• Second Normal Form
• Third Normal

2. Introduction to SQL Server

• Basic Features Components and Tools
• Starting and Stopping SQL Server Instances / Services
• Introduction to Management Studio
• Types of System Databases in SQL

3. Introduction to SQL/Tsql

• Basics of SQL Types of SQL Statements
• DDL, DML, DQL, DCL and TCL
• Create Database using Management Studio
• Datatypes in SQL Server
• Exploring DDL Statements on Table using Management Studio
• Working with constraints
• Working with DML
• Working with Queries
• Working with tsql
• Using Functions, Procedures, triggers, views, table expressions, Joins, Union, Set operations, Sub querirs, Indexes, Locks
• Xml datatype.

• Angular Syllabus:

  Introduction, angular cli, npm, ng, bootstrap css, creating an angular project, Angular application directory structure, bootstrapping angular Angular  introduction

• Modules and Components :

     Creating and nesting components, templates, component styles and  selectors,  app modules,       modules, and feature modules. Data and Property bindings, string interpolation

• Directives, Pipes, Interface, Classes:

     Component directives, structural directives, Attribute directives, and custom directives. Built-in       pipes and custom-defined pipes, pipe transform, pipes with arguments. Using interfaces as             type, as function type, as array type, implementing interfaces, Classes, Abstract class,                       Constructor, properties and methods, Inheritance, Generic classes and Generic interfaces

• Services, RxJs, and Observable:

     Dependency injection, creating a service, Using a service, Features of Rxjs,  Observer,                           Observable, Operators, Subscription, Subject and Schedulers

• Forms, Http, Routing:

     Angular forms module, Template and model-driven forms, Form control, Form group and Form       array. HTTP Client, HTTP client Module, App Routing Module, Adding Navigation, Setting up an             Angular Router, angular-routing.  module.ts,  Router Link, Router Link Active and Activated Route

• Integration:

     Integrating angular with Net core