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

Batch Date: June 20th @7:00PM

Faculty: Mr. V. Venakta Prasad (17+ 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:

.NET

• .NET Introduction

  Differences between Programming Languages,
  Platform Dependency Vs Platform Independency,
  .NET Languages & Compilers,
  CIL/MSIL code,
  Language Interoperability

• .NET Runtime

  .NET Framework, Architecture of .NET Runtime,
  Managed and Un-Managed Code
  CLI Specifications, Versions of .NET Runtime,
  .NET Class Libraries

• CLR

  Security Manager, JIT Compiler, Garbage Collector

C#.NET

• Introduction and History of C#
  
  
• C# Data Types
  (Integer Types, Float, Double, Decimal Types, Boolean Type,                            DateTime Type, GUID Type, Char & String Types, Object Type)

• Variables & Fields

  Syntax of Variable & Field Declarations,
  Value Types Vs Reference Types
  Nullable Value Types, Implicitly Typed Variables, Dynamic Type
  Boxing Vs Un-Boxing

• C# Programming Syntax, Operators, Conditions, Loops, Arrays
  
  
• Working with Visual Studio

  Versions of Visual Studio IDE, Project Templates, Item Templates
  Solution Explorer, Compilation, Execution

• Collections

  Stack, Queue, Array List, Hash Table, Generics
  Generic Collections - List, Dictionary, and other Collection classes

• LINQ

  What is LINQ
  LINQ Vs SQL, LINQ to Objects, LINQ to Databases,
  LINQ to XML
  Implementing LINQ on Arrays, Collections & Objects

• C# with .Net Core Library
• OOPs and Advanced OOPs Concepts
• Encapsulation, Inheritance and Polymorphism
• Abstraction (Interface, Abstract Class)
• Extension Methods
• Exceptions
• Multi-Threading, Async / await
• String Function, StringBuilder, Enum
• Delegates • Class Libraries and Assembly references • Reflections
• Design Patterns
• Assemblies
• Task Parallel Library (TPL)

ASP.NET Core MVC

Introduction to .NET Core and ASP.NET Core

• What is .NET Core?
• Evolution and Benefits of .NET Core
• ASP.NET Core Introduction
• Difference between .NET Core and ASP.NET Core

ASP.NET Core MVC Architecture

• MVC Pattern Overview
• Creating a New ASP.NET Core MVC Project
• Exploring Project Structure
• Command-line Tools (dotnet CLI)
• Program.cs and Startup.cs
• Execution flow: Main() method → Hosting → Middleware

Middleware & Startup Configuration

• What are Middleware Components?
• Role of ConfigureServices() and Configure() Methods
• Setting up Routing Middleware
• Static Files Middleware
• Error Handling Middleware
• Custom Middleware

Hosting Models in ASP.NET Core

• Self-Hosting vs IIS Hosting
• Kestrel Web Server
• Reverse Proxy Servers (Nginx, IIS)
• ASP.NET Core Hosting Flow

Controllers in MVC

• Role of Controllers in MVC
• Creating Controllers
• Routing Overview and Attribute Routing
• Action Methods & Parameters

Views and Razor

• Creating Views (.cshtml files)
• Razor Syntax Overview
• Tag Helpers: Built-in & Custom
• Layout Pages and View Imports

Models in MVC

• Understanding Models
• Using Models with Views (View Model)
• Strongly Typed Views

Entity Framework Core (EF Core)

• Intro to ORM and EF Core
• Installing and Configuring EF Core
• DB Context Class
• Migrations
• CRUD Operations
• DB First vs Code First Approach

Dependency Injection (DI)

• What is Dependency Injection?
• DI in .NET Core
• Configuring Services in Startup
• Using DI in Controllers and Services

Error Handling

• Client-Side vs Server-Side Errors
• Exception Filters
• Developer Exception Page
• Custom Error Pages

ASP.NET Core Identity

• What is Identity Framework?
• Authentication vs Authorization
• Middleware for Security
• User Registration and Login
• Roles and Claims
• External Authentication

Web API in ASP.NET Core

• Creating Web APIs using ASP.NET Core
• Routing in Web APIs
• Using Swagger for API Testing
• Dependency Injection in APIs
• Calling API from MVC

Publishing & Hosting

• What is Publishing?
• Hosting Options

SQL SERVER

Introduction to SQL Server

• Understanding Data vs. Information
• What is a Database?
• Introduction to DBMS and RDBMS
• Basics of Database Design
• Types of Databases
• Client-Server Architecture
• SQL Server Versions Overview
• Installing & Navigating SQL Server Management Studio (SSMS)

Getting Started with SQL Server

• Creating and Managing Databases
• T-SQL Overview and Categories:

• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• TCL (Transaction Control Language)
• DCL (Data Control Language)
• DQL (Data Query Language)

Creating and Managing Tables

• Creating Tables and Table Structures
• Insert, Update, and Delete Operations
• Normalization Concepts (1NF to 3NF)
• Applying Constraints:

• PRIMARY KEY
• FOREIGN KEY
• UNIQUE
• NOT NULL
• DEFAULT
• CHECK

Querying Data (SELECT Statements)

• SELECT Statement Syntax and Execution Flow
• Filtering Data with WHERE
• Sorting Data using ORDER BY
• Removing Duplicates with DISTINCT
• Using TOP Clause
• Operators in SQL Server:

• Arithmetic, Comparison, Logical, BETWEEN, IN, LIKE, etc.

DML and DDL Commands

• DML:

• INSERT, UPDATE, DELETE
• Copying Data Between Tables

• DDL:

• CREATE, ALTER, DROP, TRUNCATE
• DELETE vs TRUNCATE (Differences and Use Cases)

SQL Server Built-in Functions

Scalar Functions:

• String Functions (LEN, SUBSTRING, REPLACE, etc.)
• Date Functions (GETDATE, EOMONTH, DATEFROMPARTS, etc.)
• Mathematical Functions (ROUND, FLOOR, CEILING)
• Conversion Functions (CAST, CONVERT)
• Logical/Conditional Functions (COALESCE, ISNULL, IIF)
• Ranking & Row Functions (ROW_NUMBER, RANK, DENSE_RANK)
• Running Total (Using Window Functions)

Group (Aggregate) Functions:

• COUNT(), SUM(), AVG(), MAX(), MIN()
• Deterministic vs Non-Deterministic Functions

Advanced Queries

• SET Operators: UNION, INTERSECT, EXCEPT
• Subqueries:

• Single-row and Multi-row Subqueries
• Correlated vs Non-correlated
• Nested Queries and Derived Tables

JOINS in SQL Server

• Importance of Joins
• Types of Joins:

• INNER JOIN
• LEFT, RIGHT OUTER JOIN
• FULL OUTER JOIN
• SELF JOIN
• CROSS JOIN

• Advanced Join Use Cases

Transactions and Locking

• Understanding Transactions
• COMMIT and ROLLBACK Statements
• ACID Properties
• Locks in SQL Server:
  • Shared, Exclusive, Update Locks
• Viewing and Resolving Deadlocks

Database Security

• Database Security Concepts
• Privileges and Permissions
• GRANT, REVOKE Statements
• User Management and Roles

Temporary Tables

• Creating Local and Global Temporary Tables
• Scope and Lifetime of Temp Tables

Views

• Introduction to Views
• Simple and Complex Views
• Updating Data via Views
• Advantages and Limitations of Views

Indexes

• Introduction to Indexing
• Clustered vs Non-Clustered Index
• Creating and Managing Indexes
• Index Performance Considerations

Stored Procedures

• Creating and Executing Stored Procedures
• Parameters and Return Values
• Benefits and Best Practices

Triggers

• Introduction to Triggers
• AFTER and INSTEAD OF Triggers
• Use Cases and Limitations

Cursors and Schemas

• Introduction to Cursors
• Cursor Lifecycle: DECLARE, OPEN, FETCH, CLOSE, DEALLOCATE
• Using Schemas for Data Organization

SQL Server Agent

• Automating Tasks with SQL Server Agent
• Creating Jobs and Schedules
• Alerts and Notifications

Advanced SQL Server Concepts

• Common Table Expressions (CTEs)
• Data Import/Export

Backup and Restore

• Importance of Backup Strategies
• Types of Backups: Full, Differential, Transaction Log
• Restoring Databases using SSMS and T-SQL