Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

.NET CORE Course Details
 

Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Jan 23rd @8:00PM

Faculty: Mr. Mohan Reddy (12+ Yrs of Exp,..)

Duration: 4 Months

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91 - 9246212143, 80 96 96 96 96

 

Syllabus:

Mr. Mohan Reddy

Name: Mr. Mohan Reddy (12+ Yrs of Exp,..)

 

C#. NET

Introduction to .NET

• What is .NET?
• .NET platform independent or not
• .NET Framework
• CLR (Common Language Runtime)

  • CLS (Common Language Specification)
  • CTS (Common Type System)
  • GC (Garbage Collector)
  • JIT (Just In Time)

• BCL (Base Class Libraries) or
• FCL (Framework Class Libraries)

Introduction to C#.NET

• Features of C#.NET
• Data Types in C#.NET
• Value Types and Reference Types
• Boxing and Unboxing
• Console Applications
• Console Class Methods
• Conditional and Looping control statements
• Arrays

  • Single Dimensional Array
  • Two Dimensional Array
  • Jagged Array
  • Array Class Methods
  • Array Properties

• Functions
• Pointers
• Structures
• Enumerations

Object Oriented Programming (OOP)

• OOP Features

  • Class and Object
  • Encapsulation
  • Abstraction
  • Polymorphism
  • Inheritance

• Access Modifiers

  • Private
  • Protected
  • Internal
  • Protected Internal
  • Public

• Creating Classes
• Creating Fields, Properties and methods in class
• Constructors
• Types of Constructors

  • Instance and Non Instance

• Destructors
• Method Overloading
• Method Overriding
• Abstract Methods and Abstract Classes
• Polymorphism

  • Compile Time Polymorphism
  • Run Time Polymorphism

• Abstraction

  • Properties
  • Types of Properties
  • Readonly Property
  • Writeonly Property
  • Readwrite Property
  • Accessors(set and get)

• Sealed Classes
• Partial Classes
• Keywords new, this, base
• Interfaces
• Delegates
• Types of Delegates

  • Single Cast delegate
  • Multi Cast delegate

• Generics

  • Generic Methods
  • Generic Classes
  • Constraints on Generics

• Exception Handling

  • Types of Errors
  • Syntactical Errors
  • Compilation Errors
  • Runtime Errors

• Exception Handling Mechanism

  • Logical Implementation
  • Try Catch Implementation

Class Libraries and Assemblies

• Creating User defined Class Library
• Assemblies

  • Types of Assemblies
  • Private
  • Public or Global or Shared Assembly
  • GAC (Global Assembly Cache)

Windows Forms

• Introduction
• Forms and Controls
• Properties and Methods
• Basic Controls:

  • Textbox, Button, Label, Checkbox, Radiobutton, Listbox, Combobox, Timer, Richtextbox

• Dialog Controls:

  • Open File Dialog, Save File Dialog, Font Dialog, Color Dialog

• Menus and Toolbars: Menu strip, Context Menu strip
• Container Controls: Group box, Panel, Tab Container
• SDI (Single Document Interface) Forms
• MDI (Multiple Document Interface) Form
• User Controls
• Windows Forms Control Library

ADO.NET

• Introduction
• ADO.NET Data Providers

  • SqlClient
  • OracleClient
  • OLEDB
  • ODBC

• ADO.NET Architecture

  • Connected Architecture
  • Disconnected Architecture

• Stored Procedures
• Types of Stored Procedures
• Calling Stored Procedures using ADO.NET
• Objects in ADO.NET

  • Connection
  • Command
  • Parameter
  • DataReader
  • DataAdapter
  • Dataset

• Implementing 3-Tier Architecture

Crystal Reports

• What is Report?
• Creation of Simple Report
• Steps to Create Reports
• Creating Reports with chart

ASP.NET CORE

  • Introduction to Web Applications
    • Windows Applications Vs Web Applications Vs Distributed Applications
    • ASP.NET Vs ASP.NET Core
    • Client/Server Architecture Application
    • What are Client and Server
    • Role of Web Server
    • IIS (Internet Information Services)
    • Creating a new Website on IIS
  • Introduction to MVC
    • Introduction to Design Patterns
    • Architecture Patterns
    • Intro to MVC
    • ASP.NET Web Forms (Vs) ASP.NET MVC
    • List of Versions of ASP.NET MVC
    • MVC Architecture, what is MVC?
    • What is Controller and Action Method
    • What is View C What is Model
    • Request Flow in ASP.NET MVC

      ASP.NET MVC :

  • Project Creation
    • Creating New Project in Visual Studio
    • Overview of Folders and files of MVC project
  • Controllers
    • Introduction
    • Creating Controllers Manually and by using Scaffolding
    • Action Methods in Controllers
    • Parameters to Action methods
  • URL Routing
    • Overview
    • Need of URL Routing, Parameters in URL
    • Default Parameter Values
    • Literals in URL
  • Views
    • Introduction
    • Action Results and various types of Action Results
    • Action Methods returning Action Results
    • Creating a Razor View
    • Shared Views
    • View Engines
    • ASPX View Engine Vs Razor View Engines
    • Razor Programming
  • Passing Data from Controller to View
    • View Data
    • View Bag
    • Temp Data
    • Sessions
    • Anonymous Methods
    • Strongly Typed Models
  • UI Designing
    • With HTML Controls
    • With HTML Helpers
    • With Strongly Typed HTML Helpers
  • Partial Views
    • Need of Partial Views
    • Development and Consumption of Partial Views
    • Html.Partial
    • Html.RenderPartial
    • Html.RenderAction
  • Layout Views
    • Introduction and need of Layout Views
    • Default Layout View (_Layout.cshtml)
    • Creating custom Layout Views
    • Layout Views with Sections
    • Html.RenderSection()
    • _ViewStart.cshtml
    • Overriding _ViewStart.cshtml
  • Data Annotations and Validations
    • Introduction
    • Model level validations (vs) View level validations
    • Importing jQuery Validation Plug in
    • [Required], [RegularExpression]
    • [Range], [StringLength], [Compare]
    • [Remote], ModelState.IsValid, Custom Validations
    • [Display], [Datatype], [DisplayFormat], [ScaffoldColumn]
  • LINQ to SQL
    • Introduction to LINQ
    • What is LINQ to SQL
    • Performing CRUD Operation using LINQ to SQL
  • ADO.NET Entity Framework (EF)
    • Introduction to Entity Framework
    • Various Approaches in EF
    • Understanding DbContext and DbSet
    • Entity Framework DB First
    • Entity Framework Code First Entity Framework Model First
  • Scaffold Templates
    • Need of Scaffolding
    • Creating controllers and views using scaffold
    • Understanding Index, Details, Create, Edit, Delete action methods and views
  • Filters
    • Introduction to Filters
    • ChildActionOnly, OutputCache, ValidateInput
    • ValidateAntiForgeryToken, HandleError
    • Action Filters, Result Filters, Authorization Filters
    • Exception Filters, Custom Filters
    • Authentication and Authorization
    • Types of Authentications
    • AllowAnonymous
  • Web API
    • Introduction to distributed applications
    • Web Services Vs WCF Vs Web API
    • Understanding HTTP Methods (GET, POST, PUT, DELETE)
    • Creating API Controller and API configuration
    • Calling Web API from JQuery
    • CRUD operations using JQuery AJAX with Web API
    • Enabling CORS
    • Consuming Web API from MVC Project
  • Developing Single Page Applications
    • What is SPA
    • Need of SPA and Getting started
    • Angular Integration

      ASP.NET CORE MVC
  • Introduction to .NET CORE
    • What is .NET CORE
    • What’s new in.NET core
    • ASP.NET core
    • .NET Core Vs ASP.NET Core
  • ASP.NET CORE MVC Applications
    • Introduction
    • Setting up a new project
    • Command line tools and code
    • ASP.NET Core MVC project structure
    • Program and Stratup Classes
    • Main method in ASP.NET Core Applications
  • Startup and Middleware’s
    • Introduction
    • How Middleware Works
    • Configure and Configure Services Methods
    • Exception Handling Middleware
    • Routing Middleware
    • Static Files Middleware
    • Setting up ASP.NET MVC Middleware
  • Controllers in MVC Framework
    • Introduction
    • MVC design pattern
    • Routing
  • Views in MVC Framework
    • Creating Simple Views
    • Tag Helpers for creating Views
    • Built-in Tag Helpers
    • Custom Tag Helpers
  • Models in MVC Framework
    • Introduction
    • Models and Views
  • Entity Framework CORE
    • Introduction
    • Installing EF Core
    • EF Core Architecture and Libraries
    • Creating and Implementing DB Context
    • Configuring EF Services
    • Entity Framework Migrations
    • Various Approaches in EF (DB First and Code First)
    • Creating CRUD Application in MVC Core using DB First
    • Creating CRUD Application in MVC Core using Code First
    • Dependency Injection Introduction
    • Dependency Injection Containers
    • Integrated support of Dependency Injection in ASP.NET Core
    • Implementing Dependency Injection in MVC Core Applications
  • Error Handling In MVC Core Applications
    • Handling Client Errors
    • Handling Server Errors
  • ASP.NET CORE Identity
    • Introduction to Identity Framework
    • Authentication Services and Middleware
    • Identity in ASP.NET Core MVC
    • Open Authentication
    • Authorization
  • WEB API Core
    • Creating a WEB API Core Service
    • Testing WEB API Core Services using Swagger
    • Implementing Dependency Injection in WEB API Core
    • Consuming WEB API Core Service in MVC CORE using JQUERY
    • Consuming WEB API Core Service in MVC CORE using C#

SQL SERVER

Introduction To SQL Server

• Understanding Data & Information
• Database
• DBMS
• RDBMS
• DB Design
• Types of Databases
• Client Server Architecture
• SQL Server versions
• SQL Server Management Studio
• Creating DB
• Sub Languages of TSQL

  • DDL
  • DML
  • TCL
  • DCL
  • DQL

• Creating Tables
• Insert,Delete,Update Data into Tables
• Normalization
• Constraints
• Unique
• Not Null
• Primary key
• Check
• Default
• Foreign Key
• Working With Single Table Queries
• Writing Queries using SELECT Statement
• Understanding Query Flow
• Operators in SQL Server
• Clauses in SQL Server
• Filtering Data Using WHERE Clause
• Sorting Data using ORDER BY Clause
• Avoid Duplicates using DISTINCT Clause
• Using Top Clause

• DML Commands
• Copying Data From one Table to Another
• Insert Command
• Update Command
• Delete Command
• DDL Commands
• Create command
• Alter Command
• Drop Command
• Truncate Command
• Delete vs Truncate
• Built in Functions
• Scalar Functions

  • String
  • Date
  • Mathematical
  • Conversion
  • Coalesce
  • Rank and Dense Rank
  • EOMONTH
  • DateFromParts
  • ISNULL
  • IIF
  • Row Number
  • Running Total

• Group Functions
• Aggregate Functions

  • Cunt(*)
  • MAX()
  • MIN()
  • AVG()
  • SUM()

• Deterministic Functions
• Non-Deterministic Functions
• SET Operators
• Sub Queries
• Importance of Sub Query
• Types of Sub Queries
• Nested Queries

• JOINS
• Importance of Joins
• Types of Joins

  • Inner Join or Equi Join
  • Outer Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Self Join
  • Cross Join
  • Advanced Joins

• Database Transactions
• Transactions Using Commit & Rollback
• ACID Properties
• Working with Locks
• Viewing Dead Locks
• Database Security
• Understanding Privileges
• Types of Privileges
• Granting & Revoking Privileges
• Temporary Tables
• Local Temp Tables
• Global Temp Tables
• Views
• Importance of Views
• Types of views
• Indexes
• Clustered & Non Clustered
• Stored Procedures
• Triggers
• Cursors
• Schemas
• Backup & Restore
• SQL Server Agent
• Advanced Topics in SQL Server