ASP.NET MVC CORE INTERVIEW QUESTIONS WITH ANSWERS
- Basic ASP.NET MVC Interview Questions with answers Part 1
- Session management &cookies ASP.NET MVC Interview Questions & Answers Part 2
- ViewData,ViewBag & ViewModel ASP.NET MVC Interview Questions & Answers Part 3.
- Tempdata :- ASP.NET MVC Interview Questions & Answers Part 4.
- WebAPI and REST :- ASP.NET MVC Interview Questions with answers - Part 5
- ASP.NET MVC Interview Questions with answers E-Book.
- JWT Token, Principal, Claim, Roles, Refresh Token, OpenId, OAuth - Part 6.
ARCHITECTURE INTERVIEW QUESTIONS & ANSWERS
- Lesson 1:- In this we will cover 25 Basic Architecture Interview questions with answers
- Lesson 2:-SOLID Principles Questions and Answers
- Lesson 3 :- Repository Pattern and UOW ( Unit of Work)
- Lesson 4:- Factory Pattern , Abstract Factory , DI , IOC , Service Locator
- Lesson 5 :- Factory and Abstract Factory pattern continued
- Architecture Interview Questions and Answers Book
- Architecture Interview Questions & Answers Source Code
SQL SERVER INTERVIEW QUESTIONS & ANSWERS
- Must and Basic Questions on SQL Server - Part 1
- Interview Questions around essential concepts of SQL Server - Part 2
- Important questions on SubQuery and Cor-related Queries in SQL - Part 3
- How to Find Nth Highest Salary ? - Part 4
- Covered Questions on finding Nth highest using co-related & TSQL - Part 5
- Questions around SQL Server CTE(Common Table Expression) - Part6
- Questions around Window functions, Rank, Dense_Rank and RowNumber - Part 7
- Questions around Delete Duplicate Records scenarios - Part 8
- SQL Interview Questions & Answers PDF.
C# INTERVIEW QUESTIONS WITH ANSWERS
- Questions on Stack, Heap, Boxing, Unboxing, Array, ArrayList, Generics, Threading.
- Questions on Delegates, Event & Delegates vs Events.
- Questions OOP, Abstraction, Encapsulation, Inheritance, Virtual, Overriding and overloading.
- Questions Polymorphism, Static vs Dynamic polymorphism and operator overloading.
- Tricky Questions around Abstract classes and Interfaces.
- Answering the most asked Question "Abstract classes vs Interface".
- Questions around constructors & in parent child which constructor fires first.
- Questions around Shadowing, Sealed, Nested classes and partial classes.
- Questions Around SOLID principles , Dependency injection (DI) and Inversion of Control(IOC)
- Explain & Differentiate Composition, Aggregation and Association in C#.
- Crack questions on Stack, Heap, Boxing, Unboxing, Value & Reference types
- What is Garbage collector, Managed vs UnManaged code, Memory Leaks.
- Questions around Design Pattern Basics, Types of Pattern, Singleton Pattern, Prototype, Template and Adapter.
- Repository and Unit of Work Design Pattern Interview Questions.
- C# interview questions with answers PDF
- Most asked Factory Pattern, DI and IOC Interview Questions.
- The Real Factory and Abstract Factory.
JAVASCRIPT INTERVIEW QUESTIONS AND ANSWERS
- JavaScript basics Interview questions with answers.
- 7 Important JavaScript Questions on ES6 & JavaScript Functions.
- Technical Questions on Sync, Async, Threading, Event Loop, Blocking and Non-Blocking and Callback Queue.
- Tricky Questions on Promises, callbacks, Asynch, Await, Micro,Macro, Webworker.
- JavaScript Interview Questions & Answers PDF.
- Source Code
- 25 Interview Questions on Angular basic concepts.
- Covered 6 Important questions on ViewChild and ViewChildren in Angular.
- Questions around Angular component lifecycle.
- Tricky Interview questions on HTTP calls, Emitters & Routing.
- Questions on Angular Pipes
- Ten important questions on RxJS (Reactive Extensions for JavaScript).
- Essential questions around Interceptors.
- Angular Interview Questions and Answers PDF
- Lesson 8 :- Important Questions on Angular Validations.
POWER BI STEP BY STEP TUTORIAL FOR BEGINNERS & EXPERIENCED
- Part 1 - What is Power BI, Linked Reports, Power BI Installation, Power Query.
- Part 2 - Explain Pivot vs Unpivot, Parameters, Merge and append Queries.
- Part 3 - Joins and Join Kind, Optimize PBIX File , Database Normalization.
- Part 4 - Explain Data Model, OLTP, Star Schema & Snowflake Design. Dax Function.
- Part 5 : Maths DAX Function, Logical DAX Function, Text DAX Function in Power BI.
- Part 6 :- Understand Filter Dax Functions in Power BI.
- Part 8 :- Explain Fields in Power BI, Numeric range parameter and difference between DateAdd and ParallelPeriod.
- Part 9 :- LookupValue DAX Function and Date & Time Function in Power BI.
- Part 10 :- DAX Variables, Power DAX USERELATIONSHIP & TREATAS.
- Part 11 :- Explain the difference between TotalMTD & DatesMTD, what is SAMEPERIODLASTYEAR function in DAX.
- Part 12 :- What is RELATED and RELATEDTABLE, Calculate Top N Values Dynamically & rank using DAX RANKX.
- Part 13 :- Explain SELECTEDVALUE DAX function, SELECTCOLUMNS vs ADDCOLUMNS.
- Part 14 :- Use GROUPBY without DAX, Explain SUMMARIZE vs GROUPBY.
LEARN ANGULAR STEP BY STEP FOR BEGINNERS
- Lab 1: - Running your first Angular Application. (71:26)
- Lab 2: - Creating the Customer UI, Model and Component. (39:45)
- Lab 3: - Angular Routing: Creating Master pages and navigations (30:51)
- Lab 4: - Increasing Performance using Lazy Loading. (35:39)
- Lab 5: - Implement Validations in Angular. (40:55)
- Lab 6: - Angular Dependency Injection. (34:34)
- Lab 7:- Input,output and event emitters. (37:58)
- Lab 8:- Make HTTP calls using Angular Components. (41:33)
- Lab 9: - Integrating MVC Core with Angular using Visual Studio. (90:27)
- Lab 10:- Migratting Angular 6 to Angular 7 (17:36)
- Lab 11 :- Unit Testing in Angular using Jasmine & Karma. (32:31)
- Question 1 :- Can we have multiple components in up? (8:54)
- Angular Book Download
.NET AND SQL SERVER PERFORMANCE TUNING TRAINING
- Day 2 :- .NET Memory - Garbage Collector (GC0, GC1 and GC2) -21-04-2024.
- Day 1 :- Basics of Performance Counters, Data Collector Set, .NET Core vs .NET Framework -20-04-2024.
- Day 3:- Resolve Destructor problem using IDisposable and Dispose Pattern, Understand .NET Memory Management -27-04-2024.
- Day 4 :- Fundamentals of Instrumentation and Telemetry, write basic Instrumentation code inside .NET -28-04-2024.
- Day 5 :- Why use OpenTelemetry with a practical demo, Export and Source Configuration, Tracing, Event and Tags -04-05-2024.
- Day 6 :- Connect OpenTelemetry Code to Prometheus -05-04-2024.
- Day 7 :- Query the WaitStats table, Session and find actual sql, Query Store, Read Committed and Uncommitted Isolation Levels -18-05-2024.
- Day 8 :- Demo on Adaptive Sampling and Quick Revision -19-05-2024.
- Performance Tuning Syllabus and Notes.
LEARN MVC 5 STEP BY STEP IN 2 DAYS
- Lab 1: - Simple Hello world (20 Minutes) (23:06)
- Lab 2: - Explain MVC Routing (10 Minutes)? (13:13)
- Lab 3: - Explain ViewData, ViewBag, TempData & Session Variables?(20 Minutes) (27:27)
- Lab 4: - Explain Model and Strongly typed views(20 minutes)? (25:23)
- Lab 5: - Explain Model Binders(10 minutes)? (10:42)
- Lab 6: - Why MVC and MVC vs Webforms?(30 minutes) (28:51)
- Lab 7: - Explain TempData, Peek and Keep?(10 Minutes) (10:21)
- Lab 8: - Explain Data Annotations and HTML Helpers classes?(31 Minutes) (31:55)
- Lab 9: - What is the need of ViewModel in MVC?(10 Minutes) (13:39)
- Lab 10: - How can we use Entity Framework in MVC?(20 Minutes) (19:23)
- Lab 11: - How to implement viewmodel, partial view and webgrid?(45 minutes) (44:18)
- Lab 12: - What is the difference between ActionResult and ViewResult in MVC?(10 minutes) (10:21)
- Lab 13: - How to implement Ajax using JSON and Jquery using MVC?(60 minutes) (50:24)
- Lab 14: - What is the use of Async Controllers in MVC?(20 minutes) (17:04)
- Lab 15: - How to deploy MVC Application on IIS?(10 minutes) (12:13)
- Lab 16: - How can we do Windows and Forms Authentication in MVC?(50 Minutes) (45:55)
- Lab 17: - How can we use MVC areas for better modular development?(10 Minutes) (8:38)
- Lab 18: - How to implement MVC with Angular?(60 minutes)? (52:15)
- Lab 19: - Can we Overload MVC Action methods?(10 Minutes)? (6:35)
- Lab 20: - How to improve Reusability using Angular?(20 Minutes)? (17:45)
- Lab 21: - What is the need of WebAPI in MVC?(30 Minutes) (36:56)
- Lab 22: - How to do exception handling in MVC? (30 Minutes) (25:47)
- Lab 23: - How to do update & delete using MVC, WebAPI, EF & Angular?(30 Minutes) (25:46)
- Lab 24: - How to use MVC Webgrid?(30 minutes) (25:39)
- Lab 25: - How to implement Validation using Angular and MVC?(30 minutes) (26:12)
- Lab 26: - What is SPA (Single Page Application)?(30 minutes) (27:49)
- Lab 27: - How to Organize MVC project and Understanding CORS issue?(42 minutes) (42:01)
- Lab 28: - Explain the importance of DisplayModes? (8:33)
- Lab 29: - How to do unit testing with MVC projects? (26:38)
- Lab 30: - How to implement SPA using Angular Routing? (16:51)
- Lab 31: - How to create decoupled systems using MVC DI? (56:03)
- Lab 32: - How can we have multiple submit buttons in ASP.NET MVC? (12:35)
- Lab 33: - What is the importance of AntiForgery in MVC? (8:40)
- Lab 34: - What is the importance of ValidateInput and AllowHTML in MVC? (9:36)
- Lab 35: - Bundling and Minification. (14:42)
- Lab 36: - Layout pages in Razor. (27:28)
- Lab 37: - What are ActionFilters in MVC? (14:54)
- Lab 38: - What is WebAPI (Theory)? (3:31)
- Lab 39: - How can we create and consume WEB API(Practical)? (15:27)
- Lab 40: - MVC 6/ASP.NET Core Training-Part 1(2 Hours) (111:00)
- Lab 41: - WebAPI (76:25)
- Event management application project end to end.
- Lab 1:- .NET core and .NET Standards. (26:07)
- Lab 2: - MVC core basics(up.cs, Program.cs.appsettings.json & Kestrel). (26:13)
- Lab 3: -Request Pipelines and Middleware. (29:54)
- Lab 4:-Implementing basic Model,View and Controller. (33:03)
- Lab 5 :- Routing,Conventional,Attribute and Route Constraint (28:45)
- Lab 6:- Creating Models & strongly typed views. (18:34)
- Lab 7 :- DI (Transient , Scoped , Singleton and Factory) (33:19)
- Lab 8 :- Hosting MVC Core Application on IIS & Apache. (19:31)
AZURE DEVOPS TUTORIAL FOR BEGINNERS & PROFESSIONALS
- Lesson 1 - Azure DevOps Account, Create and Access DevOps Project, DevOps Lifecycle, DevOps Project Structure.
- Lesson 1.1 - Agents in DevOps, Define YAML, Understand YAML structure, Run Pipeline.
- Lesson 2 - IIS Installation, Deployment Groups, Create and run Release Pipelines.
- Lesson 3 :- Create access variable, Diff Variables & variable groups, VSO Task.
- Lesson 4 :- Implementing CI CD Pipeline using Azure DevOps.
- Lesson 5 :- Executing Unit test in Azure Pipelines.
- Lesson 6 :- Parallelism, Stages, Jobs, Steps & Tasks - Pipeline Structure.
LEARN MSBI , SSIS , SSRS AND SSAS STEP BY STEP
- Lab 1: - MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house(60 minutes) (50:15)
- Lab 1.1 Upgrade Installation (30:11)
- Lab 2: - Conditional split, Data conversion and Error handling(30 minutes) (33:30)
- Lab 3: - For Loop, Variables, Parameters and Debugging(30 minutes) (33:01)
- Lab 4: - Packaging and Deployment, File component and running SSIS package as a task.(35 minutes) (35:38)
- Lab 5: - For dimension, measures, star schema, snow flake, shared connection managers & packages tasks.(30 minutes) (30:04)
- Lab 6: - SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(45 minutes) (47:26)
- Lab 7: - Lookup, Data conversion optimization and updating SSIS package.(40 minutes) (39:36)
- Lab 8: - Sort, Merge and Merge Joins.(21 minutes) (20:46)
- Lab 9: - Creating SSAS Cube(30 Minutes) (40:08)
- Lab 10: - SSAS Time series and Excel display(30 Minutes) (25:39)
- Lab 11: - What are Transactions and CheckPoints in SSIS?(30 Minutes) (25:40)
- Lab 12: - Simple SSRS report & implementing Matrix, Tabular, Parameters, Sorting, Expressions(60 Minutes) (61:14)
- Lab 13: - Using Data Profiling task to check data quality(20 Minutes) (20:22)
- Lab 14: - Hierarchical Dimensions(30 Minutes) (25:58)
- Lab 15: - WebServices and XML Task(15 Minutes) (16:38)
- Lab 16: - DrillDown and Subreports(20 Minutes) (20:19)
- Lab 17: - SSAS KPI(Key Performance Indicators)(15 Minutes) (13:24)
- Lab 18: - Pivot, UnPivot and Aggregation(20 Minutes) (18:30)
- Lab 19: - SSAS Calculation.(30 Minutes) (31:35)
- Lab 20: - SQL Execute Task (30 Minutes) (29:31)
- Lab 21: - Reference and Many-to-Many Relationship(30 Minutes) (35:40)
- Lab 22: - Script Task and Send Mail Task(15 Minutes) (15:20)
- Lab 23: - Script component(SSIS)(45 Minutes) (43:34)
- Lab 24: - Bar chart, Gauge and Indicators(20 Minutes) (17:59)
- Lab 25: - Partitions in SSAS (30 Minutes) (24:49)
- Lab 26: - CDC(Changed Data Capture) in SSIS(35 Minutes) (35:46)
- Lab 27: - Additive, Semiadditive and non-additive measures in SSAS(15 Minutes) (15:47)
- Lab 28: - Buffer Size Tuning (SSIS) (32:31)
- Lab 29: - How to implement Multithreading in SSIS? (39:09)
- Lab 30: - Processing SSAS cube in background. (20:12)
- Lab 31: - Explain Asynchronous, Synchronous, Full blocking, Semi-blocking and Non-blocking SSIS Components. (27:11)
- Lab 32: - SSRS Architecture and Deployment. (22:24)
- Lab 33: - DQS(Data Quality Services). (43:32)
- Lab 34: - Explain Tabular Model and Power Pivot (SSAS). (39:44)
- Lab 35: - MDX (Multidimensional Expressions) Queries. (54:14)
- Lab 36: - Data Mining (Fundamentals and Time Series Algorithm). (30:00)
- Lab 37: - Page Split and Performance issues with SSIS. (25:06)
- Lab 38: - Aggregations in SSAS. (49:32)
- Lab 39: - ROLAP, MOLAP and HOLAP. (23:58)
- Lab 40: - Instrumentation using Data Taps (SSIS). (15:24)
- Lab 41: - Lookup caching modes and Cache Transform.(SSAS) (28:58)
- Lab 42: - Perspectives & Translations.(SSAS) (13:28)
- Lab: - 43 Tabular Training (55:46)
PHP INTERVIEW QUESTIONS & ANSWERS
- Questions around PHP, PHP Frameworks, CMS, $message vs $$message, Array, loop in PHP.
- Explain PHP string functions, Explode vs Implode, $_POSTand $_REQUEST.
- New database with MySQL & PHP, Use of htaccess, Explain Constructor & Destructor.
- Questions on 301 redirects in PHP, include() vs require(), "==" & "===" etc.
- Use imagetypes() function, Data type of any variable, Open a file from a folder.
- Explain Lambda function, Overloading & Overriding, static variable in function.
MSBI INTERVIEW QUESTIONS WITH ANSWERS
- Questions on ETL Process, SSIS Control Flow and other SSIS concepts.
- Questions on Error Handling, SSIS Containers, Deploy SSIS Package.
- Questions on SSIS Logging, Union All vs Merge, Data Profiling Task.
- Questions on Joins in MSBI, OLAP VS OLTP, Star Schema, Snow Flake, SSAS Cube.
- Questions on CDC, SSRS Report, Tabular Report, Matrix Report and Page Break.
- Explain creating cascade parameters and defining clickable areas in SSRS Reports ?
POWER BI INTERVIEW QUESTIONS & ANSWERS
- Differentiate between sum vs sumx and Direct Query vs Import Query.
- Covers Calculated Columns, Measures, Power Query, Data Gateway & Parameters.
- Questions on ALL & ALL EXCEPT functions, Grouping , what if parameter, Distinct.
- Power BI Questions & Answers PDF
- Important questions on DAX, DAX Function, Power Query, Power BI Reports.
- Append Query vs Merge Query and different types of Power BI Joins.
- LookupValue DAX function, Differentiate Datesbeteween VS DatesinPeriod in Power BI.
- Crack Power BI Interview Questions on COUNTA, COUNTX, COUNTAX, Filter Top N.
- Difference between USERELATIONSHIP and TREATAS, Bookmark in Power BI.
- Variables in Power BI and how Power Pivot and Unpivot differs from each other.
- Explain how to use Calculate DAX Function ?
- Essential questions around Table Joins, Crossjoin, and DAX RANX Function.
- RELATED VS RELATEDTABLE, DATEADD & PARALLELPERIOD Functions in DAX.
- Lab 1 :- Data Types & Scoping. (19:23)
- Lab 2 :- Literal and Constructor function objects in JavaScript. (7 Minutes) (6:46)
- Lab2JavaScriptPrototyicalLanguagePrototypicalInheritance4WmnTRf4vZ (13:02)
- Lab 4 :- JavaScript Closures (16 Minutes) (16:13)
- Lab 5: - Explain IIFE(Immediately Invoked Function Expression). (13 Minutes) (12:41)
- Lab 6 :- Arrow functions and Automatic context ( 12 minutes) (12:33)
- Lab 7 :- NodeJS and NPM.(12 Minutes) (11:30)
- Lab 8 :- Module Loaders, CommonJS & SystemJS. (22:40)
- Lab 9 :- TypeScript in 45 Minutes. (44:49)
- Lab 10 :- WebPack in 50 minutes. (34:44)
- Shims, Polyfills and Core-js. (8:30)
- What is Zone.js? (10:37)
- What is Reflect-Metadata? (7:35)
- Understanding CommonJS Module specification. (26:17)
- Learn Visual Studio Code in 10 Simple Steps. (34:58)
- JavaScript Training for C# developers - Part 1 (31:50)
- JavaScript Training for C# developer Part 2 ( OOP in JavaScript). (26:28)
- What is Less.JS ( Less) ? (7:09)
- Explain Mixin in LESS ( Less) ? (3:19)
- Explain unobtrusive javascript? (4:20)
LEARN ANGULARJS(1.X) STEP BY STEP
- (Angular 1.X)Lab 1:- $scope, $rootscope, controller, models, expression & debugging. (75:40)
- (Angular 1.X)Lab 2 :- Digest Cycle, watchers, One time, $watch and $apply. (32:24)
- (Angular 1.X)Lab 3 :- Services and Factory (46:49)
- (Angular 1.X)Lab 4 :- Using $http service with WebAPI as back end. (46:02)
- (Angular 1.X)Lab 5 :- Custom Directives, Restrict and Isolation Scope. (33:42)
- (Angular 1.X)Lab 6:- Deferred and Promises. (22:30)
- (Angular 1.X)Lab 7 :- Angular Unit Testing using Jasmine. (25:10)
- (Angular 1.X)Lab 8 :- Implementing SPA using Angular Route and Angular UI Router. (32:56)
- (Angular 1.X)Lab 9 :- Emit, BroadCast and On Events. (27:24)
- (Angular 1.X)Lab 10 :- Filters in Angular. (16:52)
- (Angular 1.X)Lab 11 :- JQuery with AngularJS. (12:22)
- (Angular 1.X)Lab 12 :- Dot Rule and Controller AS Keyword. (21:04)
- (Angular 1.X)Lab 13:- Angular Provider (Constant, Values, Provider, Service and Decorator). (53:39)
- AngularJS Notes
TABLEAU STEP BY STEP TUTORIAL FOR DATA ANALYST
- Tableau Installation, Features, Create first visualization, Grouping with Tableau, Combined Dimension, Save and publish Tableau Project - Part 1
- Create sets using Parameters, Joins, Create charts, Dashboards, Drill Down report using Dashboard - Part 2
- Cross Database Joins, Filters, Interactive Filters, explain Data Source Filters - Part 3
- Design Maps, Reference Lines in tableau & explain box and whisker plot - Part 4
- Create Gantt Chart, Waterfall Chart, Bump Chart and Funnel Chart in Tableau - Part 5
- How to Format Filters, What is Data Formatting, Marks Card, Quick Table Calculation - Part 6
- Understand Tableau Basic Calculation - Part 7.
- Logical Functions in Tableau - Part 8
- Explain frequently used logical functions and use compute Using in Tableau - Part 9.
- Lab 1: - C# fundamentals, For loop, data types, Error handling, classes/objects, Methods and functions. (57:55)
- Lab 2: - Synch, Asynch, Delegates, Multicast Delegates and Events. (35:34)
- Lab 3: - Simple File Search Project. (33:29)
- Lab 4: - Customer Project(2 layers and validations). (41:42)
- Lab 5: - Inserting customer data using ADO.NET. (31:35)
- Lab 6: - Display, Update and Delete. (36:45)
- Lab 7: - Reusability and Configuration. (18:33)
- Lab 7.1: - Using SQL script files. (4:13)
- Lab 8: - Implementing the Product master table. (27:23)
- Lab 9: - Implementing Stored Procedures. (18:44)
- Lab 10: - In-memory inserts and update. (31:24)
- Lab 11: - In-memory Deletes & understanding Usability. (11:33)
- Lab 1:- Azure,Cloud,SAAS,PAAS and IAAS. (40:31)
- Lab 2:- SQL Server on Azure ( DTU & EDTU) (32:41)
- Lab 3 :- Azure Functions. (25:12)
- Lab 4:- Azure storage (Blobs,Table,File and Queue). (23:51)
- Lab 5:- Azure Cosmos DB. (32:46)
- Lab 6: - Microservices & Azure Fabric in 90 Minutes. (93:22)
- Lab 7 :- Azure tables, Partition and Row keys. (59:08)
- Lab 8: - Block blobs, Append blobs & Page blobs. (55:29)
- Lab 9 :- Azure Queues , visibility timeouts ,Peek & De-Queue. (28:21)
- Lab 10 :- Cloud services vs App services. (36:23)
- Lab 11 :- WebJob and background processing. (43:01)
- Lab 12 : - Azure DevOps using Azure Pipeline (79:46)
- Lab 13 - Microservices using Docker and Azure. (73:56)
- Lab 14 - Azure Virtual Network(VNET) and Network Security Groups(NSG). (29:46)
- Lab 15 :- Function Apps and Serverless Concept. (29:33)
- Lab 16 :- Azure Logic Apps. (13:43)
- Basics:- Query plan, Logical operators and Logical reads. (11:47)
- Point 1:- Unique keys improve table scan performance. (5:12)
- Point 2:- Choose Table scan for small & Seek scan for large records. (8:57)
- Point 3:- Use Covering index to reduce RID (Row Identifier) lookup. (8:54)
- Point 4:- Keep index size as small as possible. (7:00)
- Point 5:- Use numeric as compared to text data type. (2:42)
- Point 6:- Use indexed view for aggregated SQL Queries. (10:12)
- Point 7:- Database Engine tuning advisor is your best friend. (13:06)
- Part 1 - Profiler, Tuning advisor, Clustered/Non-clustered indexes,DBCC command & Reading SQL Plan, OLTP & OLAP. (71:24)
- 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. (61:58)
- Part 3 - Interleaved Execution, Fragmentation, Performance counters, Page splits and Unused Indexes. (52:30)
- Part 4 - Extended events, RID lookup and Covering indexes. (57:58)
- Part 5 - Indexed views, Page splits & unused indexes, Dead locks, Query store Parameter sniffing Statistics. (53:24)
- Part 6 - Inline vs Stored procedure SQL, Cache miss, Cache hit, Parameter sniffing and Query store. (52:26)
- Part 7 - Partitioning, Wait stats, Resource Governor and Inmemory Tables. (53:00)
- Lab 1:- Basic Fundamentals Database, Tables, rows and columns. (16:14)
- Lab 2:- Primary key, foreign key, referential integrity and constraints. (23:46)
- Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms). (33:35)
- Lab 4: - SQL basics(Select, Insert, Update and Delete) (80:00)
- Lab 5 :- DDL (Data definition language) Queries. (31:33)
- Lab 6: - Transactions, Locks and Isolation level in SQL Server. (68:04)
- Lab 7: - ISNULL and Coalesce functions. (6:16)
- Lab 8: - Row_Number, Partition, Rank and DenseRank (10:49)
- Lab 9: - Triggers, inserted and deleted tables (15:39)
- Lab 10: - Instead of and after triggers. (15:52)
- Lab 11: - Denormalization, OLTP and OLAP. (10:25)
- Lab 12: - Understanding Star schema and Snow flake design. (4:31)
- Lab 13: - SQL Server 8 kb pages. (18:09)
- Lab 14 :- Index and performances (9:55)
- Lab 15 :- Page Split and indexes (8:52)
- Lab 16 :- Clustered vs non-clustered (5:56)
- Lab 17: - Stored procedures and their importance. (24:16)
- Lab 18: - Change Data Capture. (8:40)
- Lab 19: - Explain Columnstore Indexes? (11:22)
- Lab 20: - SQL Server agent (8:40)
- Lab 21: - How can we implement Pivot & Unpivot in SQL Server? (10:27)
C# BEGINNERS & .NET FUNDAMENTALS Q & A (20 HRS)
- C# tutorial for beginners (4 hrs 43 mins) (283:23)
- What is IL code, CLR, CLS & JIT? - Part1 (9 Minutes) (8:31)
- What is IL code, CLR, CLS & JIT? - Part2 (10 Minutes) (10:13)
- Explain JIT,Pre-jit,Eco-Jit,Normal-Jit and NGEN.EXE?(19 Minutes) (18:54)
- What is CAS, evidence, permission set & code groups? (9 Minutes) (9:17)
- What are the changes in .NET 4.0 security model & What is sandboxing?(12 Minutes) (11:53)
- Explain Assembly, EXE and DLL. (9:20)
- Explain App Domain. (16:34)
- What is the difference between managed & unmanaged code? (5 Minutes) (4:28)
- What is Garbage Collector Gen 0, 1 & 2? (10 Minutes) (10:11)
- What is IDisposable interface & finalize dispose pattern in GC? (9 Minutes) (8:27)
- What is the difference between strong and weak references? (11 Minutes) (11:01)
- What is delay signing? (9 Minutes) (9:25)
- Can we see simple example of GAC & How to handle multiple versions in GAC(Binding redirect)? (16 Minutes) (15:43)
- What are different .NET datatypes and its uses according to scenarios? (39 Minutes) (38:38)
- Explain TypeSafe, Casting, Explicit casting and Implicit casting? (12 Minutes) (11:32)
- Explain the sentence "C# strings are immutable"?(Also covers stringbuilder & interning) (22 Minutes) (22:10)
- Explain Synch, Asynch, Delegates, Multicast Delegates and Events. (34:20)
- How can we make Asynchronous method calls using delegates? (5 Minutes) (5:09)
- What are anonymous methods in C#? (12 Minutes) (11:39)
- Why anonymous types are preferred over Tuples? (25 Minutes) (24:38)
- What is the use of Lambda Expression Action, Predicate & Func? (28 Minutes) (28:00)
- What do you mean by Covariance & Contravariance in .NET 4.0? (11 Minutes) (10:56)
- What is the use of checked and unchecked keyword? (7 Minutes) (7:14)
- What is a stack, Heap, Value types and Reference types? (14 Minutes) (13:55)
- What is boxing and unboxing? (10 Minutes) (9:55)
- C# Out Vs Ref. (7 Minutes) (6:42)
- What is optimistic and pessimistic locking? - Part1 (7 Minutes) (6:32)
- Can you explain optimistic locking? - Part2 (12 Minutes) (11:28)
- Can you explain pessimistic locking? - Part3 (15 Minutes) (14:34)
- What are regular expressions & can we see some practical demonstrations? (16 Minutes) (16:09)
- .NET 4.5 feature - Why do we need REGEX timeout? (8 Minutes) (8:02)
- 5 tips to improve your C# debugging.(18 Minutes) (17:42)
- Can you explain Named Parameters, Ref, Out, Volatile & Parsetry? (38 Minutes) (38:08)
- What is the difference between Const & ReadOnly? (8 Minutes) (7:32)
- Explain the difference between "IS" and "AS" keyword? (5 Minutes) (4:38)
- What are Extension Methods? (11 Minutes) (10:32)
- What is #Debug directive? (5 Minutes) (5:13)
- What is the difference between Debug and Release? (8 Minutes) (7:52)
- What is serialization and deserialization? (14 Minutes) (13:50)
- What is the difference between TypeOf and GetType? (7 Minutes) (6:47)
- What is IComparable and IComparer? (16 Minutes) (16:17)
- What is the use of Yield Keyword in C#? (11 Minutes) (10:29)
- What is a C# indexer? (7 Minutes) (6:39)
- What is the difference between == vs .Equals()? (21 Minutes) (21:12)
- When should we override GetHashCode? (27 Minutes) (27:00)
- What are ??(Coalescing operators)? (4 Minutes) (3:52)
- What is C# reflection? (11 Minutes) (11:14)
- What is Dynamic keyword & How does it differ from Reflection? (9 Minutes) (9:19)
- What is the difference between Early binding and Late binding? (4 Minutes) (3:23)
- What is a difference between VAR and Dynamic keyword? (5 Minutes) (5:21)
- What is the use of VAR keyword in C#? (15 Minutes) (14:44)
- What are Circular Dependencies and How to resolve them? (10 Minutes) (9:53)
- How can we mark a method as deprecated? (3 Minutes) (2:42)
- What is the difference between Build VS Rebuild Vs Clean? (6 Minutes) (5:46)
- Importance of bin folder & obj folder in C#. (8:41)
- What is Naming Convention? (8 Minutes) (7:42)
- What is Nuget? (6 Minutes) (5:31)
- What are portable class libraries? (4 Minutes) (3:36)
- What is Asynch and Await keywords? (6 Minutes) (6:14)
- Explain Concurrency VS Parallelism? - (Part 1) (21:30)
- Does Async use threads? - (Part 2) (24:08)
- What are ENUM's and flags in ENUMS? (7 Minutes) (6:26)
- How to convert string to ENUM? (5 Minutes) (5:16)
- How to use MSMQ with C#? (16 Minutes) (15:37)
- Explain NULLABLE Types? (4 Minutes) (3:28)
- Explain NULLABLE Types? (4 Minutes) (3:28)
- Explain C# Attributes? (16 Minutes) (15:45)
- What is AutoMapper? (6 Minutes) (5:58)
- What are DataAnnotations? (10 Minutes) (10:08)
- C# Random numbers. (20 Minutes) (19:40)
- What is .NET Core, DNX, DNU and DNVM? (46 Minutes) (46:02)
- How to work with files and folders (System.IO)? (19:04)
- Explain C# Exceptions ? (24:53)
- Difference between Throw and Throw ex in C#? (6:01)
- Learn Redis Cache in 20 minutes. (18:07)
- POST, GET, PUT, DELETE & PATCH. (22:39)
- Preprocessor Directives/Symbols. (30:01)
- Source Code & PDF
- Introduction to UML (10:24)
- Use Case Diagrams (11:03)
- Class Diagrams (27:05)
- Object Diagrams (4:50)
- Sequence Diagrams (15:24)
- Collaboration Diagrams (7:22)
- Activity Diagram (7:00)
- State chart Diagrams (5:45)
- Component Diagrams (2:48)
- Deployment Diagrams (3:04)
- Stereo Types Diagrams (2:44)
- Package Diagram (4:15)
- UML Project Flow (4:20)
- Practice with Tool (8:53)
- Introduction to UML (10:24)
- Use Case Diagrams (11:03)
- Class Diagrams (27:05)
- Object Diagrams (4:50)
- Sequence Diagrams (15:24)
- Collaboration Diagrams (7:22)
- Activity Diagram (7:00)
- State chart Diagrams (5:45)
- Component Diagrams (2:48)
- Deployment Diagrams (3:04)
- Stereo Types Diagrams (2:44)
- Package Diagram (4:15)
- UML Project Flow (4:20)
- Practice with Tool (8:53)
LEARN DESIGN PATTERNS IN 8 HOURS
- Lab 1:- Design pattern step by step with a project(Factory pattern,Lazy Pattern and RIP Pattern).(60 m (58:45)
- Lab 2:- Unity, Stratergy, IOC, SRP and SOC. (30 minutes) (42:31)
- Lab 3:- Template pattern and Repository pattern with ADO.NET.(60 minutes) (62:56)
- Lab 4: - Adapter Pattern and Repository with EF(60 minutes) (55:22)
- Lab 5: - UOW(Unit of Work)(30 minutes) (35:00)
- Lab 6:- Decorator Pattern (30 Minutes) (29:07)
- Lab 7 :- Iterator Pattern(25 Minutes) (25:13)
- Lab 8:- Prototype and Memento Pattern(25 Minutes) (23:13)
- Lab 9:- Implementing complex object creation using Factory Method(1 Hour) (51:47)
- Lab 10 :- Implementing NULL design pattern and Mediator pattern. (33:28)
- Explain SOLID? (43:15)
- Introduction (10:42)
- Factory and Abstract Factory pattern. (103:56)
- Builder Pattern (8:48)
- Prototype Pattern (8:08)
- Singleton Pattern (4:50)
- Adapter Pattern (5:11)
- Bridge Pattern (12:07)
- Composite Pattern (4:28)
- Decorator Pattern (2:09)
- Facade Pattern (5:29)
- Flyweight Pattern (6:33)
- Proxy Pattern (3:59)
- Mediator Pattern (9:30)
- Memento Pattern (3:59)
- Interpreter Pattern (8:50)
- Iterator Pattern (5:18)
- COR Pattern (8:05)
- Command Pattern (6:29)
- State Pattern (4:47)
- Strategy Pattern (8:13)
- Observer Pattern (8:02)
- Template Pattern (2:42)
- Visitor Pattern (10:51)
- Explain IOC(Inversion of Control)? (10:30)
- Dependency Injection (41:37)
- Fluent interface and method chaining (14:03)
- Lazy Loading (9:39)
- Explain RIP(Replace IF with Polymorphism) Pattern? (4:42)
- Immutable object design pattern (8:25)
- Explain Null Design Pattern and its usage. (18:10)
- What is Microservices Architecture? (25:31)
- Design pattern Source Code
- Source Code for Java
LEARN SHAREPOINT 2013 STEP BY STEP
- Lab 1 :- Basics, Sitecollection, Subsite, Page, List and Document Library. (47:35)
- Lab 2 :- User, User group and Permissions. (19:02)
- Lab 3 :- Master Page Customization in SharePoint. (32:27)
- Lab 4 :- Site Columns and Content Types. (20:34)
- Lab 5 :- Integrating MVC with SharePoint (Part 1). (25:50)
- Lab 6 :- Integrating MVC with SharePoint - Part 2 (Consuming List). (31:37)
- Lab 7 :- Integration with MVC(SharePoint Hosted Model, CSOM and JSOM). (30:21)
- What is SharePoint, SharePoint foundation & SharePoint server 2010? (SharePoint 2010) (17:07)
- How to create a simple website in SharePoint? - Part 1 (SharePoint 2010) (25:20)
- How to create a simple website in SharePoint? - Part 2 (SharePoint 2010) (32:54)
- How can we create users and permissions in SharePoint 2010? (SharePoint 2010) (21:50)
- How to deploy custom webparts in SharePoint pages? (SharePoint 2010) (23:22)
- How do we customize SharePoint pages using SharePoint designer? (SharePoint 2010) (30:50)
- How can we debug SharePoint errors? (SharePoint 2010) (12:46)
- Can you explain (SOM)SharePoint Object Model? (SharePoint 2010) (34:44)
- How can we create custom ASP.NET screen to insert & display operations on SharePoint list? (SharePoint 2010) (15:42)
- What is the use of INFOPATH? (SharePoint 2010) (16:50)
- How to read and write data to SharePoint 2010 from remote locations? (SharePoint 2010) (15:03)
- What is the use of Business Connectivity Services(BCS)? (SharePoint 2010) (13:16)
- SharePoint 2013 Training Part - 1. (105:58)
- Sharepoint Training 2 ( MVC With Sharepoint Integration). (30:23)
- Business Connectivity Services (Sharepoint) - Part 3. (47:38)
- Workflow with SharePoint - Part 4. (37:03)
- WWF with Sharepoint using VS Part 5. (49:55)
- CAML Queries (Part - 6) (31:56)
- InfoPath and Event Receivers (Part - 7) (38:57)
- Introduction to .NET Projects (10:28)
- Different levels of Programming (6:32)
- Necessary Tools (4:35)
- What should we learn ? (4:05)
- The IIS (10:01)
- Making UI using .NET IDE (16:00)
- Database, The SQL Server (20:03)
- Connecting ASP.net with Database (22:59)
- Loading the Data Grid (10:11)
- Update and Delete (9:55)
- Validations (7:00)
- Issue with the Code (5:26)
- Two Tier Architecture (15:26)
- Three Tier Architecture (8:42)
- Database Normalization (9:32)
- Session and State Management (8:36)
- Using Enterprise Application Block (4:18)
- Aggregation and Composition (6:19)
- Implementing Interfaces and Factory (18:17)
- Inheritance relationship (7:36)
- Abstract Class Implementation (6:34)
- How to open source code in Visual Studio?
- .NET Projects Source Code
GENERICS/.NET COLLECTIONS Q & A
- What are the different types of collections in .NET?- Part 1 (6:17)
- What is the difference between Array & ArrayList?- Part 2 (10:57)
- Can you prove why arrays are faster than arraylist?- Part 3 (5:37)
- What are the problems with arraylist & how can we solve the same by Hashtables?- Part 4 (5:21)
- What are stacks & queues?- Part 5 (7:08)
- What are special collections?- Part 6 (7:37)
- What are Generics & What are generics collections?- Part 7 (9:23)
- What are generics collections?- Part 8 (9:01)
- What is the use of IEnumerator, ICollection, IDictionary & IList?- Part 9 (20:47)
- What is the difference between IEnumerable and IEnumerator? (13:38)
- Differentiate between IEnumerable vs IQueryable? (7:15)
- Explain Generics Constraints? (3:55)
MICROSOFT POWER BI FOR BEGINNERS
- Learn Power BI Step by Step:- Beginners (54:40)
- Lab 2:- Connecting SQL Server with Power BI. (12:09)
- Lab 3:- Line, Area, Stacke, API, Gauge and Funnel. (13:57)
- Lab 4 :- Star Schema and Snow flake design (17:49)
- Lab 5 - DAX(Data Analysis Expression) in Power BI(Part 1). (31:45)
- Lab 6 - Dax(Data Analysis Expression) - Part 2. (36:30)
MYSQL INTERVIEW QUESTIONS WITH ANSWERS
- Explain Normalization, Denormalization, Normal Forms in MySQL, Trigger & Joins.
- ENUM in mysql, GRANT Command, TRUNCATE vs DELETE in MySQL
- MYSQL Questions & Answers PDF
- What are Stored Procedure & Stored Function in MySQL?
- What is self-referencing foreign key, LIKE vs REGEXP Operators, query cache in
- Questions on SAVEPOINT statement, import/export work in MySQL, IFNULL & ISNULL
- What is SOA, Services and Messages (Part 1)? (8:21)
- What is SOA, Services and Messages (Part 2)? (6:33)
- What is the difference between Service and Component? (4:43)
- What are basic steps to create a WCF service (Part I, Creating the Service)? (14:37)
- What are basic steps to create a WCF service (Part II, Consuming the Service)? (7:55)
- What are endpoints, address, contracts and bindings? (7:11)
- What are various ways of hosting WCF service? (8:03)
- What is the difference of hosting a WCF service on IIS and Self hosting? (5:36)
- What is the difference between BasicHttpBinding and WsHttpBinding? (9:38)
- How can we do debugging and tracing in WCF? (8:27)
- Can you explain transactions in WCF (theory)? (5:06)
- Can we see a simple example of WCF transactions? (10:28)
- How can we self host WCF service ? (7:49)
- What are the different ways of implementing WCF Security? (9:00)
- How can we implement SSL security on WCF(Transport Security)? (10:26)
- How can we implement transport security plus message security in WCF? (10:14)
- How can we do WCF instancing ? (15:13)
- How Can we do WCF Concurency and throttling? (16:41)
- Can you explain one way & duplex(two way) contract in WCF? (11:12)
- Can you explain one way & duplex(two way) contract in WCF?- Part 2 (16:50)
- What exactly is WCF REST service? (12:55)
- What exactly is WCF REST service?-Part 2 (26:39)
- What are WCF fault exception? (6:00)
- How to host Multiple endpoint in a single WCF Service? (12:20)
- What is netMSMQBinding in WCF? (8:49)
- Source Code
- MSBI Training Part 1-28-02-2021 (102:48)
- MSBI Training Part 2-07-03-2021 (96:58)
- MSBI Training Part 3-15-03-2021 (97:09)
- MSBI Training Part 4-04-04-2021 (97:34)
- MSBI Training Part 5-11-04-2021 (92:20)
- MSBI Training Part 6-18-04-2021 (43:30)
- MSBI Training Part 7-25-04-2021 (59:13)
- Software Development Life Cycle(SDLC). (5:02)
- Estimation (5:02)
- Requirement Technical and Testing. (7:56)
- SDLC Source Code
- Django Introduction and startup with application (30:39)
- Pre-requisite and Installing PyCharm-IDE (5:40)
- Dynamic Content in DJango (10:44)
- What are Query Parameters in Django? (14:06)
- What are Path Parameters in Django? (17:07)
LEARN DATA STRUCTURE AND ALGORITHM
- Data structure tutorial - Lab 1. (61:16)
- Chapter 1 : Basic definitions , BIG O and LinkList data structure-13th April 2020 (56:04)
- Chapter 2 :- Double linklist and Binary tree DS -15th April 2020 (59:21)
- Chapter 3 :- Binary tree DS- 21st April 2020 (42:26)
- Chapter 4 :- Graph data structure ,BFS and DFS - 23rd April 2020 (47:08)
- Chapter 5 :- Sorting Algorithms - Bubble , Inserted and Selection. - 28th April 2020. (35:57)
- Chapter 6 :- Merge Sort DS - 12th May 2020 (45:39)
- Chapter 7 :- Quick sort and Dijkstra Algorithm DS - 16th May 2020 (25:31)
- Chapter 8 :- Dijkstra Algorithm and BellMans Ford DS - 22nd May 2020 (40:37)
- Chapter 9 :- Kadanes Algorith and Flyod Detection loop DS - 26th May 2020 (47:21)
- Chapter 10 :- Queue and Stack Data structure and Flood Fill algorithm DS -02nd June 2020 (37:07)
- Chapter 11:- Hashing algorithm, Open space and Linking strategy -09th June 2020 (51:40)
- Chapter 12 :- Huffman compression,Knapsack fraction and 0/1 -23rd June 2020 (48:58)
- Chapter 13 :- Tower of Hanoi problem - 30th June 2020 (28:47)
- Chapter 14 :- Travelling sales man logic using C# -08th July 2020 (42:10)
- Data Structure and Algorithm Using C# Source Code
OOP'S Q & A VIDEO SERIES (3:30 HRS)
- What is the problem with Functional Programming? (8 Minutes) (7:55)
- Can you define OOP and the 4 principles of OOP? (10 Minutes) (9:40)
- What are Classes and Objects? (5 Minutes) (4:33)
- What is Inheritance? (4 Minutes) (4:09)
- What is Polymorphism, overloading, overriding and virtual? (11 Minutes) (10:48)
- Can you explain encapsulation and abstraction? (12 Minutes) (11:52)
- What is an abstract class? (9 Minutes) (8:49)
- Define Interface & What is the diff. between abstract & interface? (10 Minutes) (10:01)
- Define Interface & Diff. between abstract & interface? - Part 2 (8 Minutes) (7:38)
- What is the use of Shadowing in C#? (11 Minutes) (10:43)
- Can we implement interfaces with same method names in C#? (8 Minutes) (7:57)
- What is the use of Static Keyword? (31 Minutes) (31:21)
- What is the difference between Abstraction and Encapsulation? (11 Minutes) (10:54)
- What are partial classes & partial methods? (13 Minutes) (12:30)
- Can we see implementation of Association, Aggregation & Composition in real world? (24 Minutes) (23:41)
- What is operator overloading? (10 Minutes) (9:34)
- Explain Access modifiers (Private, Public, Protected, Internal & Protected/Internal)? (19 Minutes) (18:32)
- OOPs Interview Assessment
LEARN DYNAMICS CRM STEP BY STEP
- Lab1: - What is CRM and how does it work? (14:42)
- CRM Training:- 11-01-2015 (26:31)
- Recording for CRM Training - 25th Jan 2015. (48:53)
- Recording for Windows Workflow CRM Training - 7th Feb 2015. (52:47)
- Recording for Dialog Workflow CRM Training - 8th Feb 2015. (32:27)
- Recording for CRM Service Training - 14th Feb 2015. (16:44)
- Recording for CRM Training - 17th & 18th Jan 2015 (45:05)
- Relationship Entities CRM Conducted on 7th March 2015 (94:38)
- Dynamic WCF for CRM Training conducted on 8th Mar 2015 (21:48)
- Dynamic Audit in CRM Training conducted on 14th Mar 2015 (19:12)
- Security & Reporting in CRM Training conducted on 28th Mar 2015 (21:06)
- Dynamic CRM Training on Site Map conducted on 11th April 2015. (20:38)
- CRM Training on Export Import Data Mapping and Queues conducted on 19th April 2015. (34:05)
- Lab 1: - Explain Jquery with a simple example? (5:23)
- Lab 2: - Explain CDN Fallback? (7:19)
- Lab 3: - Explain Document.Ready in jQuery? (4:48)
- Lab 4: - What are the 7 important ways of doing selection in jQuery? (7:41)
- Lab 5:- Explain JSON ? (5:08)
- Lab 6: - How to emit JSON using MVC ? (12:34)
- Lab 1: - What is WPF and how it is better than Winforms? (26:01)
- Theory: - Explain WPF object hierarchy? (5:46)
- Lab 2: - How to implement threading in WPF? (6:16)
- Lab 3: - Explain one way, two way, one time & one way to source bindings? (8:35)
- Lab 4: - Explain UpdateSourceTrigger in WPF? (7:07)
- Lab 5: - Explain WPF Resources? (5:09)
- Lab 6: - What are WPF Value Converters? (7:15)
- Lab 7: - Explain WPF multibindings and multivalueconverters? (10:36)
- Lab 8: - Explain logical tree, visual tree,routed events( Direct, Tunneling and Bubbling)? (14:59)
- Lab 9: - What are WPF commands and INotifyPropertyChange interface? (27:26)
- Lab 10: - Explain MVVM with a simple example(With binding)? (33:55)
- Lab 11: - What is the need of INotifyPropertyChanged interface in MVVM?(MVVM With INotify) (11:51)
- Lab 12: - Explain importance of commands in MVVM(MVVM with Commands)? (18:10)
- Lab 13: - How to decouple commands from view model(MVVM reusable commands)? (8:38)
- Lab 14: - How to refresh MVVM commands? (3:45)
VSTS TESTING Q & A (UNIT, LOAD, AUTOMATED)
- What is Unit Testing & can we see an example of the same(VSTS 2008)? (11:25)
- How can we write data driven test using NUNIT & VS Test(VSTS 2008)? (10:32)
- Can we see simple example of a unit test for database operation(VSTS 2008)? (9:32)
- How can we do automated testing using Visual Studio Test(VSTS 2008)? (9:39)
- How can we do Load Testing using VSTS test(VSTS 2008)? (12:33)
- Can you explain database unit testing(VSTS 2008)? (4:01)
- How can we do test coverage using VSTS system(VSTS 2008)? (3:36)
- How can we do manual Testing using VSTS 2008? (2:14)
- What is Ordered Test in VSTS test(VSTS 2008)? (2:30)
- How to generate test data using VSTS 2010? (11:07)
- What are different test in VSTS 2010 and how to write unit test in VSTS 2010? (18:09)
- How to do UI automation testing using VSTS 2010 coded UI test? (21:11)
- How to run coded UI test with dynamic data using VSTS 2010? (18:49)
- How can we do web testing on ASP.NET application using VSTS 2010? (19:54)
- How to use WaitCommands in Coded UI test? (12:52)
- How to do Load test & database test using VSTS 2010? (15:55)
- In what scenarios do we use ordered testing in VSTS 2010? (10:16)
- How to implement TDD(Test Driven Development) in C#? (17:27)
- What is Mock Testing? (12:35)
- How to test Private methods in VSTS test? (7:23)
- How can we do complex unit testing(Code contracts)? (17:31)
- Explain CodeLens? (10:24)
- What is the use of Session and Viewstate in ASP.NET? (10:17)
- What is the difference between session & viewstate? (19:43)
- Can you explain ASP.NET application and Page life cycle - (Part 1)? (7:54)
- Can you explain ASP.NET application and Page life cycle - (Part 2)? (7:11)
- Can you explain ASP.NET application and Page life cycle - (Part-3)? (14:59)
- What is a PostBack, IsPostBack and AutoPostBack in ASP.NET? (6:54)
- What is Authentication, Authorization, Principal & Identity objects? Part-1 (7:19)
- ASP.NET Authentication and Authorization Video series Part-2 (8:56)
- ASP.NET Authentication and Authorization Video series Part-3 (12:14)
- ASP.NET Authentication and Authorization Video series Part-4 (14:55)
- ASP.NET Authentication and Authorization Video series Part-5 (9:34)
- ASP.NET Authentication and Authorization Video series Part-6 (14:55)
- What are Master pages? (9:46)
- What is Instrumentation, Debugging & Tracing? Part-1 (10:07)
- What is Instrumentation, Debugging & Tracing? Part-2 (11:59)
- What is Instrumentation, Debugging & Tracing?Part-3 (13:58)
- What is Routing in ASP.NET(URL rewriting)? (8:38)
- What is Web server and IIS(Internet Information Services)? (4:16)
- Server.Transfer VS Response.Redirect (13 Minutes) (12:27)
- Explain PreserveForm and EndResponse? (6:58)
- Can we have 2 web.config files? (5:48)
- Label Vs Literal (7 Minutes) (6:28)
UNDERSTANDING OOPS IN REAL PROJECT
- Interface (8:34)
- Abstraction and Encapsulation (9:39)
- Parent-Child relationship (5:48)
- Aggregation and Composition (6:27)
- Polymorphism (7:49)
- Difference between Interfaces and Abstract Classes (4:02)
- Abstract Classes (4:48)
- What are performancecounter and perfmon tool? (9:56)
- Finding high memory consuming functions - Part I (11:35)
- Finding high memory consuming functions - Part II (10:31)
- Improve garbage collector performance using finalize/dispose pattern (10:07)
- How to use performance counters to gather performance data - Part 1 (10:07)
- How to use performance counters to gather performance data - Part 2 (7:11)
LOCALIZATION/GLOBALIZATION Q & A
- What is Globalization and Localization? - Part 1 (17:09)
- How can we set explicit culture? - Part 2 (9:00)
- What is the difference between Culture and UI Culture? - Part 3 (4:36)
- How to store localized data in SQL Server? - Part 4 (7:30)
- What is LINQ and can you explain same with example? (11:05)
- Can you explain a simple example of LINQ to SQL? (6:31)
- How can we define relationships using LINQ to SQL? (6:58)
- How can we optimize LINQ relationships queries using DataLoadOptions? (7:52)
- Can we see a simple example of how we can do CRUD using LINQ to SQL? (7:30)
- How can we call a stored procedure using LINQ? (5:19)
- Source Code for LINQ
- (Day 1)Lab 1: - Creating your first program (6:42)
- (Day 1)Lab 2: - Creating your first program (5:16)
- (Day 1)Lab 3: - Integer DataType (4:41)
- (Day 1)Lab 4: - Exception Handling (4:49)
- (Day 1)Lab 5: - IF Condition, Return Try/Catch (4:44)
- (Day 2)Lab 6: - Commenting (3:28)
- (Day 2)Lab 7: - For Loop (7:11)
- (Day 2)Lab 8: - Creating a simple calculator program (7:05)
- (Day 3)Lab 9: - Creating your first Windows application (11:54)
- (Day 3)Lab 10: - Creating the Customer Screen (19:25)
- (Day 4)Lab 11: - Displaying Customer Screen (20:31)
- (Day 4)Lab 12: - Multiple Document Interface(MDI) (9:53)
- (Day 5)Lab 13: - Classes & Objects (14:36)
- (Day 6)Lab 14: - Getting Data from SQL Server (21:02)
- (Day 7)Lab 15: - Inserting data into SQL Server (24:10)
- (Day 7) Lab 16: - Storing connection string in App.config files (7:39)
- (Day 8) Lab 17: - Delete Functionality (25:33)
- (Day 9) Lab 18: - Update Functionality (11:38)
- (Day 9) Lab 19: - 2 Tier Architecture (29:12)
- (Day 10) Lab 20: - Creating a web application (17:51)
- (Day 10) Lab 21: - Connect WebApp to Data Access Layer (12:23)
- (Day 11 & 12) Lab 22: - Implementing Insert, Update & Delete (20:06)
- (Day 13) Lab 23: - Implementing 3 Tier Architecture (54:38)
- (Day 14) Lab 24: - Security (23:58)
- (Day 15) Lab 25: - Web Security (12:40)
- (Day 16) Lab 26: - REGEX (23:45)
- (Day 17) Lab 27: - Improving Database Design (33:47)
- (Day 18)Lab 28: - 1 to many relationship (29:03)
- (Day 19)Lab 29: - 1 to Many(Insert) (32:56)
- (Day 20)Lab 30: - 1 to Many(Select & Delete) (33:11)
- (Day 21)Lab 31: - 1 to Many(Update) (19:04)
- (Day 22)Lab 32: - Stored Procedure (24:20)
- (Day 23)Lab 33: - Reusability (18:35)
- (Day 24)Lab 34: - Application and Cache in ASP.NET (16:28)
- (Day 25)Lab 35: - Sessions in ASP.NET (11:38)
- Day 26 to Day 60: - Project (6:23)
- Visual Studio Tips & Tricks No. - 1 (1:39)
- Visual Studio Tips & Tricks No. - 2 (2:37)
- Visual Studio Tips & Tricks No. - 3 (2:04)
- Visual Studio Tips & Tricks No. - 4 (4:01)
- Visual Studio Tips & Tricks No. - 5 (2:06)
- Visual Studio Tips & Tricks No. - 6 (1:11)
- Visual Studio Tips & Tricks No. - 7 (2:57)
- Visual Studio Tips & Tricks No. - 8 (4:16)
- Visual Studio Tips & Tricks No. - 9 (4:37)
- Visual Studio Tips & Tricks No. - 10 (5:28)
- Visual Studio Tips & Tricks No. - 11 (5:01)
- Visual Studio Tips & Tricks No. - 12 (5:46)
- Visual Studio Tips & Tricks No. - 13 (5:37)
- Visual Studio Tips & Tricks No. - 14 (3:26)
- Visual Studio Tips & Tricks No. - 15 (4:19)
- Visual Studio Tips & Tricks No. - 16 (4:13)
- Visual Studio Tips & tricks No. - 17 (Remove Unused Namespaces) (2:34)
- Visual Studio Tips & Tricks No. - 18 (4:39)
- Visual studio and .NET tips & tricks No - 19 (Create properties easily) (2:40)
- Visual Studio Tips & Tricks No. - 20 (2:52)
- Visual studio Tips & Tricks No. - 21: - (Show external files in Visual studio) (3:30)
- Visual studio Tips & Tricks No. - 22: - Refresh all browsers from Visual studio (3:23)
- Visual studio Tips & Tricks No. - 23: - (Peek Definition) (1:58)
- Visual studio Tips & Tricks No. - 24: - (Autos Window) (7:10)
- Visual studio Tips & Tricks No. - 25: - What is need of [DebuggerStep Through]? (2:50)
- Why and when we need Knockout.js with help of an example? (35:53)
- What are Bindings in KO? What are different kind of Bindings & how to work with them? (23:57)
- What are & why we need observable property in KO? (10:16)
- What are computed observable in KO? (17:49)
UNDERSTANDING SOFTWARE ARCHITECTURE WITH REAL TIME PROJECT EXAMPLES
- Scenario 1: - Customer & Logger class Scenario (SRP Violation) (4:04)
- Solution for Scenario 1: - Implementing SRP with factory class & interfaces (19:55)
- Scenario 2: - Add new customer type scenario (OCP violation) (5:51)
- Solution for Scenario 2: - Applying OCP (Open closed principle) by using inheritance (14:33)
- Scenario 3: - The batch printing problem(LSP violation) (11:09)
- Solution for Scenario 3: - Applying LSP (Liskov principle) using interfaces & solving the problem (13:43)
- Scenario 4: - The tax calculator scenario(DI/IOC) (15:21)
- Solution for Scenario 4: - Using unity application using DIIOC (28:52)
- How to write FizzBuzz logic in C#? (3:53)
- EvenOddlogic (7:45)
- Oneliner Excel Sheet
- Sample Resume(NEW)
- Sample Resume(OLD)
- Lesson 1:- Xamarin Basic. (12:58)
- Lesson 2 :- Activity, Resources and Assets. (18:59)
- Lesson 3:- Xamarin Android Activity life cycle . (14:26)
- Lesson 4 :- Dialog boxes and Intents in Xamarin. (13:10)
- Lesson 5 :- Multiforms and passing data between them. (14:58)
- Lesson 6:- Debugging real physical phones. (6:41)
- Lesson 7 :- Services, Implicit & Explicit Intent. (17:11)
- Lesson 8 :- Gestures , Multitouch and Pinch. (32:25)
VS 2010 , ASP.NET 4.0 AND .NET 4.0
- What is Package and One click deploy(Deployment Part - 1)? (14:01)
- What is Web.config transformation (Deployment Part - 2)? (9:24)
- What is MEF and how can we implement the same? (10:37)
- How is MEF different from DIIOC? (5:56)
- Can you show us a simple implementation of MEF in Silverlight? (7:27)
- What is TFS and explain its architecture? (8:21)
- How can we integrate software life cycle in TFS? (38:45)
MACHINE LEARNING WITH C#(ML.NET)
- Lab 1 : - ML.NET C# 1 hour training. (47:33)
- C# Machine learning using ML.NET Part:- 1 - 08th Feb 2020 (46:14)
- C# Machine learning using ML.NET Part:- 2 - 09th Feb 2020 (53:18)
- How to install SignalR & JSON2 on VS2010? (3:47)
- Chat Application: - How to create and connect to HUB? (10:33)
- How to create a Server/Client Method and pass parameters? (12:13)
- How to create Chat application using SignalR? (16:44)
- Explain onconnected and ondisconnected methods of SignalR? (4:31)
- Explain Context, Clients & Groups properties of SignalR? (25:01)
- Explain Group/OthersInGroup of object Clients & show how to send messages to different Groups? (7:09)
- What is round triping state in SignalR? (4:32)
- How to broadcast a message from outside the HUB? (10:26)
- How to do performance tuning in ASP.NET SignalR? (3:30)
- How to develop a simple game in SignalR? (3:47)
- Source Codes
- What are Adapters, Pipeline, Maps and Ports? (13:20)
- Can you explain the Biztalk environment? (37:21)
- What is BizTalk and when to use Biz Talk? (7:05)
- How to create a schema in BizTalk? (36:15)
- How to create a map in Biztalk? (11:24)
- How can we create orchestration in Biztalk? (23:37)
- How can we build/publish in Biztalk? (14:01)
- How to do configuration in Biztalk? (20:23)
- BizTalk9HowtoexecuteandTest (15:35)
- Introduction (4:12)
- Validation Application Block (19:42)
- Logging Application Block (14:17)
- Exception error Handling (19:41)
- Data Application Block (6:12)
- Caching Application Block (10:05)
- Security Application Block (16:10)
- Policy Injection Application Block (6:55)
- Unity Application Block (41:37)
- Enterprise 4.0 Setup
- DI Unity Source Code
- What is ADO.NET, Connection, Command & Datareader objects? (18:00)
- What is Dataset & DataAdapter in ADO.NET? (6:45)
- What is ADO.NET Connection Pooling? (15:59)
- What is Threading in C#.NET? (12:15)
- How can we make a object thread safe using LOCK in multithreading? (8:56)
- What is Mutex, Semaphore & SemaphoreSlim? (11:39)
- What is AutoResetEvent and ManualResetEvent? (11:13)
- What is Thread Pooling? (13:34)
- How to debug Threads? (10:49)
- What is TPL (Task Parallel Library) and how different it is from threads? (25:11)
- What are High level and low level languages ? (6:29)
- How to install .NET framework and write a hello world program? (10:00)
- From where do I get visual studio ? (4:02)
- How write a simple hello world program using visual studio? (5:29)
- How to run certain activites on ASP.NET AJAX? (13:18)
- What is AJAX and explanation about the Client Side Technology? (12:51)
- What are the AJAX Server Side Technologies and AJAX Server Controls? (27:49)
- How to consume WebServices in Ajax? (8:09)
- AJAX Source Code
PRACTICAL CODE REVIEWS USING STYLECOP
- StyleCOP Video (13:22)
- StyleCOP Setup Download
- StyleCOP source code
- Introduction (11:00)
- Application Boundary (3:32)
- EI Fundamentals (19:51)
- EO Fundamentals (5:46)
- EQ Fundamentals (2:19)
- EIF Fundamentals (2:12)
- ILF Fundamentals (3:09)
- GSC Fundamentals (5:10)
- Productivity Factor (1:59)
- Costing (5:55)
- Function point Template (12:48)
- Estimating a sample project (12:48)
- Function point Estimation Excel
- Customer maintenance
- What is Entity Framework(Theory)? (7:08)
- Lab 1: - What is EDMX, Context and Models in EF? (14:17)
- Lab 2: - How to read,insert,update and delete data using EF (Entity framework)? (10:08)
- Lab 3: - How to insert custom business validation in Entity classes? (7:43)
- Lab 4: - What are POCO Classes? (9:38)
- Lab 5: - How to implement code first? (11:48)
- Lab 6: - How to solve concurrency issues in EF(Optimistic locking)? (14:05)
- Lab 7: - What is Clientwins and StoreWins in Entity framework? (6:15)