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)
- 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)
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
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)
- 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)
- 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
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)
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
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)
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)
- 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 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)
- 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
- Oneliner Excel Sheet
- Sample Resume(NEW)
- Sample Resume(OLD)