Questpond Online Subscription

Complete Video Learning Library

Browse standard learning content and premium 5-year subscriber recordings in a structured, searchable library.

36Standard Sections
185-Year Premium
54Total Sections

Standard Learning Library

36 sections
  1. Real Time Interview Question
  2. Sample Resume of Senior Architect
  1. Performance improvement, state management, Routing, Mutable and Immutable objects ReactJS Part1.
  2. Memorization, ContextAPI, Redux ReactJS Part2.
  3. Redux implementation, Axios.
  1. 30 Important C# Interview Questions and Answers(Part 1)
  1. Basic ASP.NET MVC Interview Questions with answers Part 1
  2. Session management &cookies ASP.NET MVC Interview Questions & Answers Part 2
  3. ViewData,ViewBag & ViewModel ASP.NET MVC Interview Questions & Answers Part 3.
  4. Tempdata :- ASP.NET MVC Interview Questions & Answers Part 4.
  5. WebAPI and REST :- ASP.NET MVC Interview Questions with answers - Part 5
  6. ASP.NET MVC Interview Questions with answers E-Book.
  7. JWT Token, Principal, Claim, Roles, Refresh Token, OpenId, OAuth - Part 6.
  1. CQRS, SAGA, Outbox Pattern, Consistency and Resiliency Part 2 - 03-09-2026
  2. Why MicroServices, VS Monolith, Context Map, Bounded Context and Domains Part 1 - 27-08-2026
  1. Must and Basic Questions on SQL Server - Part 1
  2. Interview Questions around essential concepts of SQL Server - Part 2
  3. Important questions on SubQuery and Cor-related Queries in SQL - Part 3
  4. How to Find Nth Highest Salary ? - Part 4
  5. Covered Questions on finding Nth highest using co-related & TSQL - Part 5
  6. Questions around SQL Server CTE(Common Table Expression) - Part6
  7. Questions around Window functions, Rank, Dense_Rank and RowNumber - Part 7
  8. Questions around Delete Duplicate Records scenarios - Part 8
  9. SQL Interview Questions & Answers PDF.
  1. JavaScript basics Interview questions with answers.
  2. 7 Important JavaScript Questions on ES6 & JavaScript Functions.
  3. Technical Questions on Sync, Async, Threading, Event Loop, Blocking and Non-Blocking and Callback Queue.
  4. Tricky Questions on Promises, callbacks, Asynch, Await, Micro,Macro, Webworker.
  5. JavaScript Interview Questions & Answers PDF.
  6. Source Code
  1. 25 basics interview Q & A on Angular - Part 1
  2. Angular Interview Q & A - Part 2
  3. Angular interview Q & A - Part 3
  4. Angular interview Q & A - Part 4
  5. Angular interview Q & A - Part 5
  6. Angular interview questions - Part 6
  1. Lesson 1:- In this we will cover 25 Basic Architecture Interview questions with answers
  2. Lesson 2:-SOLID Principles Questions and Answers
  3. Lesson 3 :- Repository Pattern and UOW ( Unit of Work)
  4. Lesson 4:- Factory Pattern , Abstract Factory , DI , IOC , Service Locator
  5. Lesson 5 :- Factory and Abstract Factory pattern continued
  6. Architecture Interview Questions and Answers Book
  7. Architecture Interview Questions & Answers Source Code
  1. Lab 1: - Design pattern step by step with a project(Factory pattern,Lazy Pattern and RIP Pattern).(60 minutes)
  2. Lab 2: - Unity, Stratergy, IOC, SRP and SOC.(30 minutes)
  3. Lab 3: - Template pattern and Repository pattern with ADO.NET.(60 minutes)
  4. Lab 4: - Adapter Pattern and Repository with EF(60 minutes)
  5. Lab 5: - UOW(Unit of Work)(30 minutes)
  6. Lab 6: - Decorator Pattern(30 Minutes)
  7. Lab 7: - Iterator Pattern(25 Minutes)
  8. Lab 8:- Prototype and Memento Pattern(25 Minutes)
  9. Lab 9:- Implementing complex object creation using Factory Method(1 Hour)
  10. Lab 10 :- Implementing NULL Design pattern and Mediator pattern.
  11. Explain SOLID?
  12. Introduction
  13. Factory and Abstract Factory Pattern
  14. Builder Pattern
  15. Prototype Pattern
  16. Singleton Pattern
  17. Adapter Pattern
  18. Bridge Pattern
  19. Composite Pattern
  20. Decorator Pattern
  21. Facade Pattern
  22. Flyweight Pattern
  23. Proxy Pattern
  24. Mediator Pattern
  25. Memento Pattern
  26. Interpreter Pattern
  27. Iterator Pattern
  28. COR Pattern
  29. Command Pattern
  30. State Pattern
  31. Strategy Pattern
  32. Observer Pattern
  33. Template Pattern
  34. Visitor Pattern
  35. Explain IOC(Inversion of control)?
  36. DI IOC Pattern
  37. Fluent interface and method chaining
  38. Lazy Loading
  39. Explain RIP(Replace IF with Polymorphism) Pattern?
  40. Immutable object design pattern
  41. Explain Null Design Pattern and its usage.
  42. What is Microservices Architecture?
  1. Lab 1: - Running your first Angular Application.
  2. Lab 2: - Creating the Customer UI, Model and Component.
  3. Lab 3: - Angular Routing: Creating Master pages and navigations
  4. Lab 4: - Increasing Performance using Lazy Loading.
  5. Lab 5: - Implement Validations in Angular.
  6. Lab 6: - Angular Dependency Injection.
  7. Lab 7: - Input, output and event emitters.
  8. Lab 8: - Make HTTP calls using Angular Components.
  9. Lab 9: - Integrating MVC Core with Angular using Visual Studio.
  10. Lab 10: - Migratting Angular 6 to Angular 7
  11. Lab 11: - Unit Testing in Angular using Jasmine & Karma.
  12. Question 1: - Can we have multiple components in Startup?
  1. Lab 1: - .NET Core and .NET Standards.
  2. Lab 2: - MVC Core basics (Startup.cs, Program.cs.appsettings.json & Kestrel).
  3. Lab 3: - Request Pipelines and Middleware.
  4. Lab 4: - Implementing basic Model, View and Controller.
  5. Lab 5: - Routing, Conventional, Attribute and Route Constraint
  6. Lab 6: - Creating Models & strongly typed views.
  7. Lab 7: - DI(Transient, Scoped, Singleton and Factory).
  8. Lab 8: - Hosting MVC Core Application on IIS & Apache.
  1. Lesson 1 - Azure DevOps Account, Create and Access DevOps Project, DevOps Lifecycle, DevOps Project Structure.
  2. Lesson 1.1 - Agents in DevOps, Define YAML, Understand YAML structure, Run Pipeline.
  3. Lesson 2 - IIS Installation, Deployment Groups, Create and run Release Pipelines.
  4. Lesson 3 :- Create access variable, Diff Variables & variable groups, VSO Task.
  5. Lesson 4 :- Implementing CI CD Pipeline using Azure DevOps.
  6. Lesson 5 :- Executing Unit test in Azure Pipelines.
  7. Lesson 6 :- Parallelism, Stages, Jobs, Steps & Tasks - Pipeline Structure.
  1. Day 2 :- .NET Memory - Garbage Collector (GC0, GC1 and GC2) -21-04-2024.
  2. Day 1 :- Basics of Performance Counters, Data Collector Set, .NET Core vs .NET Framework -20-04-2024.
  3. Day 3:- Resolve Destructor problem using IDisposable and Dispose Pattern, Understand .NET Memory Management -27-04-2024.
  4. Day 4 :- Fundamentals of Instrumentation and Telemetry, write basic Instrumentation code inside .NET -28-04-2024.
  5. Day 5 :- Why use OpenTelemetry with a practical demo, Export and Source Configuration, Tracing, Event and Tags -04-05-2024.
  6. Day 6 :- Connect OpenTelemetry Code to Prometheus -05-04-2024.
  7. Day 7 :- Query the WaitStats table, Session and find actual sql, Query Store, Read Committed and Uncommitted Isolation Levels -18-05-2024.
  8. Day 8 :- Demo on Adaptive Sampling and Quick Revision -19-05-2024.
  9. Performance Tuning Syllabus and Notes.
  1. Lab 1: - Azure, Cloud, SAAS, PAAS and IAAS.
  2. Lab 2: - SQL Server on Azure(DTU & EDTU).
  3. Lab 3: - Azure Functions.
  4. Lab 4: - Azure storage (Blobs, Table, File and Queue).
  5. Lab 5: - Explain Cosmos DB in Azure.
  6. Lab 6: - Microservices & Azure Fabric.
  7. Lab 7: - Azure tables, Partition and Row keys.
  8. Lab 8: - Block blobs, Append blobs & Page blobs.
  9. Lab 9: - Azure Queues, visibility timeouts, Peek & De-Queue.
  10. Lab 10: - Cloud services vs App services.
  11. Lab 11: - WebJob and background processing.
  12. Lab 12: - Azure DevOps using Azure Pipeline.
  13. Lab 13: - Microservices using Docker and Azure.
  14. Lab 14: - Azure Virtual Network(VNET) and Network Security Groups(NSG).
  15. Lab 15: - Function Apps and Serverless Concept.
  1. Lab 1: - MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house(60 minutes)
  2. Upgrade Lab 1.1: - MSBI Installation in Details (30 minutes)
  3. Lab 2: - Conditional split, Data conversion and Error handling(30 minutes)
  4. Lab 3: - For Loop, Variables, Parameters and Debugging(30 minutes)
  5. Lab 4: - Packaging and Deployment, File component and running SSIS package as a task.(35 minutes)
  6. Lab 5: - For dimension, measures, star schema, snow flake, shared connection managers & packages tasks.(30 minutes)
  7. Lab 6: - SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(45 minutes)
  8. Lab 7: - Lookup, Data conversion optimization and updating SSIS package.(40 minutes)
  9. Lab 8: - Sort, Merge and Merge Joins.(21 minutes)
  10. Lab 9: - Creating SSAS Cube(30 Minutes)
  11. Lab 10: - SSAS Time series and Excel display(30 Minutes)
  12. Lab 11: - What are Transactions and CheckPoints in SSIS?(30 Minutes)
  13. Lab 12: - Simple SSRS report & implementing Matrix, Tabular, Parameters, Sorting, Expressions(60 Minutes)
  14. Lab 13: - Using Data Profiling task to check data quality(20 Minutes)
  15. Lab 14: - Hierarchical Dimensions(30 Minutes)
  16. Lab 15: - WebServices and XML Task(15 Minutes)
  17. Lab 16: - DrillDown and Subreports(20 Minutes)
  18. Lab 17: - SSAS KPI(Key Performance Indicators)(15 Minutes)
  19. Lab 18: - Pivot, UnPivot and Aggregation(20 Minutes)
  20. Lab 19: - SSAS Calculation.(30 Minutes)
  21. Lab 20: - SQL Execute Task (30 Minutes)
  22. Lab 21: - Reference and Many-to-Many Relationship(30 Minutes)
  23. Lab 22: - Script Task and Send Mail Task(15 Minutes)
  24. Lab 23: - Script component(SSIS)(45 Minutes)
  25. Lab 24: - Bar chart, Gauge and Indicators(20 Minutes)
  26. Lab 25: - Partitions in SSAS (30 Minutes)
  27. Lab 26: - CDC(Changed Data Capture) in SSIS(35 Minutes)
  28. Lab 27: - Additive, Semiadditive and non-additive measures in SSAS(15 Minutes)
  29. Lab 28: - Buffer Size Tuning (SSIS)
  30. Lab 29: - How to implement Multithreading in SSIS?
  31. Lab 30: - Processing SSAS cube in background.
  32. Lab 31: - Explain Asynchronous, Synchronous, Full blocking, Semi-blocking and Non-blocking SSIS Components.
  33. Lab 32: - SSRS Architecture and Deployment.
  34. Lab 33: - DQS(Data Quality Services).
  35. Lab 34: - Explain Tabular Model and Power Pivot (SSAS).
  36. Lab 35: - MDX (Multidimensional Expressions) Queries.
  37. Lab 36: - Data Mining (Fundamentals and Time Series Algorithm).
  38. Lab 37: - Page Split and Performance issues with SSIS.
  39. Lab 38: - Aggregations in SSAS.
  40. Lab 39: - ROLAP, MOLAP and HOLAP.
  41. Lab 40: - Instrumentation using Data Taps (SSIS).
  42. Lab 41: - Lookup caching modes and Cache Transform.(SSAS)
  43. Lab 42: - Perspectives & Translations.(SSAS)
  44. Lab 43: - Tabular Training 1: - Installation, Xvelocity, Vertipaq, DAX, Creating cubes, measures, KPI, Partition and Translation?(SSAS)
  1. Data structure tutorial - Lab 1.
  2. Chapter 1:- Basic definitions , BIG O and LinkList data structure
  3. Chapter 2:- Double linklist and Binary tree DS
  4. Chapter 3:- Binary tree DS- 21st April 2020
  5. Chapter 4:- Graph data structure ,BFS and DFS - 23rd April 2020
  6. Chapter 5:- Sorting Algorithms - Bubble , Inserted and Selection.
  7. Chapter 6:- Merge Sort DS
  8. Chapter 7:- Quick sort and Dijkstra Algorithm DS
  9. Chapter 8:- Dijkstra Algorithm and BellMans Ford DS
  10. Chapter 9:- Kadanes Algorith and Flyod Detection loop DS
  11. Chapter 10:- Queue and Stack Data structure and Flood Fill algorithm DS
  12. Chapter 11:- Hashing algorithm, Open space and Linking strategy -09th June 2020
  13. Chapter 12:- Huffman compression,Knapsack fraction and 0/1 -23rd June 2020
  14. Chapter 13:- Tower of Hanoi problem - 30th June 2020
  15. Chapter 14:- Travelling sales man logic using C# -08th July 2020
  16. Data Structure and Algorithm Using C# Source Code
  1. Questions on ETL Process, SSIS Control Flow and other SSIS concepts.
  2. Questions on Error Handling, SSIS Containers, Deploy SSIS Package.
  3. Questions on SSIS Logging, Union All vs Merge, Data Profiling Task.
  4. Questions on Joins in MSBI, OLAP VS OLTP, Star Schema, Snow Flake, SSAS Cube.
  5. Questions on CDC, SSRS Report, Tabular Report, Matrix Report and Page Break.
  6. Explain creating cascade parameters and defining clickable areas in SSRS Reports ?
  1. Differentiate between sum vs sumx and Direct Query vs Import Query.
  2. Covers Calculated Columns, Measures, Power Query, Data Gateway & Parameters.
  3. Questions on ALL & ALL EXCEPT functions, Grouping , what if parameter, Distinct.
  4. Power BI Questions & Answers PDF
  5. Important questions on DAX, DAX Function, Power Query, Power BI Reports.
  6. Append Query vs Merge Query and different types of Power BI Joins.
  7. LookupValue DAX function, Differentiate Datesbeteween VS DatesinPeriod in Power BI.
  8. Crack Power BI Interview Questions on COUNTA, COUNTX, COUNTAX, Filter Top N.
  9. Difference between USERELATIONSHIP and TREATAS, Bookmark in Power BI.
  10. Variables in Power BI and how Power Pivot and Unpivot differs from each other.
  11. Explain how to use Calculate DAX Function ?
  12. Essential questions around Table Joins, Crossjoin, and DAX RANX Function.
  13. RELATED VS RELATEDTABLE, DATEADD & PARALLELPERIOD Functions in DAX.
  1. Lab 1: - Data Types & Scoping.
  2. Lab 2: - Literal and Constructor function objects in JavaScript.
  3. Lab 3: - Prototypical Language and Prototypical Inheritance.
  4. Lab 4: - JavaScript Closures.
  5. Lab 5: - Explain IIFE(Immediately Invoked Function Expression).
  6. Lab 6: - Arrow functions and Automatic context(12 minutes)
  7. Lab 7: - NodeJS and NPM.
  8. Lab 8: - Module Loaders, CommonJS & SystemJS.
  9. Lab 9: - TypeScript in 45 Minutes.
  10. Lab 10: - WebPack in 50 minutes.
  11. Shims, Polyfills and Core-js.
  12. What is Zone.js?
  13. What is Reflect-Metadata?
  14. Understanding CommonJS Module specification.
  15. Learn Visual Studio Code in 10 Simple Steps.
  16. JavaScript Training for C# developers - Part 1
  17. JavaScript Training for C# developer Part 2 ( OOP in JavaScript).
  18. What is Less.JS ( Less) ?
  19. Explain Mixin in LESS ( Less) ?
  20. Explain unobtrusive javascript?
  1. (Angular 2.X and 4.X) Lab 1: - Modules,Components, ng-model & expressions (1 hr)
  2. (Angular 2.X and 4.X) How to open Angular 2 Source code
  3. (Angular 2.X and 4.X) Lab 2: - 1-way/2-way binding, interpolations, template binding, event binding & cloning.
  4. (Angular 2.X and 4.X) Lab 3: - @Input, @Output & Eventemitters.
  5. (Angular 2.X and 4.X) Lab 4: - Angular Component Life Cycle.
  6. (Angular 2.X and 4.X) Lab 5: - Providers, Services and Dependency Injection.
  7. (Angular 2.X and 4.X) Lab 6: - SPA(Single Page Application) using Routing.
  8. (Angular 2.X and 4.X) Lab 7: - Validation using Angular forms.
  9. (Angular 2.X and 4.X) Lab 8: - Making HTTP POST calls to REST service (WebAPI) using Angular 2.
  10. (Angular 2.X and 4.X) Lab 9: - Lazy loading using Angular 2.
  11. (Angular 2.X and 4.X) Lab 10: - Use WebPack for Angular 2 application.
  12. (Angular 2.X and 4.X) Lab 11: - Use VS Code Editor.
  13. (Angular 2.X and 4.X) Lab 12: - Migration Angular 2.X to Angular 4.X.
  14. (Angular 2.X and 4.X) Lab 13: - Auxiliary router outlet / Named router outlet.
  15. (Angular 2.X and 4.X)Lab 14: - PathLocation & HashLocation Strategy.
  16. (Angular 2.X and 4.X)Lab 15: - Using JQuery in Angular 2/4.
  17. (Angular 2.X and 4.X)Lab 16: - Pipes in Angular 2/4.
  18. (Angular 1.X) Lab 1: - $scope, $rootscope, controller, models, expression & debugging.
  19. (Angular 1.X) Lab 2: - Digest Cycle, Watchers, One time, $watch and $apply.
  20. (Angular 1.X) Lab 3: - Services and Factory.
  21. (Angular 1.X) Lab 4: - Using $http service with WebAPI as back end.
  22. (Angular 1.X) Lab 5: - Custom Directives, Restrict and Isolation Scope.
  23. (Angular 1.X) Lab 6: - Deferred and Promises.
  24. (Angular 1.X) Lab 7: - Angular Unit Testing using Jasmine.
  25. (Angular 1.X) Lab 8: - Implementing SPA using Angular Route and Angular UI Router.
  26. (Angular 1.X) Lab 9: - Emit, BroadCast and On Events.
  27. (Angular 1.X) Lab 10: - Filters in Angular.
  28. (Angular 1.X) Lab 11: - JQuery with AngularJS.
  29. (Angular 1.X) Lab 12: - Dot Rule and Controller AS Keyword.
  30. (Angular 1.X) Lab 13: - Angular Provider (Constant, Values, Provider, Service and Decorator).
  1. Lab 1: - C# fundamentals, For loop, data types, Error handling, classes/objects, Methods and functions.
  2. Lab 2: - Synch, Asynch, Delegates, Multicast Delegates and Events.
  3. Lab 3: - Simple File Search Project.
  4. Lab 4: - Customer Project(2 layers and validations).
  5. Lab 5: - Inserting customer data using ADO.NET.
  6. Lab 6: - Display, Update and Delete.
  7. Lab 7: - Reusability and Configuration.
  8. Using SQL script files.
  9. Lab 8: - Implementing the Product master table.
  10. Lab 9: - Implementing Stored Procedures.
  11. Lab 10: - In-memory inserts and update.
  12. Lab 11: - In-memory Deletes & understanding Usability.
  1. Lab 1: - Simple Hello world (20 Minutes)
  2. Lab 2: - Explain MVC Routing (10 Minutes)?
  3. Lab 3: - Explain ViewData, ViewBag, TempData & Session Variables?(20 Minutes)
  4. Lab 4: - Explain Model and Strongly typed views(20 minutes)?
  5. Lab 5: - Explain Model Binders(10 minutes)?
  6. Lab 6: - Why MVC and MVC vs Webforms?(30 minutes)
  7. Lab 7: - Explain TempData, Peek and Keep?(10 Minutes)
  8. Lab 8: - Explain Data Annotations and HTML Helpers classes?(31 Minutes)
  9. Lab 9: - What is the need of ViewModel in MVC?(10 Minutes)
  10. Lab 10: - How can we use Entity Framework in MVC?(20 Minutes)
  11. Lab 11: - How to implement viewmodel, partial view and webgrid?(45 minutes)
  12. Lab 12: - What is the difference between ActionResult and ViewResult in MVC?(10 minutes)
  13. Lab 13: - How to implement Ajax using JSON and Jquery using MVC?(60 minutes)
  14. Lab 14: - What is the use of Async Controllers in MVC?(20 minutes)
  15. Lab 15: - How to deploy MVC Application on IIS?(10 minutes)
  16. Lab 16: - How can we do Windows and Forms Authentication in MVC?(50 Minutes)
  17. Lab 17: - How can we use MVC areas for better modular development?(10 Minutes)
  18. Lab 18: - How to implement MVC with Angular?(60 minutes)?
  19. Lab 19: - Can we Overload MVC Action methods?(10 Minutes)?
  20. Lab 20: - How to improve Reusability using Angular?(20 Minutes)?
  21. Lab 21: - What is the need of WebAPI in MVC?(30 Minutes)
  22. Lab 22: - How to do exception handling in MVC? (30 Minutes)
  23. Lab 23: - How to do update & delete using MVC, WebAPI, EF & Angular?(30 Minutes)
  24. Lab 24: - How to use MVC Webgrid?(30 minutes)
  25. Lab 25: - How to implement Validation using Angular and MVC?(30 minutes)
  26. Lab 26: - What is SPA (Single Page Application)?(30 minutes)
  27. Lab 27: - How to Organize MVC project and Understanding CORS issue?(42 minutes)
  28. Lab 28: - Explain the importance of DisplayModes?
  29. Lab 29: - How to do unit testing with MVC projects?
  30. Lab 30: - How to implement SPA using Angular Routing?
  31. Lab 31: - How to create decoupled systems using MVC DI?
  32. Lab 32: - How can we have multiple submit buttons in ASP.NET MVC?
  33. Lab 33: - What is the importance of AntiForgery in MVC?
  34. Lab 34: - What is the importance of ValidateInput and AllowHTML in MVC?
  35. Lab 35: - Bundling and Minification.
  36. Lab 36: - Layout pages in Razor.
  37. Lab 37: - What are ActionFilters in MVC?
  38. Lab 38: - What is WebAPI (Theory)?
  39. Lab 39: - How can we create and consume WEB API(Practical)?
  40. Lab 40: - MVC 6/ASP.NET Core Training-Part 1(2 Hours)
  41. Lab 41: - WebAPI.(1.5 Hours)
  1. Lab 1: - Explaining Tableau, its various versions, installation & understanding tool UI.
  2. Lab 2: - Publishing/distributing report, various interface, Tableau file extensions.
  3. Lab 3: - Datatypes, Managing Metadata & Extracts, Cross Database Joins, Data Blending.
  4. Lab 4: - Explaining Cube and Relational Datasource with their difference, Data preparation in Tableau.
  5. Lab 5: - Visual Analytics(Sorting, Grouping, Filters, Drill Down & Hierarchies) - Part 1.
  6. Lab 6: - Visual Analytics(Parameters, Forecasting, Clustering & Trend) - Part 2.
  7. Lab 7: - Explaining and Creating Dashboards & Stories in Tableau.
  8. Lab 8: - Understanding, using various options & services in creating, customizing Maps in Tableau.
  9. Lab 9: - Explaining different Calculations and LOD(Level of Detail) expression in Tableau workbook.
  10. Lab 10: - Exploring and working with different types of Charts available in Tableau.
  1. Lab 1: - Basic Fundamentals Database, Tables, rows and columns.
  2. Lab 2: - Primary key, foreign key, referential integrity and constraints.
  3. Lab 3: - Database Normalization (1st, 2nd and 3rd normal forms).
  4. Lab 4: - SQL basics(Select, Insert, Update and Delete)
  5. Lab 5: - DDL(Data Definition Language) Queries.
  6. Lab 6: - Transactions, Locks and Isolation level in SQL Server.
  7. Lab 7: - ISNULL and Coalesce functions
  8. Lab 8: - Row_Number, Partition, Rank and DenseRank
  9. Lab 9: - Triggers, inserted and deleted tables
  10. Lab 10: - Instead of and after triggers.
  11. Lab 11: - Denormalization, OLTP and OLAP
  12. Lab 12: - Understanding Star schema and Snow flake design.
  13. Lab 13: - SQL Server 8 kb pages.
  14. Lab 14: - Index and performances
  15. Lab 15: - Page Split and indexes
  16. Lab 16: - Clustered vs non-clustered
  17. Lab 17: - Stored procedures and their importance.
  18. Lab 18: - Change Data Capture.
  19. Lab 19: - Explain Columnstore Indexes?
  20. Lab 20: - SQL Server agent
  21. Lab 21: - How can we implement Pivot & Unpivot in SQL Server?
  1. Basics: - Query plan, Logical operators and Logical reads
  2. Point 1: - Unique keys improve table scan performance.
  3. Point 2: - Choose Table scan for small & Seek scan for large records
  4. Point 3: - Use Covering index to reduce RID (Row Identifier) lookup
  5. Point 4: - Keep index size as small as possible.
  6. Point 5: - use numeric as compared to text data type.
  7. Point 6: - use indexed view for aggregated SQL Queries
  8. Point 7: - Database Engine tuning advisor is your best friend.
  9. Part 1 - Profiler, Tuning advisor, Clustered/Non-clustered indexes,DBCC command & Reading SQL Plan, OLTP & OLAP.
  10. Part 2 - Estimated vs Actual plan/rows, SQL Plan revised, Table/Index scan, Indexes seek, Physical/Logical opertn, Execution mode, columnstore, Rebinds, Rewinds, Nested loop, Hash/Merge join
  11. Part 3 - Interleaved Execution, Fragmentation, Performance counters, Page splits and Unused Indexes
  12. Part 4 - Extended events, RID lookup and Covering indexes
  13. Part 5 - Indexed views, Page splits & unused indexes, Dead locks, Query store Parameter sniffing Statistics
  14. Part 6 - Inline vs Stored procedure SQL, Cache miss, Cache hit, Parameter sniffing and Query store.
  15. Part 7 - Partitioning, Wait stats, Resource Governor, Inmemory Tables
  1. C# tutorial for beginners (4 hrs 43 mins)
  2. What is IL code, CLR, CLS & JIT? - Part1
  3. What is IL code, CLR, CLS & JIT? - Part2
  4. Explain JIT,Pre-jit,Eco-Jit,Normal-Jit and NGEN.EXE?
  5. What is CAS, evidence, permission set & code groups?
  6. What are the changes in .NET 4.0 security model & What is sandboxing?
  7. Explain Assembly, EXE and DLL.
  8. Explain App Domain?
  9. What is the difference between managed & unmanaged code?
  10. What is Garbage Collector, Gen 0, 1 & 2?
  11. What is IDisposable interface & finalize dispose pattern in GC?
  12. What is the difference between strong and weak references?
  13. What is delay signing?
  14. Can we see simple example of GAC & How to handle multiple versions in GAC?
  15. What are different .NET datatypes and its uses according to scenarios?
  16. Explain TypeSafe,Casting,Explicit casting and implicit casting?
  17. Explain the sentence "C# strings are immutable"?(Also covers stringbuilder & interning)
  18. Explain Synch, Asynch, Delegates, Multicast Delegates and Events.
  19. How can we make Asynchronous method calls using delegates?
  20. What are anonymous methods in C#?
  21. Why anonymous types are preferred over Tuples?
  22. What is the use of Lambda Expression Action<>, Predicate<> & Func<>?
  23. What do you mean by Covariance & Contravariance in .NET 4.0?
  24. What is the use of checked and unchecked keyword?
  25. What is a stack, Heap, Value types and Reference types?
  26. What is boxing and unboxing?
  27. C# Out Vs Ref
  28. What is optimistic and pessimistic locking? - Part1
  29. Can you explain optimistic locking? - Part2
  30. Can you explain pessimistic locking? - Part3
  31. What are regular expressions & can we see some practical demonstrations?
  32. Why do we need Regex timeout(.NET 4.5 feature)?
  33. 5 tips to improve your C# debugging.
  34. Can you explain Named Parameters, Ref, Out, Volatile & Parsetry?
  35. What is the difference between Const & ReadOnly?
  36. Explain the difference between "IS" and "AS" keyword?
  37. What are Extension Methods?
  38. What is #Debug directive?
  39. What is the difference between Debug and Release?
  40. What is serialization and deserialization?
  41. What is the difference between TypeOf and GetType?
  42. What is IComparable and IComparer?
  43. What is the use of Yield Keyword in C#?
  44. What is a C# indexer?
  45. What is the difference between == vs .Equals()?
  46. When should we override GetHashCode?
  47. What are ??(Coalescing operators)?
  48. What is C# reflection?
  49. What is Dynamic keyword & How does it differ from Reflection?
  50. What is the difference between Early binding and Late binding?
  51. What is a difference between VAR and Dynamic keyword?
  52. What is the use of VAR keyword in C#?
  53. What are Circular Dependencies and How to resolve them?
  54. How can we mark a method as deprecated?
  55. What is the difference between Build Vs Rebuild Vs Clean?
  56. Importance of bin folder & obj folder in C#.
  57. What is Naming Convention?
  58. What is Nuget?
  59. What are portable class libraries?
  60. What is Asynch and Await keywords?
  61. Explain Concurrency VS Parallelism? - (Part 1)
  62. Does Async use threads? - (Part 2)
  63. What are ENUM's and flags in ENUMS?
  64. How to convert string to ENUM ?
  65. How to use MSMQ with C#?
  66. Explain NULLABLE Types?
  67. Explain C# Attributes?
  68. What is Automapper?
  69. What are DataAnnotations?
  70. C# Random numbers.
  71. What is .NET Core, DNX, DNU and DNVM?
  72. How to work with files and folders (System.IO)?
  73. Explain C# Exceptions?
  74. Learn Redis Cache in 20 minutes.
  75. POST, GET, PUT, DELETE & PATCH.
  76. Preprocessor Directives/Symbols.
  1. Lab 1: - Learn Power BI step by step(for beginners).
  2. Lab 2: - Connecting SQL Server with Power BI.
  3. Lab 3: - Line, Area, Stacked, Gauge, KPI and Funnel Graph in Power BI.
  4. Lab 4: - Star Schema & Snow Flake design in Power BI project.
  5. Lab 5: - DAX(Data Analysis Expression) in Power BI(Part 1).
  6. Lab 6 - DAX(Data Analysis Expression) in Power BI(Part 2).
  1. MSBI Training Part 1-28-02-2021 (102:48)
  2. MSBI Training Part 2-07-03-2021 (96:58)
  3. MSBI Training Part 3-15-03-2021 (97:09)
  4. MSBI Training Part 4-04-04-2021 (97:34)
  5. MSBI Training Part 5-11-04-2021 (92:20)
  6. MSBI Training Part 6-18-04-2021 (43:30)
  7. MSBI Training Part 7-25-04-2021 (59:13)
  1. Lab 1: - Basics, Sitecollection, Subsite, Page, List and Document Library.
  2. Lab 2: - User, User group and Permissions.
  3. Lab 3: - Master Page Customization in SharePoint.
  4. Lab 4: - Site Columns and Content Types.
  5. Lab 5: - Integrating MVC with SharePoint (Part 1).
  6. Lab 6: - Integrating MVC with SharePoint - Part 2 (Consuming List).
  7. Lab 7: - Integration with MVC(SharePoint Hosted Model, CSOM and JSOM).
  1. Introduction
  2. Use Case Diagrams
  3. Class Diagrams
  4. Object Diagrams
  5. Sequence Diagrams
  6. Collaboration Diagrams
  7. Activity Diagram
  8. State chart Diagrams
  9. Component Diagrams
  10. Deployment Diagrams
  11. Stereo Types Diagrams
  12. UML Project Flow
  13. Practice with Tool
  14. Setup
  1. What are the different types of collections in .NET?- Part 1
  2. What is the difference between Array & ArrayList?- Part 2
  3. Can you prove why arrays are faster than arraylist?- Part 3
  4. What are the problems with arraylist & how can we solve the same by Hashtables?- Part 4
  5. What are stacks & queues?- Part 5
  6. What are special collections?- Part 6
  7. What are Generics & What are generics collections?- Part 7
  8. What are generics collections?- Part 8
  9. What is the use of IEnumerator, ICollection, IDictionary & IList?- Part 9
  10. What is the difference between IEnumerable and IEnumerator?
  11. Differentiate between IEnumerable vs IQueryable?
  12. Explain Generics Constraints?
  1. Learn Power BI Step by Step:- Beginners (54:40)
  2. Lab 2:- Connecting SQL Server with Power BI. (12:09)
  3. Lab 3:- Line, Area, Stacke, API, Gauge and Funnel. (13:57)
  4. Lab 4 :- Star Schema and Snow flake design (17:49)
  5. Lab 5 - DAX(Data Analysis Expression) in Power BI(Part 1). (31:45)
  6. Lab 6 - Dax(Data Analysis Expression) - Part 2. (36:30)
  1. What is Entity Framework (Theory)?
  2. Lab 1: - What is EDMX, Context and Models in EF?
  3. Lab 2: - How to read,insert, update & delete data using EF (Entity framework)?
  4. Lab 3: - How to insert custom business validation in Entity classes?
  5. Lab 4: - What are POCO Classes?
  6. Lab 5: - How to implement code first?
  7. Lab 6: - How to solve concurrency issues in EF (Optimistic locking )?
  8. Lab 7: - What is Clientwins and StoreWins in Entity framework?
  1. Introduction
  2. Application Boundary
  3. EI Fundamentals
  4. EO Fundamentals
  5. EQ Fundamentals
  6. EIF Fundamentals
  7. ILF Fundamentals
  8. GSC Fundamentals
  9. Productivity Factor
  10. Costing
  11. Function Point Template
  12. Estimating a Sample Project
  13. Function Point Estimation Excel
  14. Customer Maintenance
  1. What is Threading in C#.NET?
  2. How can we make a object thread safe using LOCK in multithreading?
  3. What is Mutex, Semaphore & SemaphoreSlim?
  4. What is AutoResetEvent and ManualResetEvent?
  5. What is Thread Pooling?
  6. How to debug Threads?
  7. What is TPL (Task Parallel Library) and how different it is from threads?