-
MS SQL Server
13 Lessons-
StartDay 2 - Introduction To RDMS An Create - Database - Table - Primary key - Unique Key - Identity Column - Default Value - Check Constraint
-
StartDay 3 - Data Types In SQL Server - Table Design Techniques - (Primary Key - Foreign Key) Relationship
-
StartDay 4 - Update And Delete Constraints On FK - Introduction To T-SQL - Insert - Delete Vs Truncate - Update (Last-In Win and Optimistic Concurrency Control)
-
StartDay 5 - Select - Aliasing - Derived Columns - Sorting(Order by multiple cols, Top)
-
StartDay 6 - Filtering(Where, in, not in, between, not between, is null, soundex) - Scalar String Function
-
StartDay 7 - ( Casting - Mathematical - Aggregate - DateTime ) Functions
-
StartDay 8 - Group By - Having Clauses - Joins - inner - left outer - right outer - full outer
-
StartDay 9 - The 3 Key Rules Of Database Design Techniques - Writing Join Queries On 3 or More Tables - Understanding Toy Stock Management SystemThe Complex Database Structure
-
StartDay 10 - Simple Sub Queries(Scalar, Multi Valued) - Nested Sub Queries - Corelated SubQueries - CTE
-
StartDay 11 - Views - DML On Views - Stored Procedures -With Input And Output Parameters -If Else And Else If Ladder
-
StartDay 12 - Functions - Try ... Catch - Transactions
-
StartDay 13 - Realtime Scenarios For Transaction - Scope_Identity() - Triggers Introduction
-
StartDay 14 - Triggers - Inserted and Deleted Temp Tables - Self Join - Union Concept - DB BackUp - DB Restore - DBScript - Db Design Tasks
-
-
C#.Net Basic Programming
5 Lessons-
PreviewDay 15 - Introduction to C# With Basic Operations - Type Casting - String Formatting - Debugging
-
PreviewDay 16 - Introduction To Data Types - var Vs dynamic - Control Structures - if else -else if Ladder
-
StartDay 17 - Switch Case Default - Lamda Expression - for Loop - do While Loop
-
StartDay 18 - Ternary Operator - Array - foreach Loop - 2D Arrays - Guess A Number Game
-
StartDay 19 - Structures In Depth - Methods - String Split
-
-
C#.Net Object Oriented Programming
5 Lessons-
StartDay 20 - Object - Class - Fields - Methods - Access Specifiers - Public - Private - Constructors
-
StartDay 21 - Constructor OverLoading - Method OverLoading - Compile Time or Static Time Polymorphisim - this KeyWord - Optional Param By Setting Default Values - Naming Convention Instead of this keyword
-
StartDay 22 - static (variables-constructors-methods-classes) - use of dynamic variable - returing multiple parameters using (tuples-out Param-ananoymus Object -Object)
-
StartDay 23 - namespaces - nested namespaces - using concept - global namespaces - creating and using dll in Console And WinUI - internal and public classes
-
StartDay 24 - Theory Of .Net - Assemblies (exe and dll)
-
-
C# Advanced Object Oriented Programming
5 Lessons-
StartDay 25 - Single Level - Multi Level - C# Does Not Support Multiple Inheritance - protected Members - Method Overriding - two uses of base keyword - constructor chaining
-
StartDay 26 - sealed method - sealed class - abstract methods and class - Runtime Polymorphism Explained In Depth
-
StartDay 27 - Properties In Depth - Extension Methods - Object Class
-
StartDay 28 - Partial Classes - Interfaces - Collection Classes - Generic Collection Classes
-
StartDay 29 - Introduction To LINQ - Exception Handling InDepth
-
-
Entity Framework Core
7 Lessons-
StartDay 30 - Getting Started With EF Core 8 in 6 Easy Steps
-
StartDay 31 - Updating Database Structure using Migration Files
-
StartDay 32 - DataAnnotations - Class Design Techniques - OneToMany And ManyToMany
-
StartDay 33 - CRUD In EF - First() Vs FirstOrDefault() Vs SingleOrDefault() - (IList Vs IEnumerable) Iterator Design Pattern - Navigation Property
-
StartDay 34 - Immediate Mode Vs Deferred Mode - IList Vs IEnumerable Vs IQueryable - Iterator Design Pattern - Eager Loading (Include(),ThenInclude()) - Explicit Loading - Lazy Loading
-
StartDay 35 - Auto And Manual Transactions - RAW SQL with Custom Return Type
-
StartDay 36 - Raw Sql - Stored Procedures -Layered Arch - FormsUI - Repository Pattern
-
-
ASP.Net MVC Core 8
14 Lessons-
PreviewDay 37 - Introduction to Web Application And ASP.Net Core MVC (Theory)
-
StartDay 38 - Getting Started With ASP.Net Core Static Web Site And Integrating An Existing Free HTML Template (Need An Update on Aodio Quality)
-
StartDay 39 - Introduction To MVC - Initial Setup - Controller - Actions - Views - IActionResult
-
StartDay 40 - GetVsPost - Parameter Passing Mechanism - Razor View Engine - ViewData Vs ViewBag - TempData
-
StartDay 41 - TempData In Depth - Employee Form - HttpGet - HttpPost - Form Redesign WothHTML Helper Classes - Select List
-
StartDay 42 - Integrating EF In MVC - Data Seeding - Model Binding - CRUD operations (Read and Create)
-
StartDay 43 - CRUD operations (Update and Delete) - Tag Helpers - Form Validation (Server Side and client Side) - Custom Validator - Async Actions - Scaffolding - Bootstrap
-
StartDay 44 - ViewImports - ViewStart - Layout (Master Page)
-
StartDay 45 - Creating Project Structure To Get Started With MVVM
-
StartDay 46 - MVVM For One To Many Relationship
-
StartDay 47 - MVVM For Many To Many Relationship In Depth
-
StartDay 48 - GC - Managed and Unmanaged Resources- Dispose() - using - IDisposable - Dependency Injection
-
StartDay 49 - Introduction - To Authentication And Authorization - Configuration Of IdentityDbContext - Registration - Login - Logout - Authorize and AllowAnonymous
-
StartDay 50 - Authorization - User-IsInRole() - Dynamic Theme - jQuery Data Table - Sorting - Searching - Paging
-
-
ASP.Net MVC Core 8 Live Project
7 Lessons-
StartDay 51 - Introduction To LinkHub Project - DAL - Extending IdentityUser - Fluent APIs - Repository Pattern
-
StartDay 52 - Creating MVC UI Project Setup - Injecting User Defined Objects (Transient, Scoped and SingleTone) - Async Repository Pattern - Unit Of Work
-
StartDay 53 - UI - Creating Areas - Full Project Flow Screens - Submit URL
-
StartDay 54 - Full Project Flow Screens - Approve URLs - Browse URLs - Tab Container
-
StartDay 55 - Implementing Authentication and Authorization - Register, Login and Logout - Get Logged In User - DropdownList Cascade
-
StartDay 56 - JQuery Based Ajax Calls CRUD - DataTable In Depth - Modal Popup - Approve All
-
StartDay 57 - Responsive Datatable - Exception Handling - Handling Page Not Found - appSettings Connection String - Creating Roles And Users Dynamically - Hosting Db And Project Live
-
