Click to get Online Subscription
Note: New added/updated video will not be available in DVD. Those videos need to be downloaded from online subscription.
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){NEW ADDED}
  • 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.{NEW ADDED}
  • 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?
  • 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 AngularJS Step by Step in 8 Hours
  • Lab 1:- $scope, $rootscope, controller, models, expression & debugging.
  • Lab 2: - Digest Cycle, Watchers, One time, $watch and $apply.
  • Lab 3: - Services and Factory.
  • Lab 4: - Using $http service with WebAPI as back end.
  • Lab 5: - Custom Directives, Restrict and Isolation Scope.
  • Lab 6: - Deferred and Promises.
  • Lab 7 :- Angular Unit Testing using Jasmine.
  • Lab 8 :- Implementing SPA using Angular Route and Angular UI Router.
  • Lab 9 :- Emit, BroadCast and On Events.
  • Lab 10 :- Filters in Angular.
  • Lab 11 :- JQuery with AngularJS.
  • Lab 12 :- Dot Rule and Controller AS Keyword.{NEW ADDED}
  • Lab 13:- Angular Provider (Constant, Values, Provider, Service and Decorator).{NEW ADDED}
  • 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.{NEW ADDED}
  • Lab 5 :- Integrating MVC with SharePoint (Part 1).{NEW ADDED}
  • Lab 6 :- Integrating MVC with SharePoint - Part 2 (Consuming List).{NEW ADDED}
  • Lab 7 :- Integration with MVC(SharePoint Hosted Model, CSOM and JSOM).{NEW ADDED}
  • 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?
  • jQuery, JSON & Javascript Frameworks Q/A series
  • JavaScript Training for C# developers - Part 1
  • JavaScript Training for C# developers - Part 2 ( OOP in JavaScript).
  • 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 ?
  • Lab 7: - Explain Angular JS with an example?
  • Lab 8: - Explain 2-way bindings and $scope?
  • Lab 9: - Explain unobtrusive javascript?
  • Lab 10: - Explain $http service and CORS in Angular(Angular)?
  • Lab 11 :- What is Less.JS(Less)?
  • Lab 12 :- Explain Mixin in LESS(Less)?
  • Lab 13: - Explain unobtrusive javascript?
  • .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.{NEW ADDED}
  • 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.{NEW ADDED}
  • How can we make Asynchronous method calls using delegates?{NEW ADDED}
  • 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()?(NEW ADDED)
  • When should we override GetHashCode?(NEW ADDED)
  • 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.{NEW ADDED}
  • What is .NET Core, DNX, DNU and DNVM?{NEW ADDED}
  • How to work with files and folders (System.IO)?{NEW ADDED}
  • Explain C# Exceptions?{NEW ADDED}
  • 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?
  • 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?
  • 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?
  • 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.
  • 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?
  • Learn Javascript Frameworks
  • NodeJS and NPM.{NEW ADDED}
  • Learn TypeScript in 45 Minutes{NEW ADDED}
  • Shims, Polyfills and Core-js.{NEW ADDED}
  • What is Zone.js?{NEW ADDED}
  • What is Reflect-Metadata?{NEW ADDED}
  • 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).{NEW ADDED}
  • 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)?
  • SQL Server Q & A section
  • Can you explain First, Second & Third Normal forms in database?
  • What is Denormalization, OLTP and OLAP?
  • Explain Star Schema & Snow Flake Design?
  • How does SQL Server store data in 8 KB page?
  • State 4 different types of SQL join?
  • What are wild card operators?
  • Explain Union & Union All?
  • What is aggregate functions, group by clause, having keyword?
  • What are subqueries & co-related queries?
  • What are Indexes and how does it increase performance?
  • How indexes affect insert, update and delete performance (page split)?
  • What is the difference between Clustered and Non-Clustered Indexes?
  • What are triggers, inserted tables and deleted tables?
  • Can you explain instead of and after triggers with a example?
  • What are stored procedures and why do we need them?
  • What is use of ISNULL and Coalesce functions?
  • What is Row_Number, Partition, Rank and DenseRank?
  • What is CDC (Change data capture)?
  • What is the difference between unique key and primary key?
  • How can we implement Pivot & Unpivot in SQL Server?
  • Explain the need of SQL Server Agent.{NEW ADDED}
  • 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?
  • 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
  •