-
MS SQL Server 2017
9 Lessons-
PreviewDay1 - Introduction To MS SQL Server 2017-DbCreation-PrimaryKey-UniqueKey
-
PreviewDay2 - Foreign Key-Delete-Update-Constraints-DbDesign-Techniques
-
PreviewDay3-Insert-Delete-Update-Select-Expressions-Cases
-
StartDay4-ITWorkShopDbDesign-Orderby-ScalarFunctions
-
StartDay5-Aggregate-DateTimeFunction-GroupBy-Having-Joins
-
StartDay6-Join On 3 Tablels-SelfJoin-Unions
-
StartDay7-SubQueries-CorrelatedSubQueries-CTE-Views-StoredProcedures
-
StartDay8-Functions-Transactions-SalaryHistory-ScopeIdentity
-
StartDay9-Triggers-AdminTasks
-
-
C#.Net Core
10 Lessons-
PreviewDay1-Introduction-To-CShrap-DotNetFrameworkVsDotNetCore
-
PreviewDay2-ControlStructures (IfElse-SwitchCase-For-While)
-
StartDay3-Loops-Arrays-Structures-ArrayOfstructures
-
StartDay4-varVsDynamic-Class-Object-Method-Constructor-ConstructorOverloading
-
StartDay5-this-method Overloading-Optional-Properties-Static
-
StartDay6-Namespaces-Dlls-PublicAndInternalClasses-DotNetStandardLibrary-OMS
-
StartDay7-Inheritance, Protected, MultiLevel, Constructor Chaining, base, Method Overriding, virtual, over
-
StartDay-8 abstract Method, abstract Class, runtime polymorphism, Is-A, Has-A, sealed Method, Sealed Class
-
StartDay10-Interfaces-Partial Classes-Collection-Genric-Stack-Queues-ArrayList-List-StructVsClasses-ValueTy
-
StartDay11-ListOfObjects-LINQ-HasARelationship-ExceptionHandling
-
-
Entity Framework 3.1
9 Lessons-
PreviewDay1-IntroductionToEF-Entity-DbContext-DbSet-Migration-Creating-Database
-
PreviewDay2-DatabaseUpdateMigrations-ClassDesingingTechniques-DataAnnotations
-
StartDay3 - CRUD Operations-First-FirstOrDefault-Single-SingleOrDefault
-
StartDay4-ComplexClassDesigning-InverseProperty-NavigationProperty
-
StartDay 5 - IList Vs IEnumerable Vs IQueryable And Eager Loading Vs Explicit Loading Vs Lazy Loading Vs Circular Refrencing Problem
-
StartDay6-EagerLoading-ComplexDataStructures-IncludeVsThenInclude-RawSQL
-
StartDay7-StoredProcedures-Transactions
-
StartDay8-FluentAPIs
-
StartDay9-ConcurrencyCheck-LayeredArchApproach-RepositoryPattern
-
-
ASP.Net Core 3.1 Web APIs
11 Lessons-
PreviewDay1-IntroductionToASP.NetCore3.1-StartUpClass-StaticWebsite
-
PreviewDay2-CreateWebAPI-Controller-Action-Model-Route-HTTPMethods-GetMethod-QueryString
-
StartDay3-CRUD-Fiddler-GC-Dispose-Using-DI
-
StartDay4-ServerSideValidation-HttpRequest-HttpResponse-ResponseCode-ActionResult-IActionResult
-
StartDay5-asyncActions-ScaffoldingController-ServerSideValidations-CustomValidations-CircularRefrencingProblem
-
StartDay6-CircularRefProblem2Approaches-LamdaExpession-JSONConvert-XMLSer-ExceptionAtAction-Excepti
-
StartDay7-Understanding SOA (Theory)
-
StartDay8-IntroductionToAuthAndAuthorization-ASPNetIdentityDbGeneration-IdentityDbCo
-
StartDay9-IntroductionToViewModel-UserRegistration-SignIn-And-SignOut
-
StartDay10-Authorization-Roles-Cookies-Principal-Identity-Claims
-
StartDay11-JWT-Authentication-Authorization
-
-
Angular 9
6 Lessons-
PreviewDay1-Introduction-GettingStarted-AngularJSVsAngular9-AppComponent-AppModule
-
PreviewDay2-TwoDataBinding-EventBinding-ngIf-ngFor-DataGrid-Bootstrap4
-
StartDay3-Searching-Sorting-Paging-HttpClient-MakingWebAPICall
-
StartDay4-DropdownListCascade-PostMethod-Models
-
StartDay5-successMsg-serverSideErrorMsg-ClientSideValidation-CRUD-ClientSideClassDesign-NavigationProperties-services
-
StartDay6-Routing-WebStorage
-
-
Angular 9 Live Project
15 Lessons-
StartDay1-SS-IntroToProject-BOL-DAL-WEBAPI-CustomIdentityUser-AsyncRepDesignPatte
-
StartDay2-SSWebAPIs-Creating UI With Batch File-All Initial Setups
-
StartDay3-PostStory-ApproveStory-ReadStory-ServerSideAuthenticationAndAuthorization-CookiesBased
-
StartDay4-ClientSide-Register-Login-Logout-ShowAndHideLinks
-
StartDay5-AuthGuard-HTTPIntercepters-JWTAuthentication-ApprovedAndPendingStoriesByUser
-
StartDay6-UploadingImageFile-ReadingImageFile-NavigationLoadingBar-PieChart-BarChart-DownloadCSV
-
StartDay7-SideNavBar-GoogleLoginIntegration
-
StartDay9-Subscribe-Observable-Unsbscribe-OnDestroy-ErrorHandlingAtUI-Child Component-CommunicatingParentAndChildComponent-ViewChild()-HandleTokenOrSessionExpiredOnUI
-
StartDay10-CRUDOperationsOnReactiveForms-SetValueVsPatchVal-UpdatingDbContext-Re
-
StartGetting Ready For Hosting Live
-
StartDay11-CreatingAccountInhostingServer-CearingDatabaseInHostServer-
-
StartDay12-CreatingSubDomainForUI-ProductionBuildVsDevBuildInAngular9-HostingUI-UseHashRoutes-1
-
StartDay13-UIInteractingWithAPI-AppSetting-WebConfig-FileZilla-UpdatesDeployment
-
StartDay14-GettingStartedWithAzureCloudHosting-First
-
StartDay15-DeployingAzureSQLDb-HostingWebAPIs-HostingAngular9UI-CreatingASendUpdatesEmailService-Sched
-