Learn .net Fundamentals

Course Fee – 30k

v  .Net Basics

o   Lecture 1

§  .Net Framework

§  Assmbly (Difference between other assembly and .net assembly

§  Dll vs EXE

§  Manifest

§  Namespace vs Assemble

§  Compilation of .net Code , IL Code (Half compiled Code)

§  JIT

§  NGEN

§  .Net Architecture

§  CAS

o   Lecture 2

§  Dll Hell

§  Versioning

§  String Names, Weakly typed references and strongly typed references,

§  Private vs Shared Assembly

§  Gac Util

§  Delay signing

o   Lecture 3

§  Value types, Reference Types, Stack, Heap

§  Ref vs. Out

§  Boxing, Unboxing and performance

§  GC,GC Cycle

§  Managed vs. Unmanaged objects

§  Constructor and Destructors

§  Finalize dispose pattern

v  OOPS and C#

o   Lecture 4

§  Why do we need OOPS? (Reusability with classes)

·         What is mean building

·         Problems with Procedural programming

o   Confusions -> We had all functions together - No Separation

o   Data is not protected

o   Increase in size because of physical include

o   Too many functions with different names doing same kind operations

o   Difficulties in reusing Existing Files

§  Class and Object

§  Instance vs. static member

§  Static member, functions, constructors and classes

§  Access Modifiers

§  Encapsulation and how

§  Abstraction

§  Encapsulation vs. abstraction

o   Lecture 5

§  Constructors and Destructors

§  Types of constructors

§  Inheritance and its types

§  Constructors with Inheritance

§  Avoid inheritance

§  Polymorphism

§  Method overloading

§  Overriding

§  Shadowing

§  Static and dynamic polymorphism

o   Lecture 6

§  Interfaces What when and how(Talk about access modifiers in interface)

·         Decouple

·         Contracts

·         Multiple inheritance

·         Class inherits classes

·         classes implement interfaces

§  Abstract Classes What When and How(Talk about static methods)

§  Creating objects of Interfaces and Abstract Class

§  Implementing multiple interfaces

§  Partial Class

§  Partial Method

§  Abstract vs. Partial

o   Lecture 7

§  Delegates What When

§  Multi cast delegates

§  Asynchronous Delegates

§  Events vs. Delegates

§  Generics

§  Array vs. ArrayList vs. List

§  Regex and Validation

§  Satellite Assembly

o   Lecture 8

§  Threading –

·         What is threading? Parallel programming

·         Foreground thread(Will keep on running even main application quit),Background thread

·         Thread Priority,

·         Thread pooling,

·         TPL – Multi Core Utilization and Automatic thread pooling

§  Read-only vs. constant

§  Reflection

§  Serialization

o   Lecture 9

§  Indexer

§  Working with Linq to objects

v  Asp.net

o   Lecture 10

§  What is asp.net

§  Get vs Post

§  Asp.net web forms vs MVC

§  Asp.net Compilation

o   Lecture 11

§  Asp.net request processing

§  Asp.net life cycle

o   Lecture 12

§  Types of controls in Asp.net Web Forms

§  Explore some basic controls like button,Textbox Drop Down, GridView and Listbox

§  Working with Validations

§  Working with Css

o   Lecture 13 and Lecture 14

§  StateManagement  - View State,Hidden Fields, Cookies

§  StateManagement  - Session and Application

§  Caching

o   Lecture 15

§  Creating Custom and User Control using asp.net

§  Working with Master Pages

o   Lecture 16

§  What is Ajax

§  Working with Update Panel

§  What is script Manager

o   Lecture 17

§  Hosting in IIS

§  Working with 3 Tier applications

v  Javascript and jQuery

o   Lecture 18

§  Why Javascript

§  Basic Coding using javascript

§  How javascript is different from jQuery

§  jQuery Explore some functions

§  jQuery Selectors

§  jQuery Events

v  Sql Server

o   Lecture 19

§  What is Database, Tables, Rows and Columns

§  Database Server and Management Studio

§  Create Query and Drop Query

§  Add New Column, Drop One column

§  Alter Query – Add, Drop and sp_RENAME 

o   Lecture 20

§  Data types in sql server

§  What is Allow Null(Not Null)

§  Simple Sql Queries

·         Select

·         Insert

·         Update

§  Primary Key, Unique Key, Candidate Key, Alternate Key

§  Identity Column

§  Relationships

§  Composite Key Foreign key and

o   Lecture 21 - Tuesday

§  Where, In ,between

§  Wild Card Operator

§  Aggregate functions 
Sum, Avg, Count, Max, Min

§  Delete and Truncate

§  Top, Order by

§  Is Null vs. collaese

§  Union and Union all

o   Lecture 22 - Wednesday

§  Joins in SQL Server

·         Inner

·         Left ,Right, Full Outer

·         Cross

·         Self

·         Equi Join - An equijoin is a join with a join condition containing an equality operator

o   Lecture 23 - Friday

§  Group by, having

§  Sub Queries and correlated sub queries

o   Lecture 24

§  Indexes  

·         Select performance

·         Insert Delete and Update Performance

·         Clustered vs Non Clustered

§  Stored Procedure

o   Lecture 25

§  Functions – Scalar valued, Inline and Multistate

§  Returns vs Return

§  Stored procedure vs Function

§  Exists function and sys.objects and IF

§  Select * into

§  Table Variable and Temporary tables

o   Lecture 25

§  Triggers , Inserted and Deleted Tables  

§  Views

§  Views vs StoredProedures

o   Lecture 26

§  Normalization and De-normalization

§  ACID

§  SQL Transactions