Learn MVC 5 in 2 days
Lab 1: - Simple Hello world (20 Minutes)
Lab 2: - Explain MVC Routing (10 Minutes)?
Lab 3: - Explain ViewData, ViewBag, TempData & Session Variables?(20 Minutes)
Lab 4: - Explain Model and Strongly typed views(20 minutes)?
Lab 5: - Explain Model Binders(10 minutes)?
Lab 6: - Why MVC and MVC vs Webforms?(30 minutes)
Lab 7: - Explain TempData, Peek and Keep?(10 Minutes)
Lab 8: - Explain Data Annotations and HTML Helpers classes?(31 Minutes)
Lab 9: - What is the need of ViewModel in MVC?(10 Minutes)
Lab 10: - How can we use Entity Framework in MVC?(20 Minutes)
Lab 11: - How to implement viewmodel, partial view and webgrid?(45 minutes)
Lab 12: - What is the difference between ActionResult and ViewResult in MVC?(10 minutes)
Lab 13: - How to implement Ajax using JSON and Jquery using MVC?(60 minutes)
Lab 14: - What is the use of Async Controllers in MVC?(20 minutes)
Lab 15: - How to deploy MVC Application on IIS?(10 minutes)
Lab 16: - How can we do Windows and Forms Authentication in MVC?(50 Minutes)
Lab 17: - How can we use MVC areas for better modular development?(10 Minutes)
Lab 18: - How to implement MVC with Angular?(60 minutes)?
Lab 19: - Can we Overload MVC Action methods?(10 Minutes)?
Lab 20: - How to improve Reusability using Angular?(20 Minutes)?
Lab 21: - What is the need of WebAPI in MVC?(30 Minutes)
Lab 22: - How to do exception handling in MVC? (30 Minutes)
Lab 23: - How to do update & delete using MVC, WebAPI, EF & Angular?(30 Minutes)
Lab 24: - How to use MVC Webgrid?(30 minutes)
Lab 25: - How to implement Validation using Angular and MVC?(30 minutes)
Lab 26: - What is SPA (Single Page Application)?(30 minutes)
Lab 27: - How to Organize MVC project and Understanding CORS issue?(42 minutes)
Lab 28: - Explain the importance of DisplayModes?
Lab 29: - How to do unit testing with MVC projects?
Lab 30: - How to implement SPA using Angular Routing?
Lab 31: - How to create decoupled systems using MVC DI?
Lab 32: - How can we have multiple submit buttons in ASP.NET MVC?
Lab 33: - What is the importance of AntiForgery in MVC?
Lab 34: - What is the importance of ValidateInput and AllowHTML in MVC?
Lab 35: - Bundling and Minification.
Lab 36: - Layout pages in Razor.
Lab 37: - What are ActionFilters in MVC?
Lab 38: - What is WebAPI (Theory)?
Lab 39: - How can we create and consume WEB API(Practical)?
Lab 40 :- MVC 6/ASP.NET Core Training-Part 1 (2 Hours)
Learn Design Pattern in 8 Hours
Lab 1: - Design pattern step by step with a project(Factory pattern,Lazy Pattern and RIP Pattern).(60 minutes)
Lab 2: - Unity, Stratergy, IOC, SRP and SOC.(30 minutes)
Lab 3: - Template pattern and Repository pattern with ADO.NET.(60 minutes)
Lab 4: - Adapter Pattern and Repository with EF(60 minutes)
Lab 5: - UOW(Unit of Work)(30 minutes)
Lab 6: - Decorator Pattern(30 Minutes)
Lab 7: - Iterator Pattern(25 Minutes)
Lab 8:- Prototype and Memento Pattern(25 Minutes)
Lab 9:- Implementing complex object creation using Factory Method(1 Hour)
Lab 10 :- Implementing NULL Design pattern and Mediator pattern.
Explain SOLID?
Introduction
Factory Pattern
Abstract Factory Pattern
Builder Pattern
Prototype Pattern
Singleton Pattern
Adapter Pattern
Bridge Pattern
Composite Pattern
Decorator Pattern
Facade Pattern
Flyweight Pattern
Proxy Pattern
Mediator Pattern
Memento Pattern
Interpreter Pattern
Iterator Pattern
COR Pattern
Command Pattern
State Pattern
Strategy Pattern
Observer Pattern
Template Pattern
Visitor Pattern
Explain IOC(Inversion of control)?
DI IOC Pattern
Fluent interface and method chaining
Lazy Loading
Explain RIP(Replace IF with Polymorphism) Pattern?
Immutable object design pattern
Explain Null Design Pattern and its usage.
ASP.NET Q and A series
What is the use of Session and Viewstate in ASP.NET?
What is the difference between session & viewstate?
Can you explain ASP.NET application and Page life cycle - (Part 1)?
Can you explain ASP.NET application and Page life cycle - (Part 2)?
Can you explain ASP.NET application and Page life cycle - (Part-3)?
What is a PostBack, IsPostBack and AutoPostBack in ASP.NET?
What is Authentication, Authorization, Principal & Identity objects? Part-1
ASP.NET Authentiication and Authorization Video series Part-2
ASP.NET Authentiication and Authorization Video series Part-3
ASP.NET Authentiication and Authorization Video series Part-4
ASP.NET Authentiication and Authorization Video series Part-5
ASP.NET Authentiication and Authorization Video series Part-6
What are Master pages?
What is Instrumentation, Debugging & Tracing? Part-1
What is Instrumentation, Debugging & Tracing? Part-2
What is Instrumentation, Debugging & Tracing?Part-3
What is Routing in ASP.NET(URL rewriting)?
Server.Transfer VS Response.Redirect
Explain PreserveForm and EndResponse?
Can we have 2 web.config files?
What is Web server and IIS(Internet Information Services)?
Unit Testing & Load Testing Q & A
What is Unit Testing & can we see an example of the same?
How can we write data driven test using NUNIT & VS Test?
Can we see simple example of a unit test for database operation?
How can we do automated testing using Visual Studio Test?
How can we do Load Testing using VSTS test?
Can you explain database unit testing?
How can we do test coverage using VSTS system?
How can we do manual Testing using VSTS?
What is Ordered Test in VSTS test?
How to generate test data?
What are different test in VSTS 2010 and how to write unit test in VSTS 2010?
How to do UI automation testing using VSTS 2010 coded UI test?
How to run coded UI test with dynamic data using VSTS 2010?
How can we do web testing on ASP.NET application using VSTS 2010?
How to use WaitCommands in Coded UI test?
How to do Load test & database test using VSTS 2010?
In what scenarios do we use ordered testing in VSTS 2010?
How to implement TDD(Test Driven Development) in C#?
What is Mock Testing?
How to
UNIT test Private methods in VSTS test?
How can we do complex unit testing (Code contracts)?
Explain CodeLens?
Understanding Software Architecture with real time project examples
Scenario 1: - Customer & Logger class Scenario (SRP Violation)
Solution for Scenario 1: - Implementing SRP with factory class & interfaces
Scenario 2: - Add new customer type scenario (OCP violation)
Solution for Scenario 2: - Applying OCP (Open closed principle) by using inheritance
Scenario 3: - The batch printing problem(LSP violation)
Solution for Scenario 3: - Applying LSP (Liskov principle) using interfaces & solving the problem
Scenario 4: - The tax calculator scenario(DI/IOC)
Solution for Scenario 4: - Using unity application using DIIOC
.NET Best Practice Series
What are performancecounter and perfmon tool?
Finding high memory consuming functions - Part I
Finding high memory consuming functions - Part II
Improve garbage collector performance using finalize/dispose pattern
How to use performance counters to gather performance data - Part 1
How to use performance counters to gather performance data - Part 2
C# Threading Q & A Videos
What is Threading in C#.NET?
How can we make a object thread safe using LOCK in multithreading?
What is Mutex, Semaphore & SemaphoreSlim?
What is AutoResetEvent and ManualResetEvent?
What is Thread Pooling?
How to debug Threads?
What is TPL (Task Parallel Library) and how different it is from threads?
ADO.NET Q & A section
What is ADO.NET, Connection, Command & Datareader objects?
What is Dataset and DataAdapter in ADO.NET?
What is ADO.NET Connection Pooling?
Visual Studio Tips & Tricks
Visual Studio Tips & Tricks No. - 1
Visual Studio Tips & Tricks No. - 2
Visual Studio Tips & Tricks No. - 3
Visual Studio Tips & Tricks No. - 4
Visual Studio Tips & Tricks No. - 5
Visual Studio Tips & Tricks No. - 6
Visual Studio Tips & Tricks No. - 7
Visual Studio Tips & Tricks No. - 8
Visual Studio Tips & Tricks No. - 9
Visual Studio Tips & Tricks No. - 10
Visual Studio Tips & Tricks No. - 11
Visual Studio Tips & Tricks No. - 12
Visual Studio Tips & Tricks No. - 13
Visual Studio Tips & Tricks No. - 14
Visual Studio Tips & Tricks No. - 15
Visual Studio Tips & Tricks No. - 16
Visual Studio Tips & tricks No. - 17 (Remove Unused Namespaces)
Visual Studio Tips & Tricks No. - 18
Visual Studio Tips & Tricks No. - 19
Visual Studio Tips & Tricks No. - 20
Visual studio Tips & Tricks No. - 21: - (Show external files in Visual studio)
Visual studio Tips & Tricks No. - 22: - Refresh all browsers from Visual studio
Visual studio Tips & Tricks No. - 23: - (Peek Definition)
Visual studio Tips & Tricks No. - 24: - (Autos Window)
Visual studio Tips & Tricks No. - 25: - What is need of [DebuggerStep Through]?
LINQ Questions and Answers
What is LINQ and can you explain same with example?Can you explain a simple example of LINQ to SQL?
How can we define relationships using LINQ to SQL?How can we optimize LINQ relationships queries using ‘DataLoadOptions’?
Can we see a simple example of how we can do CRUD using LINQ to SQL?
How can we call a stored procedure using LINQ?
SQL Performance Tuning
Basics: - Query plan,
Logical operators and Logical reads
Point 1: -
Unique keys improve table scan performance.
Point 2: - Choose Table
scan for small & Seek scan for large records
Point 3: - Use Covering
index to reduce RID (Row Identifier) lookup
Point4: - Keep index
size as small as possible.
Point5: - use
numeric as compared to text data type.
Point6: - use
indexed view for aggregated SQL Queries
Point7: - Database Engine tuning advisor is your best friend.
Absolute Freshers
What are High level
and low level languages?
How to install .NET
framework and write a hello world program ?
From where do i get
visual studio?
How write a simple
hello world program using visual studio?
Localization/Globalization Q & A
What is Globalization and Localization? - Part 1
How can we set explicit culture? - Part 2
What is the difference between Culture and UI Culture? - Part 3
How to store localized data in SQL Server? - Part 4
Learn Angular 1.X, 2.X and 4.X
(Angular 2.X and 4.X) Lab 1: - Modules,Components, ng-model & expressions (1 hr)
(Angular 2.X and 4.X) How to open Angular 2 Source code
(Angular 2.X and 4.X) Lab 2: - 1-way/2-way binding, interpolations, template binding, event binding & cloning.
(Angular 2.X and 4.X) Lab 3: - @Input, @Output & Eventemitters.
(Angular 2.X and 4.X) Lab 4: - Angular Component Life Cycle.
(Angular 2.X and 4.X) Lab 5: - Providers, Services and Dependency Injection.
(Angular 2.X and 4.X) Lab 6: - SPA(Single Page Application) using Routing.
(Angular 2.X and 4.X) Lab 7: - Validation using Angular forms.
(Angular 2.X and 4.X) Lab 8:- Making HTTP POST calls to REST service (WebAPI) using Angular 2.
(Angular 2.X and 4.X) Lab 9: - Lazy loading using Angular 2.
(Angular 2.X and 4.X) Lab 10: - Use WebPack for Angular 2 application.
(Angular 2.X and 4.X) Lab 11: - Use VS Code Editor.
(Angular 2.X and 4.X) Lab 12: - Migration Angular 2.X to Angular 4.X.
(Angular 2.X and 4.X) Lab 13: - Auxiliary router outlet / Named router outlet.
(Angular 2.X and 4.X)Lab 14: - PathLocation & HashLocation Strategy.
(Angular 2.X and 4.X)Lab 15 :- Using JQuery in Angular 2/4.{NEW ADDED}
(Angular 2.X and 4.X)Lab 16: - Pipes in Angular 2/4.{NEW ADDED}
(Angular 1.X) Lab 1: - $scope, $rootscope, controller, models, expression & debugging.
(Angular 1.X) Lab 2: - Digest Cycle, Watchers, One time, $watch and $apply.
(Angular 1.X) Lab 3: - Services and Factory.
(Angular 1.X) Lab 4: - Using $http service with WebAPI as back end.
(Angular 1.X) Lab 5: - Custom Directives, Restrict and Isolation Scope.
(Angular 1.X) Lab 6: - Deferred and Promises.
(Angular 1.X) Lab 7: - Angular Unit Testing using Jasmine.
(Angular 1.X) Lab 8: - Implementing SPA using Angular Route and Angular UI Router.
(Angular 1.X) Lab 9: - Emit, BroadCast and On Events.
(Angular 1.X) Lab 10: - Filters in Angular.
(Angular 1.X) Lab 11: - JQuery with AngularJS.
(Angular 1.X) Lab 12: - Dot Rule and Controller AS Keyword.
(Angular 1.X) Lab 13: - Angular Provider (Constant, Values, Provider, Service and Decorator).
Learn C# Step by Step
Lab 1: - C# fundamentals, For loop, data types, Error handling, classes/objects, Methods and functions.
Lab 2: - Synch, Asynch, Delegates, Multicast Delegates and Events.
Lab 3: - Simple File Search Project.
Lab 4: - Customer Project(2 layers and validations).
Lab 5: - Inserting customer data using ADO.NET.
Lab 6: - Display, Update and Delete.
Lab 7: - Reusability and Configuration.
Using SQL script files.
Lab 8: - Implementing the Product master table.
Lab 9: - Implementing Stored Procedures.
Lab 10: - In-memory inserts and update.
Lab 11: - In-memory Deletes & understanding Usability.
Learn SharePoint Step by Step in 8 Hours
Lab 1 :- Basics, Sitecollection, Subsite, Page, List and Document Library.
Lab 2 :- User, User group and Permissions.
Lab 3 :- Master Page Customization in SharePoint.
Lab 4 :- Site Columns and Content Types.
Lab 5 :- Integrating MVC with SharePoint (Part 1).
Lab 6 :- Integrating MVC with SharePoint - Part 2 (Consuming List).
Lab 7 :- Integration with MVC(SharePoint Hosted Model, CSOM and JSOM).
WPF Questions and Answers
Lab 1: - What is WPF and how it is better than Winforms?
Theory: - Explain WPF object hierarchy?
Lab 2: - How to implement threading in WPF?
Lab 3: - Explain one way, two way, one time & one way to source bindings?
Lab 4: - Explain UpdateSourceTrigger in WPF?
Lab 5: - Explain WPF Resources?
Lab 6: - What are WPF Value Converters?
Lab 7: - Explain WPF multibindings and multivalueconverters?
Lab 8: - Explain logical tree, visual tree,routed events( Direct, Tunneling and Bubbling)?
Lab 9: - What are WPF commands and INotifyPropertyChange interface?
Lab 10: - Explain MVVM with a simple example(With binding)?
Lab 11: - What is the need of INotifyPropertyChanged interface in MVVM?(MVVM With INotify)
Lab 12: - Explain importance of commands in MVVM(MVVM with Commands)?
Lab 13: - How to decouple commands from view model(MVVM reusable commands)?
Lab 14: - How to refresh MVVM commands?
Learn jQuery Step by Step
Lab 1: - Explain Jquery with a simple example?
Lab 2: - Explain CDN Fallback?
Lab 3: - Explain Document.Ready in jQuery?
Lab 4: - What are the 7 important ways of doing selection in jQuery?
Lab 5:- Explain JSON ?
Lab 6: - How to emit JSON using MVC ?
.NET Fundamentals Q & A
What is IL code, CLR, CLS & JIT? - Part1
What is IL code, CLR, CLS & JIT? - Part2
Explain JIT,Pre-jit,Eco-Jit,Normal-Jit and NGEN.EXE?
What is CAS, evidence, permission set & code groups?
What are the changes in .NET 4.0 security model & What is sandboxing?
Explain Assembly, EXE and DLL.
Explain App Domain?
What is the difference between managed & unmanaged code?
What is Garbage Collector, Gen 0, 1 & 2?
What is IDisposable interface & finalize dispose pattern in GC?
What is the difference between strong and weak references?
What is delay signing?
Can we see simple example of GAC & How to handle multiple versions in GAC?
What are different .NET datatypes and its uses according to scenarios?
Explain TypeSafe,Casting,Explicit casting and implicit casting?
Explain the sentence "C# strings are immutable"?(Also covers stringbuilder & interning)
Explain Synch, Asynch, Delegates, Multicast Delegates and Events.
How can we make Asynchronous method calls using delegates?
What are anonymous methods in C#?
Why anonymous types are preferred over Tuples?
What is the use of Lambda Expression Action<>, Predicate<> & Func<>?
What do you mean by Covariance & Contravariance in .NET 4.0?
What is the use of checked and unchecked keyword?
What is a stack, Heap, Value types and Reference types?
What is boxing and unboxing?
C# Out Vs Ref
What is optimistic and pessimistic locking? - Part1
Can you explain optimistic locking? - Part2
Can you explain pessimistic locking? - Part3
What are regular expressions & can we see some practical demonstrations?
Why do we need Regex timeout(.NET 4.5 feature)?
5 tips to improve your C# debugging.
Can you explain Named Parameters, Ref, Out, Volatile & Parsetry?
What is the difference between Const & ReadOnly?
Explain the difference between "IS" and "AS" keyword?
What are Extension Methods?
What is #Debug directive?
What is the difference between Debug and Release?
What is serialization and deserialization?
What is the difference between TypeOf and GetType?
What is IComparable and IComparer?
What is the use of Yield Keyword in C#?
What is a C# indexer?
What is the difference between == vs .Equals()?
When should we override GetHashCode?
What are ??(Coalescing operators)?
What is C# reflection?
What is Dynamic keyword & How does it differ from Reflection?
What is the difference between Early binding and Late binding?
What is a difference between VAR and Dynamic keyword?
What is the use of VAR keyword in C#?
What are Circular Dependencies and How to resolve them?
How can we mark a method as deprecated?
What is the difference between Build Vs Rebuild Vs Clean?
What is Naming Convention?
What is Nuget?
What are portable class libraries?
What is Asynch and Await keywords?
What are ENUM's and flags in ENUMS?
How to convert string to ENUM ?
How to use MSMQ with C#?
Explain NULLABLE Types?
Explain C# Attributes?
What is Automapper?
What are DataAnnotations?
C# Random numbers.
What is .NET Core, DNX, DNU and DNVM?
How to work with files and folders (System.IO)?
Explain C# Exceptions?
Generics/.NET collections Q & A
What are the different types of collections in .NET?- Part 1
What is the difference between Array & ArrayList?- Part 2
Can you prove why arrays are faster than arraylist?- Part 3
What are the problems with arraylist & how can we solve the same by Hashtables?- Part 4
What are stacks & queues?- Part 5
What are special collections?- Part 6
What are Generics & What are generics collections?- Part 7
What are generics collections?- Part 8
What is the use of IEnumerator, ICollection, IDictionary & IList?- Part 9
What is the difference between IEnumerable and IEnumerator?
Differentiate between IEnumerable vs IQueryable?
Explain Generics Constraints?
Learn .NET in 60 days
(Day 1)Lab 1: - Creating your first program
(Day 1)Lab 2: - Creating your first program
(Day 1)Lab 3: - Integer DataType
(Day 1)Lab 4: - Exception Handling
(Day 1)Lab 5: - IF Condition, Return Try/Catch
(Day 2)Lab 6: - Commenting
(Day 2)Lab 7: - For Loop
(Day 2)Lab 8: - Creating a simple calculator program
(Day 3)Lab 9: - Creating your first Windows application
(Day 3)Lab 10: - Creating the Customer Screen
(Day 4)Lab 11: - Displaying Customer Screen
(Day 4)Lab 12: - Multiple Document Interface(MDI)
(Day 5)Lab 13: - Classes & Objects
(Day 6)Lab 14: - Getting Data from SQL Server
(Day 7)Lab 15: - Inserting data into SQL Server
(Day 7) Lab 16: - Storing connection string in App.config files
(Day 8) Lab 17: - Delete Functionality
(Day 9) Lab 18: - Update Functionality
(Day 9) Lab 19: - 2 Tier Architecture
(Day 10) Lab 20: - Creating a web application
(Day 10) Lab 21: - Connect WebApp to Data Access Layer
(Day 11 & 12) Lab 22: - Implementing Insert, Update & Delete
(Day 13) Lab 23: - Implementing 3 Tier Architecture
(Day 14) Lab 24: - Security
(Day 15) Lab 25: - Web Security
(Day 16) Lab 26: - REGEX
(Day 17) Lab 27: - Improving Database Design
(Day 18)Lab 28: - 1 to many relationship
(Day 19)Lab 29: - 1 to Many(Insert)
(Day 20)Lab 30: - 1 to Many(Select & Delete)
(Day 21)Lab 31: - 1 to Many(Update)
(Day 22)Lab 32: - Stored Procedure
(Day 23)Lab 33: - Reusability
(Day 24)Lab 34: - Application and Cache in ASP.NET
(Day 25)Lab 35: - Sessions in ASP.NET
Day 26 to Day 60: - Project
WCF Question and Answers
What is SOA, Services and Messages (Part 1)?
What is SOA, Services and Messages (Part 2)?
What is the difference between Service and Component?
What are basic steps to create a WCF service (Part I, Creating the Service)?
What are basic steps to create a WCF service (Part II, Consuming the Service)?
What are endpoints, address, contracts and bindings?
What are various ways of hosting WCF service? What is the difference of hosting a WCF service on IIS and Self hosting?
What is the difference between BasicHttpBinding and WsHttpBinding?
How can we do debugging and tracing in WCF?
Can you explain transactions in WCF (theory)?
Can we see a simple sample of WCF transactions?
How can we self host WCF
services ?
What are the different
ways of implementing WCF Security?
How
can we implement SSL security on WCF(Transport Security)?
How can we implement
transport security plus message security in WCF ?
How can we do WCF instancing ?
How Can we do WCF Concurency
and throttling?
Can you explain one way & duplex(two way) contract in WCF?
Can you explain one way & duplex(two way) contract in WCF?- Part 2
What exactly is WCF REST service?
What exactly is WCF REST service?-Part 2
What are WCF fault exception?
How to host Multiple endpoint in a single WCF Service?
What is netMSMQBinding in WCF?
Programming Algorithm Q & A
How to write FizzBuzz logic in C#?
EvenOddlogic
Interview Q & A videos
In a parent child relationship which constructor fires first?
What is the difference between i++ & ++i?
Learn Xamarin in 8 hours
Lesson 1:- Xamarin Basic{NEW ADDED}
Lesson 2: - Activity, Resources and Assets.{NEW ADDED}
Lesson 3: - Xamarin Android Activity life cycle.{NEW ADDED}
Lesson 4: - Dialog boxes and Intents in Xamarin.{NEW ADDED}
Learn JavaScript Step by Step
Lab 1 :- Data Types & Scoping.
Lab 2 :- Literal and Constructor function objects in JavaScript.
Lab 3 :- Prototypical Language and Prototypical Inheritance.
Lab 4 :- JavaScript Closures.
Lab 5: - Explain IIFE(Immediately Invoked Function Expression).
Lab 6 :- NodeJS and NPM.
Lab 7 :- Module Loaders, CommonJS & SystemJS.
Lab 8 :- TypeScript in 45 Minutes.
Lab 9 :- WebPack
Shims, Polyfills and Core-js.
What is Zone.js?
What is Reflect-Metadata?
Understanding CommonJS Module specification.
Learn Visual Studio Code in 10 Simple Steps.
JavaScript Training for C# developers - Part 1
JavaScript Training for C# developer Part 2 ( OOP in JavaScript).
What is Less.JS ( Less) ?
Explain Mixin in LESS ( Less) ?
Explain unobtrusive javascript?
Learn MSBI in 4 days with Project
Lab 1: - MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house(60 minutes)
Lab 2: - Conditional split, Data conversion and Error handling(30 minutes)
Lab 3: - For Loop, Variables, Parameters and Debugging(30 minutes)
Lab 4: - Packaging and Deployment, File component and running SSIS package as a task.(35 minutes)
Lab 5: - For dimension, measures, star schema, snow flake, shared connection managers & packages tasks.(30 minutes)
Lab 6: - SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(45 minutes)
Lab 7: - Lookup, Data conversion optimization and updating SSIS package.(40 minutes)
Lab 8: - Sort, Merge and Merge Joins.(21 minutes)
Lab 9: - Creating SSAS Cube(30 Minutes)
Lab 10: - SSAS Time series and Excel display(30 Minutes)
Lab 11: - What are Transactions and CheckPoints in SSIS?(30 Minutes)
Lab 12: - Simple SSRS report & implementing Matrix, Tabular, Parameters, Sorting, Expressions(60 Minutes)
Lab 13: - Using Data Profiling task to check data quality(20 Minutes)
Lab 14: - Hierarchical Dimensions(30 Minutes)
Lab 15: - WebServices and XML Task(15 Minutes)
Lab 16: - DrillDown and Subreports(20 Minutes)
Lab 17: - SSAS KPI(Key Performance Indicators)(15 Minutes)
Lab 18: - Pivot, UnPivot and Aggregation(20 Minutes)
Lab 19: - SSAS Calculation.(30 Minutes)
Lab 20: - SQL Execute Task (30 Minutes)
Lab 21: - Reference and Many-to-Many Relationship(30 Minutes)
Lab 22: - Script Task and Send Mail Task(15 Minutes)
Lab 23: - Script component(SSIS)(45 Minutes)
Lab 24: - Bar chart, Gauge and Indicators(20 Minutes)
Lab 25: - Partitions in SSAS (30 Minutes)
Lab 26: - CDC(Changed Data Capture) in SSIS(35 Minutes)
Lab 27: - Additive, Semiadditive and non-additive measures in SSAS(15 Minutes)
Lab 28: - Buffer Size Tuning (SSIS)
Lab 29: - How to implement Multithreading in SSIS?
Lab 30: - Processing SSAS cube in background.
Lab 31: - Explain Asynchronous, Synchronous, Full blocking, Semi-blocking and Non-blocking SSIS Components.
Lab 32: - SSRS Architecture and Deployment.
Lab 33: - DQS(Data Quality Services).
Lab 34: - Explain Tabular Model and Power Pivot (SSAS).
Lab 35: - MDX (Multidimensional Expressions) Queries.
Lab 36: - Data Mining (Fundamentals and Time Series Algorithm).
Lab 37: - Page Split and Performance issues with SSIS.
Lab 38: - Aggregations in SSAS.
Lab 39 :- ROLAP, MOLAP and HOLAP.
Lab 40 :- Instrumentation using Data Taps (SSIS).
SharePoint 2010 Q & A videos
What is SharePoint, SharePoint foundation & SharePoint server 2010?How to create a simple website in SharePoint? - Part 1
How to create a simple website in SharePoint? - Part 2
How can we create users and permissions in SharePoint 2010?
How to deploy custom webparts in SharePoint pages?
How do we customize SharePoint pages using SharePoint designer?
How can we debug SharePoint errors?
Can you explain (SOM)SharePoint Object Model?
How can we create custom ASP.NET screen to insert & display operations on SharePoint list?
What is the use of INFOPATH?
How to read and write data to SharePoint 2010 from remote locations?
What is the use of Business Connectivity Services(BCS)?
BizTalk Q & A series
What is BizTalk and when to use Biz Talk?
What are Adapters, Pipeline, Maps and Ports?
Can you explain the Biztalk environment?
How to create a schema in BizTalk?
How to create a map in Biztalk?
How can we create orchestration in Biztalk?
How can we build/publish in Biztalk?
How to do configuration in Biztalk?
How to execute and Test?
OOP's Q & A Video series
What is the problem with Functional Programming?
Can you define OOP and the 4 principles of OOP?
What are Classes and Objects?
What is Inheritance?
What is Polymorphism, overloading, overriding and virtual?
Can you explain encapsulation and abstraction?
What is an abstract class?
Define Interface & What is the diff. between abstract & interface?
Define Interface & Diff. between abstract & interface? - Part 2
What is Shadowing?
Can we implement interfaces with same method names in C#?
What is the use of Static Keyword?
What is the difference between Abstraction and Encapsulation?
What are partial classes & partial methods?
Can we see implementation of Association, Aggregation & Composition in real world?
What is operator overloading?
Explain Access modifiers (Private, Public, Protected, Internal & Protected/Internal)?
Learn SQL Server Step by Step
Lab 1:- Basic Fundamentals Database, Tables, rows and columns.
Lab 2:- Primary key, foreign key, referential integrity and constraints.
Lab 3 :- First ,Second and Third Normal form design.
Lab 4 :- Denormalization, OLTP and OLAP
Lab 5 :- Understanding Star schema and Snow flake design.
Lab 6 :- SQL Server 8 kb pages.
Lab 7 :- Inner joins , left join and right join.
Lab 8 :- Wild card operators.
Lab 9 :- Union and Union all
Lab 10 :- Aggregate , group by and having keyword
Lab 11 :- Sub queries and co-related queries.
Lab 12 :- Index and performances
Lab 13 :- Page Split and indexes
Lab 14 :- Clustered vs non-clustered
Lab 15 :- Triggers , inserted and deleted tables
Lab 16 :- Instead of and after triggers.
Lab 17 :- Stored procedures and their importance.
Lab 18 :- ISNULL and Coalesce functions
Lab 19 :- Row_Number, Partition, Rank and DenseRank
Lab 20 :- Change Data Capture.
Lab 21 :- SQL Server agent.
Lab 22 :- Pivot and Unpivot.
LINQ/Entity Framework Q & A
What is Entity Framework (Theory)?
Lab 1: - What is EDMX, Context and Models in EF?
Lab 2: - How to read,insert, update
& delete data using EF (Entity framework)?
Lab 3: - How to insert custom business validation in Entity classes?
Lab 4: - What are POCO Classes?
Lab 5: - How to implement code first?
Lab 6: - How to solve concurrency issues in EF (Optimistic locking )?
Lab 7: - What is Clientwins and StoreWins in Entity framework?
UML
Introduction
Use Case Diagrams
Class Diagrams
Object Diagrams
Sequence Diagrams
Collaboration Diagrams
Activity Diagram
State chart Diagrams
Component Diagrams
Deployment Diagrams
Stereo Types Diagrams
UML Project Flow
Practice with Tool
Setup
Function Points
Introduction
Application Boundary
EI Fundamentals
EO Fundamentals
EQ Fundamentals
EIF Fundamentals
ILF Fundamentals
GSC Fundamentals
Productivity Factor
Costing
Function Point Template
Estimating a Sample Project
Function Point Estimation Excel
Customer Maintenance
.NET Project
Introduction to .NET Projects
Different levels of Programming
Necessary Tools
What should we learn?
The IIS
Making UI using .net IDE
Database, The SQL Server
Update and Delete
Validations
Issue with the Code
Two Tier Architecture
Three Tier Architecture
Database Normalization
Connecting ASP.net with Database
Session and State Management
Using Enterprise Application Blocks
Aggregation and Composition
Implementing Interfaces and Factory
Inheritance relationship
Abstract Class Implementation
Source Code
Understanding OOPS in real project
Interface
Abstract Classes
Abstraction and Encapsulation
Parent-Child relationship
Aggregation and Composition
Polymorphism
Differences: Interfaces & Abstract Classes
SDLC Video
SDLC
Estimation
Requirement Technical and Testing
SDLC Source Code
ASP.NET SignalR Q & A Videos
How to install SignalR & JSON2 on VS2010? Chat Application: - How to create and connect to HUB?
How to create a Server/Client Method and pass parameters?
How to create Chat application using SignalR?
Explain onconnected and ondisconnected methods of SignalR?
Explain Context, Clients & Groups properties of SignalR?
Explain Group/OthersInGroup of object Clients & show how to send messages to different Groups?
What is round triping state in SignalR?
How to broadcast a message from outside the HUB?
How to do performance tuning in ASP.NET SignalR?
How to develop a simple game in SignalR?
StyleCOP Video
StyleCOP Video
StyleCOP Source Code
StyleCOP Setup
FXCOP Video
FXCOP Video
FXCOP Source Code
FXCOP Setup
Tips and Tricks
How to consume Webservices in AJAX?
TFS Q & A series
What is TFS and explain its architecture?
How can we integrate software life cycle in TFS?
Model View Presenter
Model View Presenter Video
Interview Quick reference
Section1 - IL Code, JIT, CLR, CTS and CAS
AJAX Q & A videos
How to run certain activites on ASP.NET AJAX?
What is AJAX and explanation about the Client Side Technology?
What are the AJAX Server Side Technologies and AJAX Server Controls?
VS 2010 , ASP.NET 4.0 and .NET 4.0
What is Package and One click deploy(Deployment Part - 1) ?
What is Web.config transformation (Deployment Part-2)?
What is MEF and how can we implement the same?
How is MEF different from DIIOC?
Can you show us a simple implementation of MEF in Silverlight?
